--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/mysql.1.txt	Sun Nov 25 11:41:05 2007 +0100
@@ -0,0 +1,22 @@
+MYSQL
+* Create a database
+  CREATE DATABASE dbname;
+* Add a new user
+  - Connect to the database:
+    mysql -u root -p mysql
+  - Add the user:
+    GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
+    (*.* can be database.table)
+    (omit WITH GRANT OPTION, if it should not grant)
+    Other privileges:
+       RELOAD,PROCESS,USAGE
+  - Flush privileges:
+    FLUSH PRIVILEGES;
+
+* Change the password of a user:
+  - SQL:
+    UPDATE mysql.user SET Password=PASSWORD('newpwd')
+     WHERE User='username';
+     FLUSH PRIVILEGES;
+  - Shell:
+    mysqladmin -u username -h hostname password 'new-password'