MySQL – Create / Delete Users and Manage PRIVILEGES

MySQL – Create / Delete User and Manage PRIVILEGES

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

FLUSH PRIVILEGES;

GRANT type_of_permission ON database_name.table_name TO ‘username’@'localhost’;

REVOKE type_of_permission ON database_name.table_name FROM ‘username’@‘localhost’;

SHOW GRANTS username;

DROP USER ‘username’@‘localhost’;