Wampserver login failure mysql windows 7

Question

When I try to log into phpmyadmin from wamp server(2.4 windows 7), following error comes up

2002 Cannot log in to the MySQL server

I used "root" as the username and empty box(didn't type anything) as the password

Wamp server was working fine until yesterday. Now the icon on the system tray is orange in color( earlier it was green)

Any body who can help??

score 1 · Accepted Answer · edited May 23 '17 at 10:26

1

Try restarting all the services by left-click on wamp icon.

Or try the solutions on phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin

Also read this post, http://forum.wampserver.com/read.php?2,119961

edited May 23 '17 at 10:26

Community

1
1

answered Mar 03 '14 at 06:48

Harshitha

36
5

About the old Q & A s My server was working perfectly. Its giving this error only since yesterday – Pubudu Dodangoda Mar 03 '14 at 10:12
did you recently install skype? – Harshitha Mar 03 '14 at 11:33
No I did not install anything recently – Pubudu Dodangoda Mar 03 '14 at 12:38
1

try the solution on http://forum.wampserver.com/read.php?2,119961. Or back up your www folder and reinstall wamp. – Harshitha Mar 04 '14 at 04:39

score 0 · Answer 2 · answered Mar 03 '14 at 06:56

0

Try to execute netstat -nlpt command.And figure out mysql process .Kill it and start your wampp.

answered Mar 03 '14 at 06:56

Jeevan Roy dsouza

653
3
12
32

how do I do that. When I execute that command it lists several letters and a description. How do I find the mysql process? – Pubudu Dodangoda Mar 03 '14 at 10:07
find out mysql port and check process id – Jeevan Roy dsouza Mar 03 '14 at 10:13
pass me the output of that – Jeevan Roy dsouza Mar 03 '14 at 10:14

score 0 · Answer 3 · answered Jun 17 '14 at 07:00

If you change your mysql port, so you need to check mysql port on php.ini

mysqli.default_port = <your_port_goes_here>

Default port is 3306. So if you change your port, you need to change your port on php.ini and restart all services. In some case, this small mistake produce error #2002 Cannot log in to the MySQL server.

Wampserver login failure mysql windows 7

2002 Cannot log in to the MySQL server

3 Answers3