Connect to database via SSH (HeidiSQL / DBeaver)

JKSoftware

ello,

We are trying to connect to our database server via an SSH tunnel.

We have tested using DBeaver and HeidiSQL, but we are encountering the following error during connection:

Could not connect to localhost:34994 : unexpected end of stream, read 0 bytes from 4 (socket was closed by server)

We also attempted an SSH port forwarding via terminal, forwarding the remote port to localhost, but the result was the same — the connection is closed immediately.

Could you please advise what might be causing this or how to further troubleshoot?

Thank you in advance.

kess

I use it via Putty. Just setup your tunnel as follows:
4L3306 -> 127.0.0.1:3306

Then you can connect using HeidiSQL to your localhost on port 3306 with the remote credentials.
Works perfectly

JKSoftware

I am trying this you suggested, but i still get the same error!