MYSQL permission per user per table

By

Published January 11, 2013 at 3:24 PM

Granting permission to an existing user:

GRANT SELECT,INSERT,UPDATE,DELETE ON database_name.table_name TO 'username'@'localhost';

 

Creating a new user while applying permissions:

GRANT SELECT,INSERT,UPDATE,DELETE ON database_name.table_name TO 'username'@'localhost' IDENTIFIED BY 'password';