How To Create a User and Grant Permissions in MySQL

How to create a user

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';

DROP USER 'myuser'@'localhost';

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

FLUSH PRIVILEGES;

ALL PRIVILEGES : Full access to everything, globally unless restricted to a database

CREATE : Create databases and tables

DROP : Delete databases and tables

DELETE : Delete rows from tables

INSERT : Insert rows in tables

SELECT : Read data from tables

UPDATE : Update rows in tables

GRANT OPTION : Grant or remote other user’s permissions

GRANT permission_type ON database_name.table_name TO 'myuser'@'localhost';

REVOKE permission_type ON database_name.table_name FROM 'myuser'@'localhost';

SHOW GRANTS myuser;