Forums

MySQL DBeaver connection issues

I am having issues when attempting to connect to my python anywhere MySQL DB in DBeaver - i get a success connection on the ssh tunnel but cannot connect to the DB - followed this document to the T https://help.pythonanywhere.com/pages/AccessingMySQLFromOutsidePythonAnywhere yet i get: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
  Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.

I saw on one of the forumns they had to downgrade MySQL to version 5.6 for it to work - is there any resolution on this? I see my MysQL version is 5.7.41

We cannot downgrade your MySQL server.

That's fine but can you advise how to get this working and why this error would be cropping up?

Are you sure you have a working SSH tunnel - they will not work with a free account.

Yip the SSH Tunnel is 100% working - see image:

https://snipboard.io/V9Bqrm.jpg

I do have another PythonANywhere paid account, let me test a Database on that one and revert

Returning after testing on my Paid Platform - I am able to connect via DBeaver, my assumption is, the errors I am getting are due to being unpaid and because there is a reliance on SSH - even though the test conn works the actual connection is blocked - I will upgrade to a paid account tomorrow or see if I can add a 3rd web app to my existing paid account - Thanks

Let us know if you hit problems that we can help with.