How to Fix 'EnvironmentError: mysql_config not found' When Installing MySQL-Python on macOS?

Mac OS X: Resolving "EnvironmentError: mysql_config not found" When Installing MySQL-Python

Upon attempting to use Django on a Google App Engine project, an error message regarding an unavailable module, such as "ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb," is often encountered. Despite attempts to install MySQL-Python via pip, the error persists with the message "EnvironmentError: mysql_config not found."

To resolve this issue, ensure that the following steps have been completed:

• Python has been installed.
• "brew install mysql" has been executed.
• "export PATH=$PATH:/usr/local/mysql/bin" has been executed.
• "pip install MySQL-Python" has been attempted (or "pip3 install mysqlclient" for Python 3).

If the error persists after these steps, consider the following additional troubleshooting measures:

1. Verify that "which mysql_config" returns an invalid path. If no output is generated, proceed to "locate mysql_config" to identify the binary's location. Ensure that this path is included in the $PATH environment variable or explicitly specified in the module's setup.py file.
2. Explore using "mysql-connector-python" as an alternative to MySQL-Python. This package can be installed via "pip install mysql-connector-python."
3. Manually locate the directories containing "mysql/bin," "mysql_config," and "MySQL-Python" and add them to the $PATH environment variable.
4. If all previous steps fail, consider installing "mysql" using MacPorts. In this case, "mysql_config" will be named "mysql_config5," requiring the execution of "export PATH=$PATH:/opt/local/lib/mysql5/bin" after installation.

Additionally, consider attempting the following:

• Installing "python-dev" and "libmysqlclient-dev" (availability on Mac OS uncertain).
• Running commands as root.

By following these troubleshooting steps, it should be possible to resolve the "EnvironmentError: mysql_config not found" issue when installing MySQL-Python on Mac OS X.

The above is the detailed content of How to Fix 'EnvironmentError: mysql_config not found' When Installing MySQL-Python on macOS?. For more information, please follow other related articles on the PHP Chinese website!