How to Fix the 'mysql_config not found' Error When Installing MySQLdb for Django on macOS?

Mac OS X: Resolving "mysql_config not found" Error for Django MySQLdb

Problem Description:

When attempting to install the Django framework for use with Google App Engine, an error occurs due to the absence of the MySQLdb module:

ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

Installing MySQL-Python, as suggested online, yields the following error:

EnvironmentError: mysql_config not found

Solution:

Follow these steps to resolve the issue:

1. Check if MySQL Configuration is Missing:

   • Run the command which mysql_config to check for the location of the mysql_config executable. If not found, use locate mysql_config to attempt to locate it.

2. Use MySQL Connector Python:

   • Install mysql-connector-python using: pip install mysql-connector-python.
   • Follow the documentation at https://dev.mysql.com/doc/connector-python/en/connector-python-introduction.html.

3. Update $PATH Environment Variable:

   • Manually locate the paths to mysql/bin, mysql_config, and MySQL-Python, and add them to the $PATH environment variable.

4. Install MySQL with MacPorts:

   • Install MySQL using MacPorts (https://www.macports.org/install.php).
   • Rename mysql_config to mysql_config5.
   • Set the $PATH variable: export PATH=$PATH:/opt/local/lib/mysql5/bin.

5. Install Additional Packages (Optional):

   • Try installing python-dev and libmysqlclient-dev (these packages may not be available on Mac OS).

Additional Notes:

• Run the commands as root if necessary.

• Refer to the following resources for further assistance:

  • https://stackoverflow.com/questions/27598786/pip-install-mysql-python-fails-with-environmenterror-mysql-config-not-found
  • https://stackoverflow.com/questions/21573668/pip-install-mysqlclient-gives-error-mysql-config-not-found
  • https://community.oracle.com/tech/developers/discussion/4178520/error-mysql-config-not-found
  • https://mysqlclient.readthedocs.io/en/latest/faq.html#where-can-i-find-mysql-config

The above is the detailed content of How to Fix the 'mysql_config not found' Error When Installing MySQLdb for Django on macOS?. For more information, please follow other related articles on the PHP Chinese website!