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 ?

MySQL Server

Last Comment

Shakthi777

8/22/2022 - Mon

SOLUTION

_OpenSys_

12/31/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Shakthi777

12/31/2012

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

12/31/2012

How are you trying to login?

ASKER CERTIFIED SOLUTION

Shakthi777

12/31/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options