(1) install MySql in advance. Otherwise, the following pythonsetup. pybuild will prompt that "EnvironmentError: mysql_confignotfound" cannot be found. The installation command is as follows: sudoapt-getinstalllibmysqlclient-devsudoa.
Download MySQL for python, the latest version of mysql-python-1.2.4b4.tar.gz 1) to install in advance: mysql_config; otherwise, follow the python setup. in py build, "EnvironmentError: mysql_config not found" is not found. The installation command is as follows: sudo apt-get install libmysqlclient-dev sudo.
Download MySQL for Python, the latest MySQL-python-1.2.4b4.tar.gz
1) install MySql in advance
Otherwise, "EnvironmentError: mysql_config not found" is not displayed in the python setup. py build. The installation command is as follows:
Sudo apt-get install libmysqlclient-dev
Sudo apt-get install python-dev (solve fatal error: Python. h: No such file or directory)
CentOS install yum install mysql-devel and yum install python-devel (Solve error: command 'gcc 'failed with exit status 1)
2) then install MySQLdb.
$ Tar zxvf MySQL-python-1.2.2.tar.gz
$ MySQL-python-1.2.2 cd
$ Sudo python setup. py build
$ Sudo python setup. py install
3) Verify the installation
Homer @ ubuntu :~ /MyCode/python $ python
Python 2.7.3 (default, Aug 1 2012, 05:14:39)
[GCC 4.6.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> Import MySQLdb
>>>
Import MySQLdb has no error. The installation is successful!
Test example:
import MySQLdbdb = MySQLdb.connect("localhost","myusername","mypassword","mydb" )cursor = db.cursor()cursor.execute("SELECT VERSION()")data = cursor.fetchone() print "Database version : %s " % data db.close()
Example of connecting python to mysql:
##################### IT-Homer# 2013-05-10####################import MySQLdbdb = MySQLdb.connect(host="localhost", user="root", passwd="abcd1234", db="testDB")cursor = db.cursor()cursor.execute("Select * from gameTestDB limit 10")result = cursor.fetchall()for row in result: #print row #print row[0], row[1], row[2] #print '%s, %s, %s' % (row[0], row[1], row[2]) print ', '.join([str(row[0]), str(row[1]), str(row[2])])cursor.close()'''import sysimport MySQLdbreload(sys)sys.setdefaultencoding('utf-8')db = MySQLdb.connect(user='root', passwd='abcd1234', charset='utf8')cur = db.cursor()cur.execute('use testDB')cur.execute('select * from gameTestDB limit 10')f = file("/home/homer/tmp_mysql.txt", 'w')for row in cur.fetchall(): f.write(str(row)) f.write("\n")f.close()cur.close()'''
##################### IT-Homer# 2013-05-10####################import MySQLdb# local mysql# db = MySQLdb.connect(host="localhost", user="root", passwd="abcd1234", db="testDB")# aws rds mysqldb = MySQLdb.connect(host="ithomer.aliyun.com", user="ithomer", passwd="abcd1234", db="dman")cursor = db.cursor()cursor.execute("Select * from score limit 10")result = cursor.fetchall()for row in result: #print row #print row[0], row[1], row[2] #print '%s, %s, %s' % (row[0], row[1], row[2]) print ', '.join([str(row[0]), str(row[1]), str(row[2])])cursor.close()'''import sysimport MySQLdbreload(sys)sys.setdefaultencoding('utf-8')db = MySQLdb.connect(user='root', passwd='abcd1234', charset='utf8')cur = db.cursor()cur.execute('use testDB')cur.execute('select * from gameTestDB limit 10')f = file("/home/homer/tmp_mysql.txt", 'w')for row in cur.fetchall(): f.write(str(row)) f.write("\n")f.close()cur.close()
Connect python to mongodb
1) install pymongo
Pymongo download, latest pymongo-2.6.tar.gz
Install
$ Tar zxvf pymongo-2.6.tar.gz
$ Pymongo-2.6 cd
$ Sudo python setup. py build
$ Sudo python setup. py install
2) connect to mongodb
#!/usr/bin/pythonimport pymongoimport randomHOST = '172.27.22.21'PORT = 27017_DB='test'_TABLE='testuser'conn = pymongo.Connection("172.27.22.21", 27017)db = conn[_DB] # get dbdb.authenticate("yanggang", "123456")table = db[_TABLE] # get collectiontable.drop()table.save({"id":1, "name":"homer", "age":18})for id in range(2,10): name = random.choice(['it', 'homer', 'sunboy', 'yanggang']) age = random.choice([10, 20, 30, 40, 50, 60]) table.insert({"id":id, "name":name, "age":age})cursor = table.find()for user in cursor: print user'''conn = pymongo.Connection("172.27.22.21", 27017)db = conn.testdb.authenticate("yanggang", "123456")db.testuser.drop()db.testuser.save({"id":1, "name":"homer", "age":18})for id in range(2,10): name = random.choice(['it', 'homer', 'sunboy', 'yanggang']) age = random.choice([10, 20, 30, 40, 50, 60]) db.testuser.insert({"id":id, "name":name, "age":age})cursor = db.testuser.find()for user in cursor: print user'''
Running result
Connect python to Redis
1) Go to redis-py to download the release version release, the latest release version: redis-py-2.8.0.zip
2) unzip redis-py-2.8.0.zip: unzip redis-py-2.8.0.zip, install: sudo python setup. py install
3) Verify that the installation is successful:
# Python
>>> Import redis
>>>
4) simple example:
>>> import redis>>> r = redis.StrictRedis(host='localhost', port=6379, db=0)>>> r.set('foo', 'bar')True>>> r.get('foo')'bar'
5) python script example
#! /Usr/bin/python #-*-coding: UTF-8-*-import sysreload (sys) sys. setdefaultencoding ('utf-8') import redis_REDIS_HOST = '2017. 27.9.104 '_ REDIS_PORT = 62.16_redis_db = 0def read_redis (): r = redis. redis (host = _ REDIS_HOST, port = _ REDIS_PORT, db = _ REDIS_DB) # delete all data in the current database r. flushdb () r. set ('foo', 'bar') print (r. get ('foo') # bar r. set ('blog ', 'ithomer.. net ') r. set ('name', 'hangzhou') # If no key is found, None print (r. get ('one123') # None # print (r. dbsize () #3 # list all key values print (r. keys () # ['blog ', 'foo', 'name'] if _ name _ = "_ main _": read_redis ()
Running result:
Bar
None
3
['Blog ', 'foo', 'name']
Reference recommendations:
Connect Python connector to MySQL
MySQLdb User's Guide
Python string operations
Mysql_config not found (stackover flow)
Create a mysql database using python
Connect to and operate mongodb using python
Redis-py (github)