SHOW GRANTS FOR 'user'@'x.x.x.x';
SELECT........read only INSERT........insert rows/data UPDATE........change inserted rows/data DELETE........delete drop rows of data
Table manipulation: CREATE DROP ALTER
GRANT ALL PRIVILEGES ON databasename.* TO 'user'@'x.x.x.x';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'x.x.x.x';
flush privileges;