Why am I getting "Library not loaded: libmysqlclient.16.dylib" when importing MySQLdb on Mac 10.6?

Python import MySQLdb Error on Mac 10.6

When attempting to import the MySQLdb package in Python on a Mac 10.6 system, users may encounter an error related to a missing library: "Library not loaded: libmysqlclient.16.dylib." This error commonly arises after installing both MySQL and MySQLdb.

Troubleshooting Steps:

The error message suggests that the MySQL C client library cannot be found. To resolve this, ensure that the following steps have been completed:

• Install MySQL: Visit the MySQL download page and install MySQL 5.5.8 or a compatible version.
• Install MySQLdb Python Plugin: Obtain the MySQLdb package from PyPI or SourceForge. Install it using pip or the appropriate method based on your system's requirements.

Troubleshooting on Mac 10.6:

For Mac 10.6 users, an additional bug and workaround need consideration.

• Check libmysqlclient.16.dylib Existence: Ensure that the library file "libmysqlclient.16.dylib" exists in "/usr/local/mysql/lib." If not, install the missing file from the MySQL distribution.

• Possible Workaround: As suggested in MySQL bug 59006, create symbolic links:

  • 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

Other Potential Solutions:

• Check Library Path: Verify the value of DYLD_LIBRARY_PATH and ensure it includes the path to the required MySQL library.
• Clean Python Egg Files: Remove any existing MySQLdb egg files and reinstall the package.
• Verify Output of otool Commands: Use the otool command to check the contents of the libraries involved and confirm if the appropriate references exist.

Additional Notes:

• The specific library version may vary depending on the MySQL distribution used. Adjust the version numbers in the symbolic link commands accordingly.
• If the issue persists, consult the official MySQL documentation or seek assistance from the MySQL community forums.

The above is the detailed content of Why am I getting "Library not loaded: libmysqlclient.16.dylib" when importing MySQLdb on Mac 10.6?. For more information, please follow other related articles on the PHP Chinese website!