I could write the statement for you if you could answer these three
things:
1) which user account would you like to modify the permissions of.
2) which database are you granting access to
3) what permissions do you want the user account of 1) to have on the
database of 2)
Respectfully,
Shawn Gr
If you do not use the GRANT, REVOKE, and DROP USER statements to create
and destroy user accounts, you must manually FLUSH PRIVILEGES. It's all
documented in the manual:
http://dev.mysql.com/doc/mysql/en/GRANT.html
and in even more detail here:
http://dev.mysql.com/doc/mysql/en/User_Account_M
Hi, all:
I use root login to create a new databse in the existing server.
Then I use the existing user name in the mysql user table as user name,
add the database and username .. info into mysql db table. Then
mysqladmin to load the table. When I login the database using the
existing user name
