User and Database Management

Command syntax will vary between MySQL Versions

====================================================================================

SELECT user, host FROM mysql. user;

CREATE USER 'name'@'localhost' IDENTIFIED BY 'password.';

Available privileges:

CREATE	Allows the user to create new databases and tables.
ALTER	Allows the user to alter (modify) existing tables.
DROP	Allows the user to drop (delete) databases and tables.
INSERT	Allows the user to insert new rows into tables.
UPDATE	Allows the user to update existing rows in tables.
DELETE	Allows the user to delete rows from tables.
SELECT	Allows the user to read (select) data from tables.
REFERENCES	Allows the user to create foreign key constraints when defining tables.
RELOAD	Allows the user to execute the `FLUSH` statement, which reloads various server configurations and clears or refreshes caches.

Grant specific privilege ( or multiple comma separated):

GRANT PRIVILEGETYPE ON database.table TO 'username'@'host';
FLUSH PRIVILEGES;

Grant all:

GRANT ALL ON database.table TO 'username'@'host';
FLUSH PRIVILEGES;

DROP USER 'name'@'host';

Change user password

ALTER USER 'user'@'host' IDENTIFIED BY 'NewPassword';
FLUSH PRIVILEGES;

====================================================================================

CREATE DATABASE name;

------------------------------------------------------------------------------------------------------------------------------------------------

DROP DATABASE name;

====================================================================================