Mysql5.5升级到5.7后MySQLdb不能正常使用的问题解决
ubuntu系统
报错信息1
Type "help", "copyright", "credits" or "license" for more information. >>> import MySQLdb Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/local/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 19, in <module> import _mysql
报错信息2
shufeng@shufeng-H97-D3H:/etc/mysql$ pip uninstall MySQL-python^C shufeng@shufeng-H97-D3H:/etc/mysql$ pip install MySQL-python Collecting MySQL-python Using cached MySQL-python-1.2.5.zip Complete output from command python setup.py egg_info: sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pip-build-YdPi5P/MySQL-python/setup.py", line 17, in <module> metadata, options = get_config() File "setup_posix.py", line 43, in get_config libs = mysql_config("libs_r") File "setup_posix.py", line 25, in mysql_config raise EnvironmentError("%s not found" % (mysql_config.path,)) EnvironmentError: mysql_config not found ---------------------------------------- Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-YdPi5P/MySQL-python/
解决方法:
$ sudo pip uninstall MySQL-python $ sudo apt-get install libmysqlclient-dev $ sudo pip install MySQL-python