当然了，前提是你已经安装了Python和MySQL。我的Python是2.6版本的。 Python2.6的“Set”有点兼容性问题，自己照着改一下： http://sourceforge.net/forum/message.php?msg_id=5808948 1)__init__.py 删除 from sets import ImmutableSet 将 class DBAPISet(ImmutableSet): 改成 class DBAPISet(frozenset) 2) converters.py 删除 from sets import BaseSet, Set 3)converters.py 将 "Set"改成 "set" (仅2处): line 48: return set([ i for i in s.split(‘,‘) if i ]) line 128: set: Set2Str, 然后就可以进行连接测试了:
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
#!/usr/bin/python# mysql connection testimport
MySQLdb
import
sys
try:
conn =
MySQLdb.connect(host =
‘localhost‘, user =
‘harryxlb‘, passwd =
‘xlb123‘,
db =
‘boiis‘, charset =
‘utf8‘)
cur =
conn.cursor()
except
MySQLdb.Error, ex:
print
‘MySQL connect Error!‘
print
ex.args[0], ex.args[1]
sys.exit()print
‘MySQL connect success!‘
sql =
‘SELECT * FROM bo_blog LIMIT 100‘
count =
cur.execute(sql)
print
count, ‘ records found.‘
results =
cur.fetchall()
for
r in
results:
print
‘==================================================================\n‘, r[1]
print
r[2]
|
MySQL connect success!
2 records found.
==================================================================
标题一
内容一
==================================================================
标题二
内容二