CentOs下安装 python 的 Mysqldb

之前工作中使用，安装过一次，现整理如下：

OS:：CentOS release 6.5 (Final)

python：

>>> print sys.version
2.6.6 (r266:84292, Jan 22 2014, 09:42:36) 
[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)]

STEP 1：yum install python-devel mysql-devel zlib-devel openssl-devel

STEP 2：http://pypi.python.org/packages/source/s/setuptools/setuptools-0.6c11.tar.gz

下载setuptools;

 tar -zxvf setuptools-0.6c11.tar.gz

cd setuptools-0.6c11

python setup.py build

sudo python setup.py install

STEP 3：http://pypi.python.org/packages/source/M/MySQL-python/MySQL-python-1.2.3.tar.gz 下载 MySQL-python-1.2.3.tar.gz

tar -zxvf MySQL-python-1.2.3.tar.gz

cd   MySQL-python-1.2.3

vi setup_posix.py

   找到mysql_config.path 一行，改为mysql_config.path = "/usr/bin/mysql_config"

python setup.py build

python setup.py install

各步骤不报错就OK！

使用

import MySQLdb
import MySQLdb.cursors

conn = MySQLdb.connect(
                        host = host,
                        port = 3306,
                        db = database,
                        user = user,
                        passwd = password,
                        charset = encode)

_insertSql = "INSERT INTO " + table + "("
    _insertSql += '''
        `name`,
        `code`
    ) VALUES (
        %s,%s
    );'''

cur = conn.cursor()
    cur.executemany(_insertSql,values)
    conn.commit()
    cur.close()