安装mysql-python
1、下载mysql-python
打开终端:
cd /usr/local
sudo wget http://nchc.dl.sourceforge.net/sourceforge/mysql-python/MySQL-python-1.2.2.tar.gz
官网地址:http://sourceforge.net/projects/mysql-python/
2、解压
sudo tar -zxvf MySQL-python-1.2.2.tar.gz
cd MySQL-python-1.2.2
3、在安装前需进行配置
a、修改setup_posix.py中的mysql_config.path为你mysql安装目录的mysql_config路径
b、修改site.cfg中的threadsafe = False,去掉mysql_config前的注释,并改为mysql_config = /usr/local/mysql/bin/mysql_config
c、执行命令:
export LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql
sudo ln -s /usr/local/mysql/lib/mysql/libmysqlclient.so /usr/lib/libmysqlclient.so.14
sudo ldconfig (这个很重要,否则后面会报错ImportError: libmysqlclient.so.14: cannot open shared object file)
4、编译安装
1)python setup.py build
若未成功的话,需手动安装setuptools:
sudo apt-get install python-setuptools
2)sudo python setup.py install
5、测试
python
>>> import MySQLdb
没有错误,则表示安装成功了。
使用python操作MySQL
使用python连接MySQL,创建数据库,创建表格,插入/查询数据。python_mysql.py代码如下:
#!/usr/bin/python # coding: utf-8 import MySQLdb #连接 cxn = MySQLdb.Connect(host = ‘127.0.0.1‘, user = ‘root‘, passwd = ‘root‘) #游标 cur = cxn.cursor() try: cur.execute("DROP DATABASE PyTest") except Exception as e: print(e) finally: pass #创建数据库 cur.execute("CREATE DATABASE PyTest") cur.execute("USE PyTest") #创建表 cur.execute("CREATE TABLE users (id INT, name VARCHAR(8))") #插入 cur.execute("INSERT INTO users VALUES(1, ‘Tina‘),(2, ‘Tom‘),(3, ‘Tony‘),(4, ‘sala‘)") #查询 cur.execute("SELECT * FROM users") for row in cur.fetchall(): print(‘%s\t%s‘ %row) #关闭 cur.close() cxn.commit() cxn.close()