Solved

Reset mysql root password for xamp on Windows ???

Posted on 2012-12-31
5
546 Views
Last Modified: 2013-02-04
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 ?
0
Comment
Question by:Shakthi777
  • 3
5 Comments
 
LVL 2

Assisted Solution

by:_OpenSys_
_OpenSys_ earned 500 total points
ID: 38732294
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
 

Author Comment

by:Shakthi777
ID: 38732310
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
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 38733216
How are you trying to login?
0
 

Accepted Solution

by:
Shakthi777 earned 0 total points
ID: 38733844
Tried phpmyadmin and used Mysql admin GUI too....
0
 

Author Closing Comment

by:Shakthi777
ID: 38850514
thanks for the support !
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question