Can't connect to MySQL server error on IIS

[chilluk]

I have MySQL / PHP running on Win2k3 / IIS6

 

Whenver I have had to reboot the server in the past it has taken some time for the MySQL databases to start accepting connections and I get the standard "Can't connect to MySQL server on 'localhost' (10061)" message - normally 10 minutes or so after reboot the message goes away and all is well.

 

The server had a more major crash over the weekend, and I had to reboot it. I noticed from the event viewer that it was an hour or so after the reboot when there was an entry in the log stating that MySQL was ready to accept connections. I have rebooted again this morning for other reasons and still 2 hours later I can not get MySQL to accept connections.

 

The server is running AVG for anti virus - was wondering if that would be blocking anything?

 

Any ideas what to look for / check / change to get this thing running, and then keeping it reliable?

 

Many Thanks

 

Chris

[jaymc]

Login locally and try and connect via the command line rather than external

[chilluk]

I have tried that also and get same error.

 

Server also has Windows Defender installed as well as AVG - was just wondering if an update to either has blocked MySQL?

 

Or has MySQL corrupted perhaps?

[mezise]

Server also has Windows Defender installed as well as AVG - was just wondering if an update to either has blocked MySQL?

Just disable these applications and check.

[chilluk]

Done that and still no joy.

 

Having one of those days - because I am desperate to get these sites backup I though about copying off onto another server where MySQL is functioning - I get the following error on queries :

 

Error Code : 1034

Incorrect key file for table 'tblproductqty'; try to repair it

 

Seems like when I look at DB through SQLYog half the tables are missing.

 

I tried a repair of the tables MYI file through command line myisamchk and it seemed to report it had done something but I still can't get at the data.

 

So I have no access to existing MySQL db and the copied data I have is also useless.

 

Bad day getting worse...

[mezise]

So try to execute:

REPAIR TABLE YourDatabaseName.tblproductqty EXTENDED;

[chilluk]

OK thanks for that - got over that hurdle and setup the most critical site on another server all OK now

 

Back to original server I can not get MySQL to work on that. I have uninstalled and am now trying to reinstall - it gets as far as "Apply Security Settings" on the final page after the Execute button is pressed and hangs up.

 

If I crash out of the install the service seems to be running but I can't get a connection either through command line or one of the GUI tools (SQLYog etc). Also the mysql service cannot be restarted from the Services facility - it hangs up and the process has to be killed.

 

Any ideas to get successful reinstall? Is there anything that needs clearing out before trying again? Registry settings etc?

 

Many Thanks

[chilluk]

OK I have got a bit further - I can run MySQL under console mode from a command prompt and connect locally etc but as soon as I try and start it normally it just hangs up when trying to make a connection - does that give any clues?