Forums

Hi,

I am trying to establish a connection to the MySQL database using 'MySQL for Excel' and can't seem to get a connection. Can someone please look at the settings I'm putting in and point out what I'm doing wrong?

CONNECTION METHOD: Standard TCP/IP over SSH HOSTNAME: my_user_name.mysql.pythonanywhere-services.com PORT: 3306 USERNAME: my_user_name_for_PA PASSWORD: password_for_the_database

SSH SETTINGS: SSH HOSTNAME: ssh.pythonanywhere.com (I also tried ssh.pythonanywhere.com:22) SSH USERNAME: my_user_name_for_PA SSH PASSWORD: password_for_PA

I can connect with MySQL Workbench, but not with mySQL for Excel. So, it doesn't seem to be these connection settings that are causing the problem. I'll just use Workbench.

Problem solved, thank you. This PA forum page was very helpful:

https://help.pythonanywhere.com/pages/SSHTunnelling