Error 2013 Lost Connection To Mysql

[West Dude]

Hi.

I have version 8.18 Enterprise version and are having no problem trying to connect to my local mysql server using SSH. However when I tried to connect to my webhosting server using the same configuration, I got Error 2013 Lost Connection to MySQL server at 'reading initial communication packet' System Error:2

Very strange error. I have big pipe to the internet and so does my webhosting provider. Contacted my hosting provider and they told me that it was issue with my network which I don't believe since I have a pretty large internet pipeline (20Mbps). Anyone has encountered this problem before and have a solution for it? The strange part was that it works just fine before. The only different is that now I have win7 which I don't believe should be the issue because I tested it on Winxp and it still gave me the same error. Any thought? Please advise?

[West Dude]

Sorry I didn't see the previous reply on the same problem. So yes I do have ssh forwarding enabled but still having the same issue. Strange. Any suggestion?

[West Dude]

'West wrote on '27:

Sorry I didn't see the previous reply on the same problem. So yes I do have ssh forwarding enabled but still having the same issue. Strange. Any suggestion?

My suspicion is with the mysql version sqlyog supported. I try to connect to mysql version 5.1.37-1 for FC11 with sqlyog, no problem. But when I tried connecting to mysql version 5.1.42-2 with sqlyoq, the 2013 error show up. This regardless whether my machine in on the server somewhere connecting via internet or the server is inside our LAN. Any comment? Please help?

[peterlaursen]

No clue.  Are you perfectly sure?

The server “5.1.42-2” is probably one installed from Fedora repositories (with 'yum') I guess.  I believe there is no such official MySQL version.  Could you try official MySQL builds?

A FTP link: ftp://mirrors.dotsrc.org/mysql/Downloads/MySQL-5.1/

(On Fedora and SuSE I always have used the 'glibc23' RPM builds with success.  But you will probably need to have support for older C runtimes installed. I am not sure If FC11 has as default (I have not been using Fedora since version 8).  If not the case the command to install those are “”yum install compat-libstdc++-33″” 

[West Dude]

Peter you are right. The version that gives me the error is installed using the yum install. Since I assumed that fedora won't add it in their yum repository unless they have already test it and approve it. I also did a test on the centos version 5.4 with the latest version offered via yum install and the version is 5.0.77 and it works just fine. Very strange. Any other thought?

[peterlaursen]

No idea.  I don't use Linux very much and when I do it is SuSE. For me the generic 'glibc23' RPM's from dev.mysql.com have always worked fine. I always have updated MySQL after installing the distro.  

[West Dude]

'peterlaursen' wrote on '01:

No idea.  I don't use Linux very much and when I do it is SuSE. For me the generic 'glibc23' RPM's from dev.mysql.com have always worked fine. I always have updated MySQL after installing the distro.  

I tried using the latest mysql and since I can only downloaded the community version and for some reason the mysqli are not installed and configured correctly so I'm kind of stuck now.. Either way, Thanks Peter for your help.

[peterlaursen]

I do not understand your reference to 'mysqli'.  If you are referring to the PHP mysqli extension SQLyog does not depend on it. 

In the beginning you wrote that connecting with SSH is a problem. What about direct connection? I think we should start figure out if this is a SSH problem or MySQL problem.

[West Dude]

'peterlaursen' wrote on '03:

I do not understand your reference to 'mysqli'.  If you are referring to the PHP mysqli extension SQLyog does not depend on it. 

In the beginning you wrote that connecting with SSH is a problem. What about direct connection? I think we should start figure out if this is a SSH problem or MySQL problem.

What am I saying was that when I used the latest version downloaded from mysql website, I can't get my php mysqli working properly. but when I used the official mysql version downloaded and installed via yum, I couldn't access mysql with ssh via sqlyog. but my php mysqli for the yum repository installed version work just fine. I kept getting the 2013 error from sqlyog when I tried to connect to it. Thought?

[West Dude]

Ok. I'm going to answer my own question then so that other people who may stumble around this same issue can resolve it faster.

somehow in my.cnf I added a line bind-address = ip address of the server which somehow cause mysql to refuse and drop the packet connection to the server because the binding address is different than how I'm going to connect to the server which is localhost.

So I changed the bind-address=localhost , restart mysql and that solved the problem.

Here is the link reference on how I figured it out.

http://forums.mysql.com/read.php?52,151255,156258#msg-156258

funny how you always solve the problem yourself after you start asking people on how to do it even though you've been banging on your head for couple of days wondering what the heck is going on. 🙂

Anyway, hope this help you all..

[Author]

Posts