Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
Solved
Reset mysql root password for xamp on Windows ???
Posted on 2012-12-31
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 ?
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 ?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
5 Comments
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
C.5.4.1.1. Resetting the Root Password: Windows Systems
Already tried and I get following error;
Also I tried only "mysqld" and again getting bellow error
Please help and thanks for your time !
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.
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
Please help and thanks for your time !
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html). It addresses one of the most common problems that plague beginning PHP develop…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
- Query Syntax
- SQL
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases, Percona
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month8 days, 11 hours left to enroll
597 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.