External access to pythonanywhere MySQL database with pandas and SQLAlchemy

Question

I want to use pandas to read data from my pythonanywhere MySQL database. pandas uses sqlalchemy.

The following doesn't work:

import pandas as pd
from sqlalchemy import create_engine
engine = create_engine('mysql://user:[email protected]/user$db_name')
pd.read_sql('SHOW TABLES from db_name', engine)

I'm getting an error: OperationalError: OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on 'user.mysql.pythonanywhere-services.com' (10060)") None None

What's wrong? Or is external access not possible with pythonanywhere? (I'm on a free plan)

Maybe look at help.pythonanywhere.com/pages/UsingSQLAlchemywithMySQL — joris
– joris, Commented Nov 16, 2015 at 14:25
@joris Thx, but still doesn't work. If I run the script from within pythonanywhere I get (OperationalError) (1044, "Access denied for user 'user'@'%' to database 'db_name'") 'SHOW TABLES from db_name' () — tobip
– tobip, Commented Nov 16, 2015 at 14:29
@tobip engine = create_engine('mysql+mysqlconnector://[user]:[pass]@[host]:[port]/[schema]', echo=False) This is full detail you need to connect to a day — WoodChopper
– WoodChopper, Commented Nov 16, 2015 at 15:05

Giles Thomas · Accepted Answer · 2015-11-16 15:54:09Z

2

PythonAnywhere dev here. Unfortunately you can't connect to your PythonAnywhere database from outside the service. If you had a paid plan (which comes with SSH access) then you could do it by using SSH tunnelling but that won't work from a free account.

answered Nov 16, 2015 at 15:54

Giles Thomas

5,8952 gold badges37 silver badges53 bronze badges

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

2 Comments

wasabigeek Over a year ago

Is this the same for Postgres DBs?

Giles Thomas Over a year ago

That's right -- all databases are on a private subnet.

Collectives™ on Stack Overflow

External access to pythonanywhere MySQL database with pandas and SQLAlchemy

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