Permissions help

[rrsub]

Could someone point me, tell me, etc.. the recommended permissions for users for a MySQL database?

Currently users have full access to the mysql database and user table and I'm at a loss to restrict that.

 

[sleipnir214]

I don't suppose there are any canonical permissions to set. It depends on what you will and will not allow users to do.

Permissions are described in the online documentation for the GRANT command:

http://www.mysql.com/doc/en/GRANT.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!