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..

enter image description hereenter image description here

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

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -