installing mysql

1. downloaded mysql package from website

• google 'mysql community download'
• downloaded Mac OS X 10.7 (x86, 64-bit), DMG Archive
• (mysql-5.6.15-osx10.7-x86_64.dmg)
• installed 'mysql-5.6.15-osx10.7-x86_64.pkg' and 'MySQLStartupItem.pkg' and MySQL.prefPane

2. added /usr/local/mysql/bin to path:

• sudo nano /etc/paths

3. change the root password

• mysql -u root
• mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('******');
• Query OK, 0 rows affected (0.00 sec)

 4. added user jmtoung

• mysql> mysql> CREATE USER 'jmtoung'@'localhost' IDENTIFIED BY '*******';
• Query OK, 0 rows affected (0.00 sec)
• mysql> GRANT ALL PRIVILEGES ON * . * TO 'jmtoung'@'localhost';
• Query OK, 0 rows affected (0.00 sec)

5. install MySQL for python

• downloaded MySQL-python-1.2.4b4
• tar xzvf " "
• python setup.py build &> setup-build.log

6. fixed library issue

• [jmtoung@dn2m1i7oq:/usr/lib]: sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib