Forums

access denied ( Pandas + sqlalchemy + Mysql)

Dears,

am using this code to connect to my DB:

# Import pandas
import pandas as pd
from sqlalchemy import create_engine

engine = create_engine('mysql://ahmedalnaqa:123456789mysql@ahmedalnaqa.mysql.pythonanywhere-services.com/TestingDB',pool_recycle=280)

#read the CSV file and load it to the DataFrame
DataInDF= pd.read_sql("select * from MyGuests", engine)

print (DataInDF.head())

but i get access denied

any feedback?

You're using the wrong database name. Database names on PythonAnywhere have a '$' character in them and they're shown on your Databases tab.

Working now thanks ..