DBeaver SSH connect with DigitalOcean/MySql

After trying every solution that I could find, nothing worked. So I’m posting my question here.

Followed instructions on how to connect but always getting same error

Can't initialize tunnel
  Cannot establish tunnel
    com.jcraft.jsch.JSchException: Auth fail

My connection settings: Server Host: Port: 3306 Username: database username Password: database password

Network: Host/IP: myIPaddress Port: 22 User Name: hostname Authentification Method: Public Key Private Key: ….ssh\id_rsa

What am I doing wrong here?

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Accepted Answer

So, that was stupid of me.

It should be my IP address insted of

Now it works like a charm.

On command I’m getting telnet myipaddress 22

Trying myipaddress ...
Connected to myipaddress.
Escape character is '^]'.
SSH-2.0-OpenSSH_7.2p2 Ubuntu-4ubuntu2.1
Connection closed by foreign host.

Does that have somenting to do with not connesting?

And now I’m getting

Communications link failure

The last packet sent successfully to the server was 0 miliseconds ago. The driver has not received any packets from server.

bind-address is my IP address, tried comment it out, still not working.

Can’t find 50-server.cnf just /etc/mysql/mysql.conf.d/mysqld.cnf

Not quite sure what I need to modify in here?

I’m using hostname for network connection (SSH Tunnel), for connection setting username.

Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up

Featured on Community

Get our biweekly newsletter

Sign up for Infrastructure as a Newsletter.

Hollie's Hub for Good

Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.

Become a contributor

Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.

Welcome to the developer cloud

DigitalOcean makes it simple to launch in the cloud and scale up as you grow — whether you're running one virtual machine or ten thousand.

Learn more
DigitalOcean Cloud Control Panel