How Can I Successfully Install MySQLdb on Mac OS X?

Installing MySQLdb on Mac OS X

Getting MySQLdb, a Python data access library for MySQL, up and running on Mac OS X can be a challenging task. Here's a comprehensive guide to overcome the common obstacles and ensure a smooth installation:

Note for Python 3 Users:

Use conda install mysqlclient to install the necessary libraries. This will install mysqlclient, mysql-connector, and llvmdev.

For Previous Mac OS X Versions:

1. Install 32-bit MySQL: Uninstall any 64-bit versions and obtain the 32-bit package instead.
2. Obtain and Extract MySQLdb: Download the latest MySQLdb package from SourceForge and extract the contents.
3. Clean the Installation: Run "sudo python setup.py clean" within the extracted folder.
4. Remove Old Files: Delete any remnants in the MySQL-python-1.2.2/build/ directory and remove the egg under Users/$USER/.python-eggs.
5. Create Symbolic Link: Execute "sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql" to establish a link to the mysql sub-directory.
6. Edit setup_posix.py: Change "mysql_config.path = 'mysql_config'" to "mysql_config.path = '/usr/local/mysql/bin/mysql_config'".
7. Rebuild and Install: Run "sudo python setup.py build" and then "sudo python setup.py install".
8. Test Installation: Verify by importing MySQLdb in Python: "python >>> import MySQLdb"
9. Additional Symlink for libmysqlclient.18.dylib Error: If encountered, execute: "sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib".

Common Error:

If the error "Module _mysql was already imported from..." appears, exit the build directory by "cd .." to resolve it.

The above is the detailed content of How Can I Successfully Install MySQLdb on Mac OS X?. For more information, please follow other related articles on the PHP Chinese website!