When deploying a Django project on CentOS, it is often necessary to install the MySQL database engine, such as mysqlclient. When executing the pip3 install mysqlclient command, the following error may be reported:
ERROR: Command errored out with exit status 1:
command:/usr/bin/python3 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-zmnd8v74/mysqlclient/setup.py'"'"'; __file__='"'"'/tmp/pip-install-zmnd8v74/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-pip-egg-info-jpy0d_w0
cwd:/tmp/pip-install-zmnd8v74/mysqlclient/
Complete output(12 lines):/bin/sh: mysql_config: command not found
/bin/sh: mariadb_config: command not found
/bin/sh: mysql_config: command not found
Traceback(most recent call last):
File "<string>", line 1,in<module>
File "/tmp/pip-install-zmnd8v74/mysqlclient/setup.py", line 15,in<module>
metadata, options =get_config()
File "/tmp/pip-install-zmnd8v74/mysqlclient/setup_posix.py", line 65,in get_config
libs =mysql_config("libs")
File "/tmp/pip-install-zmnd8v74/mysqlclient/setup_posix.py", line 31,in mysql_config
raise OSError("{} not found".format(_mysql_config_path))
OSError: mysql_config not found
----------------------------------------
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
This is because the mysql-devel package is missing and needs to be installed now. At the same time, in order to resolve package version conflicts and dependency conflicts, you need to download and install the yum source of mysql. The command is as follows:
# Download the rpm package of the yum source of the corresponding version of mysql
wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
# Install the rpm package
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
Then execute the yum install mysql-devel command to install the mysql-devel package and print as follows:
Loaded plugins: fastestmirror
mysql-connectors-community |2.6 kB 00:00:00
mysql-tools-community |2.6 kB 00:00:00
mysql57-community |2.6 kB 00:00:00
Loading mirror speeds from cached hostfile
Resolving Dependencies
- - > Running transaction check
- - - > Package mysql-community-devel.x86_64 0:5.7.32-1.el7 will be installed
- - > Finished Dependency Resolution
The mysql-devel package is installed successfully.
Finally, execute the pip3 install mysqlclient command to successfully install the mysqlclient engine.
Recommended Posts