asked on

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 ?

SOLUTION

_OpenSys_

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shakthi777

ASKER

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 Baldwin

How are you trying to login?

ASKER CERTIFIED SOLUTION

Shakthi777

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shakthi777

ASKER

thanks for the support !