CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
DROP USER ‘newuser’@‘localhost’;
SET PASSWORD FOR 'newuser'@'localhost' = PASSWORD('mypass');
GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’; REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;