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.
Click below to sign up and get $100 of credit to try our products over 60 days!
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.