Greetings,
I'm so curious about this:
If a new MySQL database account need to be created, do you insert the account info to the *user* table of the *mysql* database OR do you grant the new account by the GRANT query? What are the differences andn which one do you prefer?
Generally, it's preferable to use GRANT. It's simpler, and you don't need to figure out just which changes to make to the grant tables in the mysql database. With GRANT, the server figures out the changes and makes them for you.
GRANT also causes the server to reread the grant tables, so you don't need to use FLUSH PRIVILEGES.
http://www.mysql.com/doc/en/User_Account_Management.html
(I got some trouble when I tried to use the insert, don't know why, just doesn't work. It seems that the GRANT query is the easiest way to achieve that and works perfectly without issuing the FLUSH PRIVILEGES statement.)
cheers,
feng
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
