MySQL remote access via SSH Tunnel error

Question

I've created an SSH tunnel on my local machine to reach an access to the mysql server on my remote machine. Everything is fine, tunnel is working if I get this error, but why this error occurs?

Here is the error message:

2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 0

It happends only, when I want to connect via Navicat (SSH Tunnel) from my local to the remote machine, on the remote machine mysql works without such errors.

Have you guys any solutions for that?

Same here, I've been trying to use HeidiSQL, MySQL Workbench, and NaviCat, and none of them allow me to connect to the server. — samwell
– samwell, Commented Feb 28, 2012 at 20:44
how did you create the ssh tunnel ? can you please post your command ? — dom
– dom, Commented Mar 2, 2012 at 9:34
@dom First way , is putty: oldsite.precedence.co.uk/nc/putty.html (ofc. with different ports), second way I've tried is the SSH connection tunnel option in the Navicat Premium - in both cases I get the same errors. — Cyclone
– Cyclone, Commented Mar 2, 2012 at 11:46
@Cyclone have you tried it doing that way: realprogrammers.com/how_to/set_up_an_ssh_tunnel_with_putty.html — dom
– dom, Commented Mar 2, 2012 at 12:29
@dom ... This is the same as this: oldsite.precedence.co.uk/nc/putty.html , result is the same too: 2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 0 — Cyclone
– Cyclone, Commented Mar 2, 2012 at 12:47

dom · Accepted Answer · 2012-03-08 10:24:01Z

2

This error occurs when the configuration of the bind-adress option is wrong. Your MySQL server at least should listen on the localhost - 127.0.0.1

answered Mar 8, 2012 at 10:24

dom

6691 gold badge16 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

toraritte · Accepted Answer · 2018-07-06 17:51:31Z

1

Login to your local Linux machine then run this command:

ssh -L 3307:localhost:3306 -N [email protected]

Use the mysql database from remote server:

mysql -u root -p --port 3307 -h 127.0.0.1

Make sure the local mysql does not use the same port in Linux environment.

edited Jul 6, 2018 at 17:51

toraritte

8,7254 gold badges66 silver badges101 bronze badges

answered Jul 6, 2018 at 15:36

Anil Singh

3593 silver badges8 bronze badges

Collectives™ on Stack Overflow

MySQL remote access via SSH Tunnel error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest