mac osx安装mysql mysql-python折腾记

来源：互联网发布：mac软件卸载不掉编辑：程序博客网时间：2024/06/06 08:34

两天的折腾结果：

问题一：

import MySQLdb

Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/Library/Python/2.7/site-packages/MySQLdb/__init__.py", line 19, in <module>
import _mysql
ImportError: dlopen(/Library/Python/2.7/site-packages/_mysql.so, 2): Symbol not found: _mysql_affected_rows
Referenced from: /Library/Python/2.7/site-packages/_mysql.so
Expected in: flat namespace

in /Library/Python/2.7/site-packages/_mysql.so

关闭mysql 重新安装mysql-python:

admin$:mysql.server stop

admin$:sudo pip uninstall MySQL-python

admin$:sudo pip install MySQL-python

问题二：

    Traceback (most recent call last):        ...        import MySQLdb      File "/Users/cole/Library/Python/2.5/site-packages/MySQLdb/__init__.py", line 19, in <module>        import _mysql    ImportError: dlopen(/Users/cole/Library/Python/2.5/site-packages/_mysql.so, 2): Library not loaded: /usr/local/lib/libmysqlclient.18.dylib      Referenced from: /Users/cole/Library/Python/2.5/site-packages/_mysql.so      Reason: no suitable image found.  Did find:        /usr/local/lib/libmysqlclient.18.dylib: mach-o, but wrong architecture        /usr/local/lib/libmysqlclient.18.dylib: mach-o, but wrong architecture

pip uninstall MySQL-pythonbrew uninstall mysqlbrew install mysql --universalpip install MySQL-python

参考：

http://madebyhoundstooth.com/blog/install-mysql-on-mountain-lion-with-homebrew/

https://gist.github.com/cole/1272701