Wamp mysql root password reset - not working

Asked Jul 13 '17 at 06:41

Active Jul 13 '17 at 06:41

Viewed 2,006 times

I need some assistance with my MySQL application (installed as part of the WAMP Server 3.0.0). I suspect somewhere along the lines MySQL became corrupted. When trying to log on with my root account, I get the following error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: ES)

I then followed the steps to reset the root password as per many of the Stackoverflow and MySQL guides but without any luck.

Picture

I suspect the only way forward is perhaps a reinstallation of MySQL, however, I only have the raw database files and not the most recent dump files. (Current dump files about 2 weeks old).

What are my options?

Is there something I overlooked?
Shall I proceed with new installation? If so, how do I restore the existing raw database files?

Appreciate any assistance.

Kind Regards

asked Jul 13 '17 at 06:41

Stephan Du Toit

Check this out before throwing everything away https://stackoverflow.com/questions/29070501/regaining-access-to-lost-mysql-password-for-phpmyadmin-on-wamp/29073563#29073563 – RiggsFolly Jul 13 '17 at 08:05
Thanks @RiggsFolly . I will attempt this solution and let you know the outcome. – Stephan Du Toit Jul 14 '17 at 15:16
@RiggsFolly, You are the man. Everything working perfectly again. Thanks so much! – Stephan Du Toit Jul 17 '17 at 06:23

Wamp mysql root password reset - not working

0 Answers0