[Django]-Django: remotely access a PythonAnywhere MySQL database

5πŸ‘

βœ…

I think It’s not possible to connect directly to your mysqlserver instance from remote, for security reason, the port 3306 is blocked.
They suggest to connect through SSH Tunnel, follow this link.
I don’t know If you can do an ssh tunnelling within Django, You should probably write a custom configuration. It’s simpler to install an SSH Tunnel software on your PC and then connect your Django App to localhost on a port You have to choose.
Bye

πŸ‘€Filadelfo

3πŸ‘

As per PythonAnyWhere documentation :

  1. Open a terminal and run below command.

    ssh -L 3333:username.mysql.pythonanywhere-services.com:3306 username@ssh.pythonanywhere.com

provide your PAW account login password

replace username with your username.

  1. Open another terminal and run below command.

    mysql -h 127.0.0.1 –port 3333 -u username -p

provide your mysql password. Available in settings file.

keep terminal 1 open as long as you are working on terminal 2.

Accessing PythonAnyWhere MySQL from outside

πŸ‘€Anurag Rana

0πŸ‘

Only Paid account have permission to access remoteserver for mysql database

Leave a comment