博客

最近在学习python, 按照网传方法的安装

step1:

pip uninstall MySQL-python
brew uninstall mysql
brew install mysql --universal
pip install MySQL-python

step2:

python -c ‘import MySQLdb’

Traceback (most recent call last):

File “<string>”, line 1, in <module>

File “/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/MySQLdb/__init__.py”, line 19, in <module>

import _mysql

ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/_mysql.so, 2): Symbol not found: _mysql_affected_rows

Referenced from: /Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/_mysql.so

Expected in: dynamic lookup

纠其原因是：

我需要使用robot framework 的 ideal  ride.py用来写自动化case. 而当初安装这个模块时需要


wxPython2.8。

config = {
    'host': '10.9****9',
    'port': 8**8,
    'user': 'root',
    'password': '****',
    'db': 'test_***',
    'charset': 'utf8mb4',
    'cursorclass': pymysql.cursors.DictCursor,
}

# Connect to the database
connection = pymysql.connect(**config)

解决办法二：

安装wxPython2.9， 参考链接：https://community.activestate.com/node/6641