How to set up SSH connection from remote database cluster to MySQL workbench

I have a MySQL database cluster set up that I can connect to successfully via the command line (by running the flags in the terminal).

I’d like to be able to connect to the MySQL Workbench. I looked at this tutorial but I must be missing some kind of prerequisite that I cannot figure out.

I entered: SSH Hostname: redactedname-do-user-redactednumber-0.b.db.ondigitalocean.com:25060 SSH Username: doadmin SSH Password: redactedPassword MySQL Hostname: 127.0.0.1 MySQL Server Port: 3306 Username: root

The error I get is:

Failed to Connect to MySQL at 127.0.0.1:3306 through SSH tunnel at doadmin@redactedname-do-user-redactednumber-0.b.db.ondigitalocean.com:25060 with user root Cannot open SSH Tunnel: Socket error: Connection reset by peer

I’ve been working on this issue for quite a long time trying to open an SSH tunnel manually in the terminal, using this template for the command: ssh -L 8888:127.0.0.1:3306 st-user@my-remote-server.host.

This command gives me: “Permission denied (publickey)”

I also generated an SSH Key file and have linked that in the Workbench but that has not helped me make progress.

This article https://phoenixnap.com/kb/fix-connection-reset-by-peer-ssh-error#:~:text=The most common causes of,%2C DenyHosts%2C etc.) may be useful in troubleshooting the specific error I am receiving from the workbench.

Is this an issue from Digital Ocean rejecting the connection? Do I need to set up some SSH tunnel manually? Why is it refusing connection?

Much appreciated.