1
edit
Changes
no edit summary
=Mohak=
* View privileges for a user:
SHOW GRANTS FOR 'root'@'localhost';
* Give user rights:
GRANT CREATE, INSERT ON vyas.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD 'password hash';
You can give a plain text password but it's better to use hash if you know your password hash.
*
= Milton =