Forums

cannot connect to mysql via SSH

I get the following message when trying to connect via MySQL WorkBench using rhe instructions here : 

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


Error :
Your connection attempt failed for user 'susarla' from your host to server at susarla.mysql.pythonanywhere-services.com:3306:
  Cannot open SSH Tunnel: Error connecting SSH tunnel: The host ssh.pythonanywhere.com fingerprint missmatch.
Expected key: xxx15
Server sent: xxx60
Please verify if it's correct.
To continue, delete entries for the host from the ~/.ssh/known_hosts file file.

Please:
1 Check that mysql is running on server susarla.mysql.pythonanywhere-services.com
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the susarla has rights to connect to susarla.mysql.pythonanywhere-services.com from your address (mysql rights define what clients can connect to the server and from which machines) 
4 Make sure you are both providing a password if needed and using the correct password for susarla.mysql.pythonanywhere-services.com connecting from the host address you're connecting from

Do I need to add this RSA fingerprint to my local known_hosts file? I am not sure how...

deleted-user-1566537 | 55 posts | Aug. 6, 2016, 6:20 p.m. | permalink

I finally managed to connect using MySQL Workbench, but when I try to create a table it says

acces denied to user susarla@% to database xxx

deleted-user-1566537 | 55 posts | Aug. 6, 2016, 7:41 p.m. | permalink

Have you created credentials for that user?

http://dev.mysql.com/doc/refman/5.7/en/adding-users.html

deleted-user-1625370 | 9 posts | Aug. 6, 2016, 9:21 p.m. | permalink

Are you including the 'susarla$' before the database name? For a MySQL database on PythonAnywhere, you always need to include your username and a dollar sign before it.

Staff giles | 11788 posts | PythonAnywhere staff | Aug. 7, 2016, 5:38 p.m. | permalink