2013年10月22日 星期二

[python][mysql]install mysqldb fail : EnvironmentError: mysql_config not found

OS X 安裝 MySQLdb for Python


解决mysql_config not found錯誤

剛剛要安裝MySQLdb for python on mac. 結果中途出現 [EnvironmentError: mysql_config not found]

似乎是找不到mysql_config位置找不到

收尋一下自己mac上mysql_config位置是在:/usr/local/mysql/bin/mysql_config

完整步驟如下:
1.   Download MySQLdb (MySQL-python-1.2.4b4.tar.gz)
2.   tar -zxvf MySQL-python-1.2.4b4.tar.gz
3.   cd MySQL-python-1.2.4b4
4.   python setup.py build ==> error
5.   vim site.cfg 找到 mysql_config = xxxxxx  (換成自己mysql_config位置)
6.   python setup.py build
7.   sudo python setup.py install

以上

解決Reason: image not found 錯誤

在終端機下
$ sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib $ sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql


再來就是測試一下python是否可以連mysql

mysql_test.py
----------------------------------------------------
# -*- coding: utf-8-*-
#!/usr/bin/python

#引入 mysql module
import MySQLdb

# connect to mysql
db = MySQLdb.connect(host="localhost", user="user", passwd="passwd", db="dbname")
cursor = db.cursor()

# exec sql
cursor.execute("select * from db_table_name")
result = cursor.fetchall()

# output
for record in result:
        print record[0]
        print record[1]

        print record[2]
----------------------------------------------------

my result :
-------------------------
1
The title
This is the post body.
2
A title once again
And the post body follows.
3
Title strikes back
This is really exciting! Not.
----------------------------

搞定

lichain . 2013/10/22