Python program working in shell but not when run from IDLE

Question

I wrote a script, and then it went wrong, but in the python shell, I typed the same code in the script and it worked. What happened? Here's my code:

# -*-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()

Here's my error message:

(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

So your line cursor = .. wasn't executed. Exception appeared in connect() method. — sashaaero
– sashaaero, Commented Mar 21, 2019 at 3:24
I changed MySQL 5.7 to 5.1, and the problem was solved without modifying the code. Thank you for your reply! — scriptkid
– scriptkid, Commented Mar 21, 2019 at 6:49

fran496 · Accepted Answer · 2019-03-21 03:29:25Z

1

that's the kind of error you get when the user or password are wrong, maybe you should check the line where you start the connection, it's the reason why cursor is not defined.

answered Mar 21, 2019 at 3:29

fran496

861 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

scriptkid Over a year ago

i can use the password enter mysql ,and in the python shell it worked,but when i ran this script,it made a mistake

scriptkid Over a year ago

I changed MySQL 5.7 to 5.1, and the problem was solved without modifying the code. Thank you for your reply!

Collectives™ on Stack Overflow

Python program working in shell but not when run from IDLE

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related