MySQL connection with Python through PythonAnywhere

Question

I want to connect to MySql database using Python through PythonAnywhere, without creating a Flask/Django application.

I have seemingly managed to connect through MySQLdb, using the code below, but I do not receive a response when I run the code. Any solutions?

import MySQLdb

db = MySQLdb.connect(
    host = "myuser.mysql.pythonanywhere-services.com",
    user = "myuser",
    passwd = XXX,
    db = "myuser$db_name"
    )

cursor = db.cursor()

cursor.execute("SELECT * FROM table_name")

for x in cursor:
    print(x)

cursor.close()
db.close()

How are you running this code, and what form of "response" are you expecting? — Scott Hunter
– Scott Hunter, Commented Jun 30, 2022 at 15:33

J_H · Accepted Answer · 2022-06-30 15:47:02Z

1

You retrieve all rows in the table, without error.

cursor.execute("SELECT * FROM table_name")

for x in cursor:
    print(x)

Yet you see no output. This is normal for a table that contains zero rows.

Consider doing one or more INSERTs, and a COMMIT, prior to the query.

answered Jun 30, 2022 at 15:47

J_H

21.2k5 gold badges29 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

MySQL connection with Python through PythonAnywhere

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related