Sql commands

SHOW DATABASES;

DROP DATABASE <database name>;

CREATE DATABASE <database name>;

CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';

GRANT ALL PRIVILEGES ON <database_name>.* TO 'username'@'localhost';

SHOW GRANTS FOR 'username'@'localhost';

DROP USER 'username'@'localhost';

FLUSH PRIVILEGES;

show users:

use mysql;
SELECT user FROM user;