Some MySQL stuff

Here is an overview of useful MySQL commands

Here is a full description of how to add a new MySQL user.

Delete a row from a table
Delete a row(s) from a table.
DELETE from [table name] where [field name] = 'whatever';

Add a MySQL user

mysql> use mysql;
Database changed

mysql> INSERT INTO user (host, user, password, select_priv, insert_priv, update_ priv) VALUES ('localhost', 'chris', PASSWORD('password'), 'Y', 'Y', 'Y');
Query OK, 1 row affected (0.20 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 1 row affected (0.01 sec)