Commands

Command syntax will vary between MySQL Versions

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

User Management

Show all users

SELECT user, host FROM mysql. user;

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

Add User

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

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

Granting Privileges

Available privileges:

GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD

Grant specific privilege ( or multiple comma separated):

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

or

Grant all:

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

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

AddDelete Usera user

CREATEDROP USER 'name'@'localhost' IDENTIFIED BY 'password.'host';

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

Set user password

 

Change user password

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

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

Database Management

Create a database

CREATE DATABASE name;

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

GrantingDelete Privilegesa database

Available privileges:

GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD

Grant specific privilege ( or multiple comma separated):

GRANTDROP PRIVILEGEDATABASE ON database.table TO 'username'@'host';name;

or====================================================================================

Grant all:

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

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