MySQLdb安装|Centos 7 下关联 python 和 MariaDB or MySQL

              **Edited by 蘑菇@HDUMaker**

Overview

系统配置：CentOS 7
python：Python 2.7.5
Mariadb：10.0.20-MariaDB MariaDB Server

进入python下输入 import MySQLdb

Python 2.7.5 (default, Jun 24 2015, 00:41:19)[GCC 4.8.3 20140911 (Red Hat 4.8.3-9)] on linux2Type "help", "copyright", "credits" or "license" for more information.>>> import MySQLdb

回收到如下报错

ImportError: No module named MySQLdb

所以需要安装MySQLdb库，在此之前需要做如下配置

Dependencies

安装python-devel

ERROR： MySQLdb: Python.h: No such file or directory

由于MySQLdb是用c写的所以需要python-devel包

[root@iZ236xzsl93Z /]# yum -y install build-essential python-devLoaded plugins: langpacksNo package build-essential available.No package python-dev available.Error: Nothing to do

然而并不可以 ，因为在yum下dev并不叫这个名字╮(╯▽╰)╭
如下是身份证上的名字

For CentOS:

#> yum install mysql-devel

For openSUSE:

#> zypper install libmysqlclient-devel

For Debian-based systems/Ubuntu:

#> apt-get install libmysqlclient-dev

安装mysql-devel

即便是安装MySQL-python后我还是会遇到这个报错

mysql_config: command not found

#Errorsh： mysql_config: command not foundCommand python setup.py egg_info failed with error code 1 in /tmp/pip-build-bIrQHo/MySQL-pythonStoring debug log for failure in /root/.pip/pip.log

解决方法：安装

[root@iZ236xzsl93Z ~]# yum install mysql-devel

最终显示：

Installed:  MariaDB-devel.x86_64 0:10.0.20-1.el7.centosComplete!

【注】因为我安装的是MariaDB所以这里是MariaDB-devel

放在后面解决>>>

ImportError: No module named mysql.*

... import mysql.connector as mariadbTraceback (most recent call last):  File "<stdin>", line 2, in <module>ImportError: No module named mysql.connector

Installation

 #>yum install MySQL-python

安装了MySQL-python 跟MariaDB的shared文件

Install  1 Package (+1 Dependent package)Total download size: 1.3 MInstalled size: 6.2 MIs this ok [y/d/N]: yDownloading packages:(1/2): MySQL-python-1.2.3-11.el7.x86_64.rpm(2/2): MariaDB-10.0.20-centos7-x86_64-shared.rpm

最后打开python测试下，能不能用

貌似还是不可以╮(╯▽╰)╭ 为啥呢 想不通@@@@@@@
接着试错…

下载MySQL-python-1.2.4b5.tar.gz

wget https://pypi.python.org/packages/source/M/MySQL-python/MySQL-python-1.2.4b5.tar.gz#md5=2d760ee948aff4f50d01afdf8afff48c

解压安装包 安装

[root@~]tar -zxvf MySQL-python-1.2.4b5 [root@~]cd MySQL-python-1.2.4b5[root@~ MySQL-python-1.2.4b5]# python setup.py build[root@~MySQL-python-1.2.4b5]# python setup.py install

然而神奇的事情发生了 ，竟然能用了

>>> import MySQLdb>>> db =  MySQLdb.connect("localhost","root","","test")>>> cursor =  db.cursor()>>> cursor.execute("SELECT VERSION()")>>> data = cursor.fetchone()>>> print "Database version : %s"%dataDatabase version : 10.0.20-MariaDB>>> db.close()

成功了O(∩_∩)O哈！

References

How to connect Python programs to MariaDB
mysql-libmysqlclient
MySQLdb: Python.h: No such file or directory

Related Article

python操作mysql数据库@自强学堂