1. Goto http://dev.mysql.com/downloads/mysql/ 2. Select Platform: "Mac OS X" 3. Download mysql-5.5.11-osx10.6-x86.tar.gz (Mac OS X ver. 10.6 (x86, 32-bit), Compressed TAR Archive) 4. Unzip it 5. Copy include folder into /Applications/MAMP/Library 6. Copy lib/* files into /Applications/MAMP/Library/lib
---- 1. Goto http://sourceforge.net/projects/mysql-python/ 2. Download MySQL-python-1.2.3.tar.gz 3. unzip it
---- 1. virtualenv --no-site-package test 2. cd test/bin 3. source activate 4. lipo -remove x86_64 ./python -output ./python
---- 1. cd MySQL-python-1.2.3 2. vim setup_posix.py 3. search mysql_config.path 4. set the value to /Applications/MAMP/Library/bin/mysql_config 5. save and exit 6. python setup.py install
---- import _mysql
db = _mysql.connect(unix_socket="/Applications/MAMP/tmp/mysql/mysql.sock",db="mysql",user="root",passwd="root")
db.query("select version()")
result = db.use_result() / result = db.store_result() result.fetch_row()