MySQL notes:

INSTALLING:
install OS X package from
http://dev.mysql.com/downloads/mysql/5.1.html#macosx-dmg

CONFIGURING:
- create aliases for mysql and mysqladmin
$ alias mysql=/usr/local/mysql/bin/mysql
$ alias mysqladmin=/usr/local/mysql/bin/mysqladmin 

- set root password
$ mysqladmin -u root password somepassword

- then log in
$ mysql -u root -p

- then add a user
mysql> GRANT ALL PRIVILEGES ON *.* TO 'bob'@'localhost'
	-> IDENTIFIED BY 'password' WITH GRANT OPTION;

- then test user
$ mysql -u bob -p

TO WORK WITH PROCESSING:
follow instructions at http://www.bezier.de/mysql/

USEFUL COMMANDS:
mysql> show databases; // see all databases
mysql> connect [database name]; //connect to a specific database
mysql> show tables; //see all tables in a database
mysql> SELECT * FROM [table name]; //view all contents of a table
mysql> drop table [table name]; //delete a table

COMMAND REFERENCE:
http://www.pantz.org/software/mysql/mysqlcommands.html