Why Can't I Install MySQLdb on Google App Engine, and How Can I Fix the 'mysql_config Not Found' Error?

EnvironmentError: mysql_config Not Found

Problem:

During the installation of Django on a Google App Engine project, the server fails to start due to an error:

ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

Attempts to install the required module MySQL-python using pip yield the error:

raise EnvironmentError("%s not found" % (mysql_config.path,))
EnvironmentError: mysql_config not found

Solution:

Step 1:

• Ensure that the following steps have been completed:

  • Python is installed.
  • MySQL is installed using brew install mysql.
  • $PATH has been extended to include /usr/local/mysql/bin.
  • pip install MySQL-Python (or pip3 install mysqlclient if using Python 3) has been executed.

Step 2: If the issue persists, try the following steps:

Method 1:

• Run which mysql_config in the terminal.
• If it returns an empty result, use locate mysql_config to find the path to the binary.
• Add the path to $PATH or modify the setup.py file to specify the location of mysql_config.

Method 2:

• Use mysql-connector-python instead of MySQL-Python. To install it, run pip install mysql-connector-python.

Method 3:

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

Method 4:

• Install MySQL using MacPorts. After installation, set $PATH to include /opt/local/lib/mysql5/bin.

Note:

• Consider trying python-dev and libmysqlclient-dev packages if available.
• Running commands as root may be necessary.

The above is the detailed content of Why Can't I Install MySQLdb on Google App Engine, and How Can I Fix the 'mysql_config Not Found' Error?. For more information, please follow other related articles on the PHP Chinese website!