我写了一个脚本,然后它就出错了,但是在python shell中,我在脚本中输入了相同的代码,它成功了。怎么搞的?这是我的密码:
# -*-coding:utf-8-*-
import pymysql
try:
conn = pymysql.connect('localhost', 'root', 'Hjd4132!', 'pytest')
cursor = conn.cursor()
cursor.execute('SELECT * from demo')
data = cursor.fetchone()
print(data[3])
except Exception as e:
print(e)
finally:
cursor.close()
conn.close()
这是我的错误信息:
(1045, u"Access denied for user 'root'@'localhost' (using password: YES)")
Traceback (most recent call last):
File "demo.py", line 12, in <module>
cursor.close()
NameError: name 'cursor' is not defined
这就是当用户或密码错误时出现的错误,也许你应该检查连接的起始行,这就是为什么没有定义游标的原因
相关问题 更多 >
编程相关推荐