Trouble making connection to remote MySQL

[crozilla]

Details: Just want to connect to a DB on my Dreamhost shared hosting. I've got the username, password, and hostname, but I get an "Access Denied" error. If I use an SSH Tunnel, I get Handshake Timeout.

I can access the DB via direct SSH and phpAdmin, but not with Beekeeper. This seems like basic config info that should be in the docs. Did I miss those?

Version Information [might be relevant to your issue] Operating System: Mac OSX Monterery App Version [help -> about]: 3.4.2 Database type and version [eg Posgresql 9.3]: MySQL v8

Screenshot / GIF [if appropriate]: A screenshot of the app if that helps

[rathboma]

If you have a minute, there are a couple of ways to debug this:

1. Errors in Beekeeper Studio

Can you open the devtools panel and see if there's a more descriptive error in there? (help -> show developer tools)

2. Limits in MySQL

It's possible your user has a host limitation on it -- MySQL allows you to limit which IPs a user can authenticate from, it may be that you can only access it from a dreamhost machine.

You can check this by running:

SELECT User, Host FROM mysql.user; 

I'm not sure why the SSH tunnel would get a handshake timeout, but maybe there's more in the dev console?

[tahder]

I got the same result 'Timed out while waiting for handshake' even modified to add 'AllowTCPForwarding yes' in the server but seems not able to connect. It accepts the password and the details but can't proceed using MariaDB 'Server version: 10.3.32-MariaDB MariaDB Server'. It is not related to limits as can log in to other apps and then log out just to confirm if able to log in.