Can’t connect to MySQL server on ‘localhost’

Asked By craigmull 10 points N/A Posted on - 08/04/2011

My warm greetings to all, I am new to using WordPress, that is why I am posting here a problem I meet while using the application, I pasted below the whole screen shot of the error for better understanding of my problem.

Error

Error running C:Program FilesWordPress

Stack/mysql/scripts/myscript.bat9903474784 : ERROR 2003 (HY000):

Can’t connect to MySQL server on ‘localhost’ (10061)

ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’

(10061)

ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’

(10061)

Ok

Since I am new with this application, the error message pasted above is so strange to me, I also consulted some friends about this, but they are also not familiar with the error message, so decided to post this issue here, in hope to get some advices and answers to my problem, I hope to hear from you all soon, thanks in advance.

• Status: Open
• Question Views: 1700
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By aemmy 10 points N/A #98100

Can’t connect to MySQL server on ‘localhost’

Hi,

I too had the same problem I was using MySQL 5 Community edition over CentOS. You can try the following to get the problem solved in which I have done lot of trials and got the solution.

Firstly try granting privileges to localhost as a root.

MySQL> grant all on *.* to 'localhost'@"%" identified by password;

MySQL> flush privileges;

Try also once dumping off the old database and dumping the database without actual data.. Please make sure you take the data backup before doing this.

I am sure the first solution will solve your problem.

Cheers
Aemmy

About aemmy

Questions
0

Answers
7

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/06/2011
• Question Category: Misc Software