01-01-09, 23:43 #1Registered User
- Join Date
- Jan 2009
Unanswered: Getting ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
Can someone help me to overcome to problem when using mysql
"ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)"
I installed the mysql and using it and after rebooting of my system it generated an error "ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)".
01-04-09, 09:24 #2Registered User
- Join Date
- Feb 2008
- Bandung - Indonesia
I think the problem is on your mysql - user table.
Maybe its corrupted, so the mysql server can't run properly.
1. Uninstall your mysql
2. Dont forget to delete manually DATA folder on its directory that keeps the mysql database.... if you have something important data, please backup first. Or you can just delete the mysql folder on data folder. No require to delete data folder.
3. Install fresh mysql
4. If succeed, please backup the mysql folder on data folder.
Some of the contents are:
I hope you understand what i try to write here.
Sorry for my ackward English.
Last edited by galih; 01-04-09 at 09:51.Forum Informatika - Indonesian Informatics Online Community - http://if.web.id
01-04-09, 09:45 #3Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
that error message suggests to me that the MySQL server isn't active, or there is something between the applciation and the server tha is blocking connection (eg a firewall or proxy server/ NAS)
so I'd want to first of all prove MySQL is actaully running
in windows look for a process called mysqld-nt.exe
in Linux lookat the system services and look for MySQL
if you are running a firewall make sure the specified port is open (usually MySQL runs on 3306
if thats working then I'd suggest you download the mySQL graphical tools from the MySQL site and see if either query browser and or Adminstrator can connect to the specified server.
after that it cvould be the app is not looking for the correct mYSQL server.... ie there are some config steps needed to get the app to talk to the required server.
if your server isn't on the same machine as the application that is generating the localhost message then its a config issue.I'd rather be riding on the Tiger 800 or the Norton