python和mysqldb连接问题
大雷子老师 2009-04-09 07:45:02 大家好,我的系统是red hat 9,mysql5.0.22,python 2.5,mysqldb1.2.2
按照网上的说法安装好了python和mysql,都能正常工作.然后安装mysqldb.经过一翻周折,没出什么大的错误.
在python的解释模式下依次输入如下命令:
[root@localhost site-packages]# python
Python 2.5.4 (r254:67916, Apr 9 2009, 15:14:22)
[GCC 3.2.2 20030222 (Red Hat Linux 3.2.2-5)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>> conn = MySQLdb.Connection('127.0.0.1', 'root', 'wanglei', 'mytest')
>>> cur = conn.cursor()
>>> cur.execute('select * from chtest')
11L
>>> row=cur.fetchall()
>>> print row
(('ni hao ma?',), ('??',), ('ni hao ma?',), ('??',), ('ni hao ma?',), ('?',), ('ni hao ma?',), ('???',), ('ni hao ma?',), ('???',), ('???!!',))
这表明可以用mysqldb连接数据库,并且能读出来一些数据.
但我把上面的命令存放到一个mysqltest.py文件里面.
[root@localhost dbTest]# cat mysqltest.py
#!/usr/bin/python
# -*- coding: gb2312 -*-
import MySQLdb
conn = MySQLdb.Connection('127.0.0.1', 'root', 'wanglei', 'mytest')
cur = conn.cursor()
cur.execute('select * from chtest')
row=cur.fetchall()
print row
然后就出现如下情况:
[root@localhost dbTest]# ./mysqltest.py
Traceback (most recent call last):
File "./mysqltest.py", line 4, in ?
import MySQLdb
ImportError: No module named MySQLdb\
请问各位这是什么情况?我搞了两天了,谢谢大家.