Question

DBeaver SSH connect with DigitalOcean/MySql

Posted February 10, 2017 12k views
MySQLDigitalOceanUbuntu 16.04

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: 127.0.0.1
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?

Add a comment
verse
By:
verse
Add a comment

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.

×
4 answers
verse February 14, 2017

So, that was stupid of me.

It should be my IP address insted of 127.0.0.1.

Now it works like a charm.

Reply Report
jtittle1 February 10, 2017

@verse

By default, MySQL doesn’t allow remote connections as it’s bound to localhost or 127.0.0.1.

You’d need to modify MySQL’s configuration from the CLI and find:

bind-address            = 127.0.0.1

and comment it out, so that it looks like:

#bind-address            = 127.0.0.1

and then restart MySQL. If you’re using MariaDB instead of the actual MySQL package, you’d need to modify this file:

/etc/mysql/mariadb.conf.d/50-server.cnf

otherwise the file should be:

/etc/mysql/mysql.conf.d/50-server.cnf

As for the connection settings, are you using your hostname as the username? Your username should be either root or your sudo user (if you’ve set one up) for the non-database login.

Reply Report
verse February 13, 2017

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.

Reply Report
verse February 13, 2017

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.
Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help