Forums: Back End:

So a while back I installed Apache2/PHP5/MySQl on my Win XP machine.

Everything was great. Apache started ok, MySQl started ok and the test scripts i was playing with all did as they were told.

Now - returning to this a couple of months later I am unable to connect to MySQL.

If I have start the service manually from Windows Services i am unable to log on via the script.

If I start try and start the service via a Command prompt I get the following error:

"can't connect to MySQL on 'localhost' (10061)"

Anyone experienced this problem before.

The username and password are correct.

A quick search suggests it might be a firewall problem -- you need to make sure your firewall isn't blocking access (usually on port 3306).

Ok - trashed my old my.ini files and used the my-small.ini and all seems to be ok.

Not exactly sure what the problem was tho.

Originally posted by: Stickman
A quick search suggests it might be a firewall problem -- you need to make sure your firewall isn't blocking access (usually on port 3306).

thanks - I'd been through all of that. Done a repair, a 'clean' install and nothing worked.

Deleting and recreating the my.ini from the my_samll.ini did it tho.

Strange. Ah well, glad you got it sorted.