记录 centos7 python 2.7 安装mysql-python中遇到的问题

最新推荐文章于 2021-09-23 15:58:20 发布
最新推荐文章于 2021-09-23 15:58:20 发布
阅读量2.4k 收藏
点赞数
分类专栏： 大数据 文章标签： pip install mysql-python
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hnmpf/article/details/88389730
版权

场景：

      我们在使用python 进行简单项目开发的时候或许会考虑使用cgi作为服务（因为主流WEB服务器基本都支持CGI）,本次以HTTPD作为WEB服务器进行python 链接MYSQL数据库测试中遇到的问题 

1、执行“pip install mysql-python”命令，我们收到了如下代码片段的错误

[root@hdfs-master cgi-bin]# pip install mysql-python
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting mysql-python
  Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
    Complete output from command python setup.py egg_info:
    sh: mysql_config: command not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-install-YlIQYH/mysql-python/setup.py", line 17, 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
    
    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-install-YlIQYH/mysql-python/

2、经过资料查询，我们需要执行“yum install mysql-devel”进行一些mysql的配置

[root@hdfs-master cgi-bin]# yum install mysql-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * epel: mirrors.yun-idc.com
 * extras: mirrors.aliyun.com
 * updates: mirrors.aliyun.com
Resolving Dependencies
--> Running transaction check
---> Package mariadb-devel.x86_64 1:5.5.60-1.el7_5 will be installed
--> Processing Dependency: openssl-devel(x86-64) for package: 1:mariadb-devel-5.5.60-1.el7_5.x86_64
--> Running transaction check
---> Package openssl-devel.x86_64 1:1.0.2k-16.el7 will be installed
--> Processing Dependency: zlib-devel(x86-64) for package: 1:openssl-devel-1.0.2k-16.el7.x86_64
--> Processing Dependency: krb5-devel(x86-64) for package: 1:openssl-devel-1.0.2k-16.el7.x86_64
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.15.1-37.el7_6 will be installed
--> Processing Dependency: libkadm5(x86-64) = 1.15.1-37.el7_6 for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: krb5-libs(x86-64) = 1.15.1-37.el7_6 for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: libverto-devel for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: libselinux-devel for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: libcom_err-devel for package: krb5-devel-1.15.1-37.el7_6.x86_64
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.15.1-37.el7_6.x86_64
---> Package zlib-devel.x86_64 0:1.2.7-18.el7 will be installed
--> Running transaction check
---> Package keyutils-libs-devel.x86_64 0:1.5.8-3.el7 will be installed
---> Package krb5-libs.x86_64 0:1.15.1-34.el7 will be updated
---> Package krb5-libs.x86_64 0:1.15.1-37.el7_6 will be an update
---> Package libcom_err-devel.x86_64 0:1.42.9-13.el7 will be installed
---> Package libkadm5.x86_64 0:1.15.1-37.el7_6 will be installed
---> Package libselinux-devel.x86_64 0:2.5-14.1.el7 will be installed
--> Processing Dependency: libsepol-devel(x86-64) >= 2.5-10 for package: libselinux-devel-2.5-14.1.el7.x86_64
--> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.5-14.1.el7.x86_64
--> Processing Dependency: pkgconfig(libpcre) for package: libselinux-devel-2.5-14.1.el7.x86_64
---> Package libverto-devel.x86_64 0:0.2.5-4.el7 will be installed
--> Running transaction check
---> Package libsepol-devel.x86_64 0:2.5-10.el7 will be installed
---> Package pcre-devel.x86_64 0:8.32-17.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================================================================================================================
 Package                                                        Arch                                              Version                                                       Repository                                          Size
=========================================================================================================================================================================================================================================
Installing:
 mariadb-devel                                                  x86_64                                            1:5.5.60-1.el7_5                                              base                                               754 k
Installing for dependencies:
 keyutils-libs-devel                                            x86_64                                            1.5.8-3.el7                                                   base                                                37 k
 krb5-devel                                                     x86_64                                            1.15.1-37.el7_6                                               updates                                            271 k
 libcom_err-devel                                               x86_64                                            1.42.9-13.el7                                                 base                                                31 k
 libkadm5                                                       x86_64                                            1.15.1-37.el7_6                                               updates                                            178 k
 libselinux-devel                                               x86_64                                            2.5-14.1.el7                                                  base                                               187 k
 libsepol-devel                                                 x86_64                                            2.5-10.el7                                                    base                                                77 k
 libverto-devel                                                 x86_64                                            0.2.5-4.el7                                                   base                                                12 k
 openssl-devel                                                  x86_64                                            1:1.0.2k-16.el7                                               base                                               1.5 M
 pcre-devel                                                     x86_64                                            8.32-17.el7                                                   base                                               480 k
 zlib-devel                                                     x86_64                                            1.2.7-18.el7                                                  base                                                50 k
Updating for dependencies:
 krb5-libs                                                      x86_64                                            1.15.1-37.el7_6                                               updates                                            803 k

Transaction Summary
=========================================================================================================================================================================================================================================
Install  1 Package  (+10 Dependent packages)
Upgrade             (  1 Dependent package)

Total download size: 4.3 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/12): keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm                                                                                                                                                                |  37 kB  00:00:00     
(2/12): libcom_err-devel-1.42.9-13.el7.x86_64.rpm                                                                                                                                                                 |  31 kB  00:00:00     
(3/12): krb5-libs-1.15.1-37.el7_6.x86_64.rpm                                                                                                                                                                      | 803 kB  00:00:00     
(4/12): krb5-devel-1.15.1-37.el7_6.x86_64.rpm                                                                                                                                                                     | 271 kB  00:00:00     
(5/12): libkadm5-1.15.1-37.el7_6.x86_64.rpm                                                                                                                                                                       | 178 kB  00:00:00     
(6/12): libselinux-devel-2.5-14.1.el7.x86_64.rpm                                                                                                                                                                  | 187 kB  00:00:00     
(7/12): libverto-devel-0.2.5-4.el7.x86_64.rpm                                                                                                                                                                     |  12 kB  00:00:00     
(8/12): libsepol-devel-2.5-10.el7.x86_64.rpm                                                                                                                                                                      |  77 kB  00:00:00     
(9/12): mariadb-devel-5.5.60-1.el7_5.x86_64.rpm                                                                                                                                                                   | 754 kB  00:00:00     
(10/12): pcre-devel-8.32-17.el7.x86_64.rpm                                                                                                                                                                        | 480 kB  00:00:00     
(11/12): zlib-devel-1.2.7-18.el7.x86_64.rpm                                                                                                                                                                       |  50 kB  00:00:00     
(12/12): openssl-devel-1.0.2k-16.el7.x86_64.rpm                                                                                                                                                                   | 1.5 MB  00:00:00     
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                                                    3.5 MB/s | 4.3 MB  00:00:01     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : krb5-libs-1.15.1-37.el7_6.x86_64                                                                                                                                                                                     1/13 
  Installing : libkadm5-1.15.1-37.el7_6.x86_64                                                                                                                                                                                      2/13 
  Installing : libcom_err-devel-1.42.9-13.el7.x86_64                                                                                                                                                                                3/13 
  Installing : libsepol-devel-2.5-10.el7.x86_64                                                                                                                                                                                     4/13 
  Installing : zlib-devel-1.2.7-18.el7.x86_64                                                                                                                                                                                       5/13 
  Installing : pcre-devel-8.32-17.el7.x86_64                                                                                                                                                                                        6/13 
  Installing : libselinux-devel-2.5-14.1.el7.x86_64                                                                                                                                                                                 7/13 
  Installing : libverto-devel-0.2.5-4.el7.x86_64                                                                                                                                                                                    8/13 
  Installing : keyutils-libs-devel-1.5.8-3.el7.x86_64                                                                                                                                                                               9/13 
  Installing : krb5-devel-1.15.1-37.el7_6.x86_64                                                                                                                                                                                   10/13 
  Installing : 1:openssl-devel-1.0.2k-16.el7.x86_64                                                                                                                                                                                11/13 
  Installing : 1:mariadb-devel-5.5.60-1.el7_5.x86_64                                                                                                                                                                               12/13 
  Cleanup    : krb5-libs-1.15.1-34.el7.x86_64                                                                                                                                                                                      13/13 
  Verifying  : keyutils-libs-devel-1.5.8-3.el7.x86_64                                                                                                                                                                               1/13 
  Verifying  : libverto-devel-0.2.5-4.el7.x86_64                                                                                                                                                                                    2/13 
  Verifying  : 1:openssl-devel-1.0.2k-16.el7.x86_64                                                                                                                                                                                 3/13 
  Verifying  : krb5-libs-1.15.1-37.el7_6.x86_64                                                                                                                                                                                     4/13 
  Verifying  : libkadm5-1.15.1-37.el7_6.x86_64                                                                                                                                                                                      5/13 
  Verifying  : pcre-devel-8.32-17.el7.x86_64                                                                                                                                                                                        6/13 
  Verifying  : libselinux-devel-2.5-14.1.el7.x86_64                                                                                                                                                                                 7/13 
  Verifying  : zlib-devel-1.2.7-18.el7.x86_64                                                                                                                                                                                       8/13 
  Verifying  : libsepol-devel-2.5-10.el7.x86_64                                                                                                                                                                                     9/13 
  Verifying  : libcom_err-devel-1.42.9-13.el7.x86_64                                                                                                                                                                               10/13 
  Verifying  : krb5-devel-1.15.1-37.el7_6.x86_64                                                                                                                                                                                   11/13 
  Verifying  : 1:mariadb-devel-5.5.60-1.el7_5.x86_64                                                                                                                                                                               12/13 
  Verifying  : krb5-libs-1.15.1-34.el7.x86_64                                                                                                                                                                                      13/13 

Installed:
  mariadb-devel.x86_64 1:5.5.60-1.el7_5                                                                                                                                                                                                  

Dependency Installed:
  keyutils-libs-devel.x86_64 0:1.5.8-3.el7  krb5-devel.x86_64 0:1.15.1-37.el7_6   libcom_err-devel.x86_64 0:1.42.9-13.el7  libkadm5.x86_64 0:1.15.1-37.el7_6  libselinux-devel.x86_64 0:2.5-14.1.el7  libsepol-devel.x86_64 0:2.5-10.el7 
  libverto-devel.x86_64 0:0.2.5-4.el7       openssl-devel.x86_64 1:1.0.2k-16.el7  pcre-devel.x86_64 0:8.32-17.el7          zlib-devel.x86_64 0:1.2.7-18.el7  

Dependency Updated:
  krb5-libs.x86_64 0:1.15.1-37.el7_6                                                                                                                                                                                                     

Complete!

 

3、再次执行pip install mysql-python 即可安装成功

[root@hdfs-master cgi-bin]# pip install mysql-python
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting mysql-python
  Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
Installing collected packages: mysql-python
  Running setup.py install for mysql-python ... done
Successfully installed mysql-python-1.2.5

 

hnmpf
关注
专栏目录
Centos7 python2.7.5 安装mysql操作步骤
ohmybbq的博客
01-03 950
1、检测是否已经安装MySql   输入命令：rpm -qa | grep mysql 检测是否已经安装mysql，如果没有返回结果则说明没有安装。   2、输入：yum install mysql 命令安装 [root@localhost ~]# yum install mysql 命令输入完成后就等待系统检测需要安装的包 ，结果如下   Dependencies Resolved...
安装mysql-python模块失败_MySQL数据库之Centos7下python2.7.5安装MySQL模块失败
weixin_39761645的博客
02-04 260
本文主要向大家介绍了MySQL数据库之Centos7下python2.7.5安装MySQL模块失败 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。导语在Centos7下，当前python版本是2.7.5，测试实时获取日志然后解析入库中，安装MySQL-python模块报错如EnvironmentError:mysql_confignotfound，原因是缺少了mysq...
python安装mysql数据库_centos7 安装mysql-python报错
weixin_39901332的博客
11-28 150
环境是 centos 7,python2.7。想要连接mysql，数据库安装的是最新版的8.0.12,使用yum install直接安装。在安装mysql-python时，出错，报错信息如下Collecting mysql-pythonUsing cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7...
Python2.7安装mysql-Python，碰到的问题
replat-xin
01-07 494
安装时碰到这样的错误， EnvironmentError: mysql_config not found 找了很多方法都不管用，最后找到原因是因为我centos中已经装过mysql，mysql的版本为5.7. mysql-devel和mysql的版本不匹配。 解决方法： 自己下载和自己mysql版本匹配的mysql-devel 1.查看安装了什么版本的mysql和相关的包 rp...
centos7 mysql-python_centos7.0下配置mysql＋mysql-python
weixin_34298263的博客
01-19 194
之前写过一篇在centos6.5下配置mysql+python-flask，之所以要写这篇文章的原因就是centos7.0之后，就不支持mysql而是转向支持mysql的开源分支mariaDB也就是是 在yum的源里面实际上是没有mysql-server这个包的,yum search mysql-server也就是说如果你敲入这个指令，它会提示 错误：找不到这个包如果你直接输入下面这句yum i...
centos虚拟机安装升级版的python2.7问题
07-02
在CentOS虚拟机上安装和升级Python 2.7是一...通过以上步骤，你应该能够成功地在你的CentOS环境中安装Python 2.7并解决MySQLdb的安装问题。同时，别忘了在进行任何系统级别的修改时，备份重要数据，以防意外情况发生。
centos 下面安装python2.7 +pip +mysqld
12-24
xz -d Python-2.7.6.tar.xz ls tar -xvf Python-2.7.6.tar cd Python-2.7.6 yum install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline LDFLAGS=”-Wl,-rpath /usr/local/lib”  vi
CentOS 7 安装 MySQL
06-27
CentOS 7 安装 MySQL
centos7 安装mysql和mysqlclient遇到的坑总结
09-09
安装完成后，启动MySQL服务，CentOS7中使用`systemctl start mysqld.service`。如果在较低版本的系统中，可以使用`service mysqld start`。检查MySQL服务状态则分别使用`systemctl status mysqld.service`或`service...
Linux，阿里云， centos7， python2.7， 远程连接连接 MySQLdb
weixin_44767249的博客
12-16 122
注意：远程连接需要加端口号默认3306 #!/usr/bin/python # -*- coding: UTF-8 -*- import MySQLdb # 打开数据库连接 root(用户名） 123456（密码） java(数据库名称） #conn=MySQLdb.connect("177.77.177.77","22","pwd","mysql") conn=MySQLdb.connect(host="120.0.0.1",port=3306,user="test",passwd="pwd!",d
libssh2-1.8.0.tar
10-13
Linux下解压方法 tar xzvf filename
CentOS7 安装MySQL-python失败解决方法
hijk7的博客
05-26 155
CentOS7 安装MySQL-python失败解决方法
centos离线下python2.7安装MySQLdb
清凌的博客
07-09 2792
引用： https://www.jianshu.com/p/26e0705694b3 第一步先安装依赖： yum install libmysqlclient-dev libmysqld-dev python-dev python-setuptools 离线状态下也许不能全部安装成功，如图： 这时候需要进行yum的离线安装: 基本思路是在一个可以联网的系统中下载rpm安装包，然后传到无法联...
centos7中安装mysql-python包
Jepson的博客
09-23 964
系统环境：centos7、python2.7 mysql-python模块包下载：MySQL-python-1.2.5 安装方法 1. 将安装包上传到centos系统中，并解压 2. 进入解压后的目录中，执行以下命令： python setup.py build 提示报以下错误： 解决方法：安装python-devel yum -y install python-devel 然后重新执行 python setup.py build ，编译成功 然后执行安装命令： python setup.py in
centos安装mysql-python_centos7 安装mysql-python报错
weixin_32484447的博客
01-21 392
环境是 centos 7,python2.7。想要连接mysql，数据库安装的是最新版的8.0.12,使用yum install直接安装。在安装mysql-python时，出错，报错信息如下Collecting mysql-pythonUsing cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7...
CentOS7上 pip install MySQL-python 安装失败（error: command 'gcc' failed with exit status 1）的解决办法
小海银鱼的博客
07-16 8404
(pk_env) [dechao@s97-74-237-68 ~]$ pip install MySQL-python                 Collecting MySQL-python  Using cached MySQL-python-1.2.5.zip Building wheels for collected packages: MySQL-python  Runni
centos7安装python的MySQLdb模块
u013709781的博客
02-24 7009
sudo pip install mysql-python 如果遇到找不到mysql_config文件时，要先安装 mysql-community-develsudo yum install mysql-community-devel然后重新sudo pip install mysql-python,如果还遇到下图的问题 再执行以下命令安装python-develsudo yum install
centos7安装python模块_Centos7下python2.7.5安装MySQL模块失败
weixin_39854681的博客
12-08 234
导语在Centos7下，当前python版本是2.7.5，测试实时获取日志然后解析入库中，安装MySQL-python模块报错如EnvironmentError: mysql_config not found，原因是缺少了 mysql 相关支持。这里把解决过程记录一下具体报错信息：root@pts/4 $ pip install MySQL-pythonCollecting MySQL-pytho...
Mac python2.7 安装MySQL-python==1.2.5 解决错误
ying_ge_的博客
05-14 427
Mac python2.7 安装MySQL-python==1.2.5 解决错误 用pip install mysql-python时经常出现如下错误： sh: mysql_config: command not found Traceback (most recent call last): File "setup.py", line 15, in <module> metadata, options = get_config() File "/Users/***/Down...
centos7 pip安装mysql_CentOS7安装mysql-python模块
最新发布
05-21
在 CentOS 7 上安装 mysql-python 模块，可以按照以下步骤操作： 1. 安装 MySQL 开发包： ``` sudo yum install mysql-devel ``` 2. 安装 pip： ``` sudo yum install epel-release sudo yum install python-pip...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值