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;