CODEWITHSUNDEEP
mysqlsshnavicat
SISYN
SISYN

Reputation: 2259

Navicat - lost connection to mysql server at 'reading initial communication packet', system error: 0

I am getting the error listed above when trying to connect to my MySQL server via SSH public key in Navicat. I have searched endlessly trying to find a solution to this. I have made sure that the AllowTCP option is enabled, and I have tried setting the hostname to localhost and 127.0.0.1 but neither of them work, it only changes the error to Connection Refused.

Here are my connection properties:

(General Tab) Hostname/IP Address: mydomain.com Port: 3306 Username: myusername Password: mypassword

(SSH Tab) Hostname/IP Address: mydomain.com (have also tried localhost/127.0.0.1) Port: 3850 (this is the correct port) Username: myusername Authentication Method: Public Key Private Key: C:\Path\To\My\Key Passphrase: mySSHpassword

I know that probably isn't much help because there's not really any "settings" other than the ports, which I know are correct.

I am running these exact same credentials on my Macbook which runs SequelPro and it works flawlessly, so I'm lost as to why I can't get it working on my PC through Navicat.

Thanks for any help you can provide.

Upvotes: 1

Views: 14887

Answers (2)

Carl Rempel
Carl Rempel

Reputation: 21

I was able to get my Navicat connected using SSH to my Rackspace MySql database from my OS X (MacBook).

The key was the settings in the General Tab. I had to set the HostName/IP to the remote name of the MySql Server.

[identifier-from-the-mysql-hostname-instance].rackspaceclouddb.com then the username and password as defined for my MySql database.

The SSH described in the prior responses, matched my settings.

Upvotes: 0

Sean Lynch
Sean Lynch

Reputation: 2983

The General tab would be set to localhost (or 127.0.0.1) and the username and password would be the database credentials, not the host credentials.

Then the SSH tab would be your host with the username password you use to ssh to the host. It should be the normal ssh port 22.

Upvotes: 5

Related Questions