1.下载windows下的MySQLdb
下载地址:http://sourceforge.net/projects/mysql-python/
下载成功之后,双击它,自动安装到了D:\program files\Python27\Lib\site-packages。
2.用网上的代码
# server_version.py - retrieve and display database server version
import MySQLdb
conn = MySQLdb.connect (host = "localhost",
user = "testuser",
passwd = "testpass",
db = "test")
cursor = conn.cursor ()
cursor.execute ("SELECT VERSION()")
row = cursor.fetchone ()
print "server version:", row[0]
cursor.close ()
conn.close ()
在conn = MySQLdb.connect()这句这里报错:
Traceback (most recent call last):
File "<pyshell#12>", line 1, in <module>
import MySQLdb
File "E:/Github/python/20140331\MySQLdb.py", line 7, in <module>
conn = MySQLdb.connect(host="localhost", user="root", passwd="", db="test",charset="utf8")
AttributeError: 'module' object has no attribute 'connect'
相关资料:
http://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python
http://www.kitebird.com/articles/pydbapi.html
http://www.mikusa.com/python-mysql-docs/index.html
https://wiki.python.org/moin/DatabaseProgramming