Reset mysql root password for xamp on Windows ???

Shakthi777
Shakthi777 used Ask the Experts™
on
Hi Experts,

I was running xamp  version 1.7.3 (MySQL 5.1.41) in Windows 2008 and MySql root password set to blank. But suddenly I can't log in to the MySQL data base using root.

I have tried http://veerasundar.com/blog/2009/01/how-to-change-the-root-password-for-mysql-in-xampp/ 

But so far no luck, can you kindly let me know how do I reset MySQL root password ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Please read: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

C.5.4.1.1. Resetting the Root Password: Windows Systems

Author

Commented:
Already tried and I get following error;

C:\xampp\mysql\bin>mysqld-nt --init-file=C:\reset.txt
'mysqld-nt' is not recognized as an internal or external command,
operable program or batch file.

Open in new window


Also I tried only "mysqld" and again getting bellow error

C:\xampp\mysql\bin>mysqld.exe --init-file=C:\reset.txt
121231 16:00:40 [Warning] Can't create test file \usr\local\mysql\data\SRV1.lower-test
121231 16:00:40 [Warning] Can't create test file \usr\local\mysql\data\SRV1.lower-test
mysqld.exe: Can't change dir to '\usr\local\\mysql\data\' (Errcode: 2)
121231 16:00:40 [ERROR] Aborting

121231 16:00:40 [Note] mysqld.exe: Shutdown complete

Open in new window


Please help and thanks for your time !
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
How are you trying to login?
Tried phpmyadmin and used Mysql admin GUI too....

Author

Commented:
thanks for the support !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial