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

EnvironmentError: mysql_config not found on Mac OS X

When attempting to install MySQL-python, users may encounter the "EnvironmentError: mysql_config not found" error. To address this issue, consider the following steps:

1. Verify System Configuration:

• Ensure that Python is installed.
• Run "brew install mysql" to install MySQL.
• Export the PATH variable to include "/usr/local/mysql/bin": export PATH=$PATH:/usr/local/mysql/bin.

2. Locate mysql_config Binary:

• Run "which mysql_config" to verify its location (it may not be found).
• Use "locate mysql_config" to search for the binary. Ensure its path is set in the $PATH variable.

3. Alternative Installation Methods:

• Consider using "mysql-connector-python" instead of MySQL-Python: pip install mysql-connector-python.
• Manually locate the locations of "mysql/bin", "mysql_config", and "MySQL-Python" and add them to the $PATH variable.

4. MacPorts Installation:

• Install "mysql" using MacPorts.
• The binary will be named "mysql_config5".
• Set the PATH variable: export PATH=$PATH:/opt/local/lib/mysql5/bin.

5. Other Considerations:

• Install "python-dev" and "libmysqlclient-dev" packages (if available on Mac OS).
• Try running the commands as root.

Refer to the following resources for further assistance:

• [pip install mysql-python fails with EnvironmentError: mysql_config not found](https://stackoverflow.com/questions/22217748/pip-install-mysql-python-fails-with-environmenterror-mysql-config-not-found)
• [EnvironmentError pip install mysqlclient on Mac OS X with Python 2.7](https://stackoverflow.com/questions/27034163/environmenterror-pip-install-mysqlclient-on-mac-os-x-with-python-2-7)
• [Can't install MySQLdb on mac osx lion using pip](https://stackoverflow.com/questions/10853897/cant-install-mysqldb-on-mac-osx-lion-using-pip)
• [MySQL-Python won’t install, 'mysql_config' not found](http://stackoverflow.com/questions/8674050/mysql-python-wont-install-mysql-config-not-found)

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