Ubuntu

Mysql Cheat Sheet for Grant Permissions

Submitted by sklav on Fri, 02/04/2011 - 11:11

An example of how to add SELECT privileges to a user using GRANT

GRANT SELECT ON projectdb.* TO user@'localhost' IDENTIFIED BY 'passwd';

If SELECT is not enough for our user we can add more privileges using a query similar to the one below:

An example of how to add a selection of privileges to a user using GRANT

GRANT SELECT, INSERT, DELETE ON projectdb.* TO user@'localhost' IDENTIFIED BY 'passwd';

If you want to GRANT ALL the privileges to a user then use this query:

An example of how to Grant Privileges in MySQL