How to reset MySQL password? [Answered]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to reset MySQL password? [Answered]

Postby jim.reynolds » 07. December 2012 03:47

I feel like someone just gave me the keys to the car on the day I got my drivers' license, and I ran into a tree when I was backing out of the driveway.

Got everything running and noticed a security warning that I'd installed MySQL 'root' without a password, and I should change it immediately. So I did but now phpmyadmin and Joomla cannot connect to it. I'm not even sure where I change it. It's even possible that I told phpmyadmin to look for a new password that I had not yet set in mysql. So ...

Where are the places that I can set/update the root user password for mysql so that xampp, mysql, apache, and joomla all talk to each other?
jim.reynolds
 
Posts: 3
Joined: 24. November 2012 04:31
XAMPP Version: 5.6.3
Operating System: Windows 7 64-bit

Re: How to reset MySQL password?

Postby JonB » 07. December 2012 12:52

Use 'resetroot.bat' which is found in \xampp\mysql.

Good Luck
:)


ysf
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: How to reset MySQL password?

Postby Twayne » 09. December 2012 01:32

OK:
"Use 'resetroot.bat' which is found in \xampp\mysql."

is effective and great advice. In my case it left two sqld processes running in Task Manager's properties and I had to End Process them before the .bat fle worked, but - that's OK - it worked just fine.

NOW, how do I put back a PW? I want the passwords for securty - this time I'll make absolutely certain I record the password/s!
Twayne
 
Posts: 3
Joined: 30. March 2008 19:42

Re: How to reset MySQL password?

Postby JonB » 09. December 2012 05:08

Use the script found on the XAMPP security page (shows status)
http://localhost/security/index.php

on that same page is the link to the script to make the changes:
http://localhost/security/xamppsecurity.php

Image

Note there are checkboxes to save the passwords.

Good Luck
:mrgreen:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 51 guests