Forums

Hi, I am facing error while connecting to MySQL through MySQL Workbench from my local machine. It throws error ""Access denied for user pjsaravanan@10.0.0.142 (using password:YES).

However, as specified in the guide I am able to SSH C:\Users\pjsaravanan\Downloads\putty>ssh -L 3306:pjsaravanan.mysql.pythonanywhere-services.com:3306 pjsaravanan@ssh.pythonanywhere.com <<<<<<:>~ PythonAnywhere SSH. Help @ https://help.pythonanywhere.com/pages/SSHAccess pjsaravanan@ssh.pythonanywhere.com's password: 11:00 ~ $ ls Notebook1.ipynb Untitled1.ipynb fileread.txt .... etc

Can you help resolve the issue? Regards Saravanan

How did you set up the connection in Workbench?

Connection Method : Standard TCP/IP Over SSH Hostname : ssh.pythonanywhere.com ( eu does not work .. i verified it ) MySQL Host : pjsaravanan.mysql...... Port : 3306 ( I do not have MySQL installed in my local machine. Installed only the Workbench, hence retained the same port )

I had also enabled SSH login based management. There is one info that was not in guide about System Profile. When I connected by default, the workbench reported an error that the host was not on Windows. I changed the system profile to Fedora Linux

If you're getting Access denied for user pjsaravanan@10.0.0.142 (using password:YES), then it has connected through the SSH tunnel to the MySQL server correctly -- you're just getting refused access because the MySQL password (not the SSH one) is incorrect. Check out the file `.my.cnf`` in your home directory; it will contain the correct MySQL password.

Thank you... Got it working ...