I'm attempting to merge a pandas DF to a mysql database from within Pythonanywhere.
hostname = "hostname.mysql.pythonanywhere-services.com"
dbname = " 'username$Upwork-RSS' "
uname = "myusername"
pwd = "mypassword"
engine = create_engine(
"mysql://{user}:{pw}@{host}/{db}"
.format(host=hostname, db=dbname, user=uname, pw=pwd))
Error I am receiving is
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1045, "Access denied for user 'danmeregyourdata'@'10.0.0.187' (using password: YES)") (Background on this error at: http://sqlalche.me/e/e3q8)
I've looked at other similar posts and so far I've tried changing the password, getting rid of the driver (instead of "mysql+pymysql://{user}:{pw}@{host}/{db}" I have "mysql://{user}:{pw}@{host}/{db}")
Where am I going wrong? I got a feeling its something silly.