===Showing GRANTS for a user===
<sxh bash>
SHOW GRANTS FOR 'user'@'x.x.x.x';
</sxh>


==== Database manipulation ====
<sxh bash>
SELECT........read only

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

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

DELETE........delete drop rows of data
</sxh>
=== Table Manipulation ===
<sxh bash>
Table manipulation:

CREATE
DROP
ALTER
</sxh>
\\

=== Granting ALL Privileges on a db ===

<sxh bash>
GRANT ALL PRIVILEGES ON databasename.* TO 'user'@'x.x.x.x';
</sxh>
\\
===Granting ALL Privileges on ALL dbs ===

<sxh bash>
GRANT ALL PRIVILEGES ON *.* TO 'user'@'x.x.x.x';
</sxh>

\\
====REMEMBER To Flush Privileges====
<sxh bash>
flush privileges;
</sxh>

\\