Forums

Cannot connect to MySQL database from Sequel-Pro (and other db browsers)

Hello, I'm trying to follow this guide to connect to my MySQL database remotely via a db browser: https://help.pythonanywhere.com/pages/AccessingMySQLFromOutsidePythonAnywhere/

I have tried Sequel-Pro (which is listed in the guide) and similar db browsers (SQLPro Studio, TablePlus) and I'm always getting the same error. The SSH connection works fine, but when it gets to the MySQL connection I get this:

MySQL said: Access denied for user 'shadowmaker'@'10.0.0.107' (using password: YES)

I have tried using both my MySQL password and pythonanywhere password and both raise the same error. Any idea what I'm doing wrong?

Thanks.

Are you able to just open ssh connection to PythonAnywhere with the same credentials?

Yes I am able to connect to SSH just fine. When I try to connect the database in the db browsers it also shows me that the SSH part of the connection is successful, it's when it gets to the MySQL connection that it fails.

Then you're using that wrong password to log in to MySQL. You need to use the one that you set on the Databases page when you enabled MySQL.

I got it working now, thanks.

Thanks for letting us know!