Showing GRANTS for a user

SHOW GRANTS FOR 'user'@'x.x.x.x';

Database manipulation

SELECT........read only

INSERT........insert rows/data

UPDATE........change inserted rows/data

DELETE........delete drop rows of data

Table Manipulation

Table manipulation:

CREATE
DROP
ALTER

Granting ALL Privileges on a db

GRANT ALL PRIVILEGES ON databasename.* TO 'user'@'x.x.x.x';

Granting ALL Privileges on ALL dbs

GRANT ALL PRIVILEGES ON *.* TO 'user'@'x.x.x.x';


REMEMBER To Flush Privileges

flush privileges;