Permissions / Grants

Grants

GRANT ALL ON *.* TO 'user'@'localhost' IDENTIFIED BY 'somepassword';
GRANT ALL ON database.* TO 'user'@'localhost' IDENTIFIED BY 'somepassword';
GRANT ALL ON database.table TO 'user'@'localhost' IDENTIFIED BY 'somepassword';

GRANT insert ON *.* TO 'user'@'localhost' IDENTIFIED BY 'somepassword';
GRANT select ON database.* TO 'user'@'localhost' IDENTIFIED BY 'somepassword';
GRANT insert,select,update ON database.table TO 'user'@'localhost' IDENTIFIED BY 'somepassword';

.end