Why is `mysql-python` Failing to Import on macOS X Lion Despite Correct Installations?

"mysql-python" Installation Problems on MacOS X Lion

Problem:

When attempting to import MySQLdb in Python 2.7 on macOS X Lion x86_64, an ImportError exception is encountered, indicating that a suitable image for the _mysql.so file cannot be found, despite the correct versions of MySQL, Python, and mysql-python being installed.

Solution:

1. Override the Environment:

• Modify the DYLD_LIBRARY_PATH environment variable to include the location of MySQL's libraries:

  export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/

  Copy after login

2. Use Homebrew:

• Install Homebrew package manager
• Install Python using Homebrew: "brew install python"
• Install MySQL using Homebrew: "brew install mysql"
• Install mysql-python using easy_install: "/usr/local/share/python/easy_install mysql-python"

Notes:

• Ensure that /usr/local/bin is added to the PATH ahead of /usr/bin and /bin.
• Consider adding /usr/local/share/python to the PATH for permanent modification.

Additional Considerations:

• Verify that the installed versions of MySQL, Python, and mysql-python are compatible.
• Check if any other system-wide settings or packages may be interfering with the installation or operation of mysql-python.

The above is the detailed content of Why is `mysql-python` Failing to Import on macOS X Lion Despite Correct Installations?. For more information, please follow other related articles on the PHP Chinese website!