I have read and re-read the security section in a mySQL book I have, and am just not getting it. What I am not entirely getting is the GRANT statement. I want to create a database such that the user "test" can do most anything (inserts, deletes, selects, create tables, etc) with a password of "foo". Would the statement
GRANT ALL ON * TO test@localhost 'foo';
do what I am needing it to do? Is the first part of the email (before the @) the username?
Thank you.
Chester
GRANT ALL ON * TO test@localhost 'foo';
do what I am needing it to do? Is the first part of the email (before the @) the username?
Thank you.
Chester