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?
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.
So, that was stupid of me.
It should be my IP address insted of 127.0.0.1.
Now it works like a charm.
On command I’m getting
telnet myipaddress 22
Does that have somenting to do with not connesting?
And now I’m getting
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.
@verse
By default, MySQL doesn’t allow remote connections as it’s bound to
localhost
or127.0.0.1
.You’d need to modify MySQL’s configuration from the CLI and find:
and comment it out, so that it looks like:
and then restart MySQL. If you’re using MariaDB instead of the actual MySQL package, you’d need to modify this file:
otherwise the file should be:
As for the connection settings, are you using your hostname as the username? Your username should be either
root
or yoursudo
user (if you’ve set one up) for the non-database login.