Geek asks and answers

Connecting HeidiSQL to mysql server - Lost connection ... server while reading the initial

New for connecting to databases and has no idea where to start troubleshooting -

I am currently using HeidiSQL to connect to an external Mysql database server hosted on Amazon web service - EC2.

I can access the database using HeidiSQL with the settings: MySQL (SSH tunnel) Hostname / ip: 127.0.0.1 user: (user) password: (pw) port 3306

in the SSH tunnel tab: Location of plink.exe: putty.exe sshhost + port: (my host ip) port 22 private key file: (installed) local port: 3307

Using this configuration, I can log into my database. My problem is when I try to do this using my own putty commands using port forwarding:

In Shpakler: I installed SSH> tunnels - source port: 3307, destination (my host ip): 3306 Local and Auto. I connect my passwords and hosting

Back to HeidiSQL, I set up the following settings: MYSL (TCP / IP) hostname: localhost user: (user) password (PW) port 3307

and try to connect. I get the following error: SL ERROR (2013): Lost connection to MySQL server while "reading the source communication packet", system error: 0

, , , ssh , - . , . - ? ? - ODBC JDBC . ?

+5
1

, : http://realprogrammers.com/how_to/set_up_an_ssh_tunnel_with_putty.html . , ssh mysql .

Putty: SSH > - : 3307, destination ( ip): 3306 Local Auto.

: SSH > - : 3307, 127.0.0.1:3306 .

heidisql: MYSL (TCP/IP): localhost user: () (pw) 3307

, MySQL, , , (3307), 2013 , ! .

, mysql ( mysql), , . , ( ) %.

0

More articles:


All Articles