distal-attribute
distal-attribute
distal-attribute
distal-attribute

SQL Error (2013)

User, date Message
Written by Lurgid
3 years ago
Category: Creating a connection
3 posts since Thu, 17 Feb 11
When trying to connect via SSH tunnel to a MySQL database that only allows connections from localhost.

Settings
Network type: localhost
User: root
Password: ********
Port: 3306
Compressed: check
Databases: blank
Startup script: blank

SSH tunnel
plink.exe location: C:\Program Files (x86)\PuTTY\plink.exe
SSH host + port: <servername> 22
Username: <my-user-name-on-server>
Password: <My-password-on-server>
Private key file: blank
Local port: 3307

Error:
SQL Error (2013: Loast connection to MySQL server at 'reading initial communication packet', system error: 0

I've gone through most iterations of what I think could from reading other posts here, but I think I covered all my bases. I've already accepted a hash with plink/PuTTY for the server, and other fixes outlined in some forum threads.
Written by Lurgid
3 years ago
3 posts since Thu, 17 Feb 11
No one has any insight into this problem?

SQL Error (2013): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Is this even an issue with HeidiSQL, or does it have to do with a MySQL server setting somewhere?
Written by Lurgid
3 years ago
3 posts since Thu, 17 Feb 11
More troubleshooting information:

If I try to do a TCP/IP connection instead and creating the tunnel with PuTTY, first, I get the same error, except with "system error: 2" instead of 0.
 

Please login to leave a reply, or register at first.