Can’t connect to MySQL server on ‘localhost’

Asked By 10 points N/A Posted on -
qa-featured

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’

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.

SHARE
Answered By 10 points N/A #98100

Can’t connect to MySQL server on ‘localhost’

qa-featured

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

Related Questions