之前下了MySQLdb.exe安装后
import MySLdb无报错
但是当我写成sql.py,对数据库连接查询时发生错误,不知道是哪个配置有问题,恳请各位帮忙看下
注:用root直接登陆mysql对mydb进行查询可以
以下为错误
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")
File "e:\python_demo\sql.py", line 4, in <module>
conn=MySQLdb.connect(host="localhost",user="root",passwd="root",db="mydb",charset="utf8")
File "E:\Python27\Lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "E:\Python27\Lib\site-packages\MySQLdb\connections.py", line 187, in __init__
super(Connection, self).__init__(*args, **kwargs2)
以下为代码
import , MySQLdb
#连接
conn=MySQLdb.connect(host="localhost",user="root",passwd="root",db="mydb",charset="utf8")
cursor = conn.cursor()
#查询
n = cursor.execute("select * from books")
for row in cursor.fetchall():
for r in row:
print r
#关闭
conn.close()