Error 2013: Lost connection to MySQL server during query

[CryoGen]

I have MySQL 4.1.10 running successfully on an office XP machine, but when I try to set up similar XP box at home I continually get this error: "Error 2013: Lost connection to MySQL server during query".

The install went fine, and Windows XP says it has started and is running as a service. But whenever I try to connect via one of my GUI applications (e.g., MySQLFront), the error appears.

I have scoured this forum and Google looking for this error, but haven't found anything helpful so far. I've lost a couple days to this problem, and I've uninstalled and reinstalled the app several times. I don't know where to go next. I need to have 4.1 running because we need the Unions and Subqueries. Any help is appreciated.

Reply

 

[CryoGen]

Anyone?

 

[dalchri]

At a command prompt, type the following:

Ping localhost

Verify that it resolves to an IP address and that you get replies. If not, you don't have TCP/IP setup correctly. This can be a problem with computers that don't have a NIC.

Telnet localhost 3306

You should get the version of the database server as a response plus some garbage characters. If not, you might be blocking port 3306 in the windows firewall under the control panel.

 

[CryoGen]

It's replying to the Ping.

>Ping stats from 127.0.0.1:
>Packets sent = 4, Received = 4, Lost = 0%

I can also run MySQL from the command prompt, but nada from a GUI and I can't connect ColdFusion, which is really where my problem is. We're running a CF app that I need to develop from here, and it needs MySQL 4.1. I'm perplexed.

 

[dalchri]

The next thing to do is to check your error logs and look at your uptime to very that MySQL is not crashing. If it is crashing, you should be able to diagnose the problem using the error log.

I'd also recommend trying a second client to see if the problem is specifically between MySQL-Front and MySQL. Try creating a MyODBC connection in the control panel and using the test connection button when you create a DSN. This will avoid the need to code.

 

[CryoGen]

Thanks dalchri ... it looks like it's up. Your second tip from your first post did it. I disabled Norton Internet Security and everything worked fine.

Now I guess my problem is where to open the port in NIS. I can't leave NIS disabled ... but when I add 3306 to the http port list and enable, I'm still blocked. When I disable I'm fine. Any suggestions?

 

[CryoGen]

Thanks dalchri, your second suggestion from your first post did the trick. When I turn Norton Internet Security off, everything works fine. I have the Windows Firewall turned off in favor of NIS.

Problem is, when I enter 3306 to the NIS http port watch list it still won't allow the connection. When I disable NIS I'm good. When I renable, it's blocked. Where can I grant access for 3306 (if that's where my problem lies)?

 

[dalchri]

I don't know if this is applicable to your version but here are the instructions from Symantec:

http://service1.symantec.com/SUPPOR...&ver=&pcode=&src=&miniver=&tpre=&prev=&dtype=

I'm not sure you want to "watch" the port but rather just have Norton leave it alone with no molestation period.