Posted on Tuesday 29th January 2019 in Snippet
When working with a mysql database, you may need to add additional users for many reasons, following is a selection of commands to do this simply.
Change username password,database_name and table_name to the real values.
Create a User
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
Add All Privileges
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
Add Specific Permission
GRANT type_of_permission ON database_name.table_name TO ‘username’@'localhost’;
Remove Specific Permission
REVOKE type_of_permission ON database_name.table_name FROM ‘username’@‘localhost’;
DROP USER ‘username’@‘localhost’;
SHOW GRANTS username;