Phpstorm. Can't access to mysql server through SSH tunnel (connection is closed by foreign host) -
sorry mistakes i've made, i'm not englishman.
i use vagrant deploy remote virtual machine web server configured use :private_network, ip: "192.168.10.10"
. on machine installed nginx, php, mariadb etc.
recently, start use phpstorm main ide. i'm trying configure access remote database server, fail. please, see screens additional information.
to check ssh , mysql server access tried following:
$ ssh vagrant@192.168.10.10 #ok $ mysql -h localhost -p 3306 -u root -p #ok (it's run on remote machine) $ telnet -l root localhost 3306 #also run on remote machine, output: 5.5.5-10.0.7-mariadb-1~precise-log%how)b3s?�o|g*=63=yi#qmysql_native_password connection closed foreign host.
mariadb configuration file seems ok. changed bind-address
in /etc/mysql/my.cnf
0.0.0.0
.
i tried set different configuration data, like: localhost:8080 instead of 169.168.10.10:80, double check password in ssh tunnel window, nothing. please, me..
in case had enable tcp forwarding in ssh configuration of remote host:
allowtcpforwarding yes
and had grant privileges on users connection 127.0.0.1 (instead of 'locahost'):
grant privileges on some_db.* some_user@127.0.0.1 identified 'secret';
Comments
Post a Comment