Reset mysql root password for xamp on Windows ???

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 ?
Shakthi777Asked:
Who is Participating?
 
Shakthi777Connect With a Mentor Author Commented:
Tried phpmyadmin and used Mysql admin GUI too....
0
 
_OpenSys_Connect With a Mentor Commented:
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
0
 
Shakthi777Author 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 !
0
 
Dave BaldwinFixer of ProblemsCommented:
How are you trying to login?
0
 
Shakthi777Author Commented:
thanks for the support !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here