Forums

MySQL Tools - SQLYog

I'm new here, but wanted to pass along that SQLYog works if you have a paid PA account. I know it's a commercial tool, but I've used SQLYog and MonYog for several years and it's my "goto" tool for MySQL. You just need to configure your SQLYog client connection as follows:

In the MySQL tab set:

MySQL Host Address: mysql.server

Username: (your mysql user name)

password: (your mysql password)

port: 3306

Database: (your database, somethinglike username$database

Next click on the SSH tab set:

click the checkbox next to Use SSH Tunneling

SSH Host Address: username@ssh.pythonanywhere.com

Username: (your username) SSH Port: 22

click the Password radio button

Password: (your account password, not your db password)

Use the Test Connection button and ensure everything is working.

Debugging:

if it's not working, split the problem in half. Ensure you can log with SSH. I used PuTTY. Next, ensure the user name and password are correct for MySQL you can do this through a console window in PA.

Hope this helps,

-james

Hi James -- thanks for posting that! One thing I should make clear for other readers: this will work with any kind of paid PythonAnywhere account, but because it needs ssh access, it won't work for free ones.