Home >Database >Mysql Tutorial >How to solve the problem of missing mysql config

How to solve the problem of missing mysql config

藏色散人
藏色散人Original
2020-10-08 18:14:263224browse

The solution to the missing mysql config: first use to check the installation status of mysql; then remove the existing installation package; then download the 64bit rpm file; finally re-use "rpm -ivh MySQL-devel-5.5. 16-1.linux..." can be installed.

How to solve the problem of missing mysql config

Recommended: "mysql tutorial"

MySQL is missing the mysql_config file

Question:

You need to arrange the django-sentry log server at work. When pip install mysql-python on centos-6.4, the error is reported as follows

[sentry@kjtest111 mysql-python]$ pip install mysql-python
Downloading/unpacking mysql-python
  Running setup.py egg_info for package mysql-python
    sh: /usr/bin/mysql_config: No such file or directory
    Traceback (most recent call last):
      File "<string>", line 16, in <module>
      File "/tmp/pip-build-sentry/mysql-python/setup.py", line 18, in <module>
        metadata, options = get_config()
      File "setup_posix.py", line 43, in get_config
        libs = mysql_config("libs_r")
      File "setup_posix.py", line 25, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    EnvironmentError: /usr/bin/mysql_config not found
    Complete output from command python setup.py egg_info:
    sh: /usr/bin/mysql_config: No such file or directory
Traceback (most recent call last):
  File "<string>", line 16, in <module>
  File "/tmp/pip-build-sentry/mysql-python/setup.py", line 18, in <module>
    metadata, options = get_config()
  File "setup_posix.py", line 43, in get_config
    libs = mysql_config("libs_r")
  File "setup_posix.py", line 25, in mysql_config
    raise EnvironmentError("%s not found" % (mysql_config.path,))
EnvironmentError: mysql_config not found
----------------------------------------

Working environment: centOS6.4

Solution:

1. Through the error message, it can be seen that mysql_config is missing, and it should be under /usr/bin/ There is no mysql_config file. The online solutions are apt-get install libmysqlclient-dev, but apt-get is the network installation command for Debian and Ubuntu series, and yum is the network installation command for Redhat, Centos, and Fedora. Then I found that it should be installed on Centos. mysql-devel

2. yum install mysql-devel, a conflict is found, the error is as follows:

--> Running transaction check
---> Package mysql-devel.x86_64 0:5.1.69-1.el6_4 will be installed
--> Processing Dependency: mysql = 5.1.69-1.el6_4 for package: mysql-devel-5.1.69-1.el6_4.x86_64
--> Running transaction check
---> Package mysql.x86_64 0:5.1.69-1.el6_4 will be installed
--> Processing Conflict: MySQL-client-5.5.30-1.el6.x86_64 conflicts mysql
--> Processing Conflict: MySQL-server-5.5.30-1.el6.x86_64 conflicts mysql
--> Processing Conflict: mysql-5.1.69-1.el6_4.x86_64 conflicts MySQL
--> Finished Dependency Resolution
Error: mysql conflicts with MySQL-devel-5.5.30-1.el6.x86_64
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

3. Use rpm -qa| grep mysql to check the installation status of mysql

mysql-devel-5.5.16-1.el6_4.x86_64
mysql-client-5.5.16-1.el6_4.x86_64
mysql-server-5.5.16-1.el6_4.x86_64

4. Use rpm -e mysql-devel-5.5.16-1.el6_4.x86_64 to remove the existing installation package

5. Use yum install mysql-devel again and find that there is a conflict with the versions of mysql-server and mysql-client

6. Go online to find the same version Download http://downloads.skysql.com/archive/index/p/mysql/v/5.5.16, download the 64bit rpm file, use rpm -ivh MySQL-devel-5.5.16-1.linux2.6.x86_64 .rpm installation

7. After the installation is successful, go to the /usr/bin/ directory and find that the mysql_config file has been generated. Continue pip install mysql-python and it is successfully completed.

The above is the detailed content of How to solve the problem of missing mysql config. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn