Page 1 of 1

How to reset MySQL password? [Answered]

PostPosted: 07. December 2012 03:47
by jim.reynolds
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?

Re: How to reset MySQL password?

PostPosted: 07. December 2012 12:52
by JonB
Use 'resetroot.bat' which is found in \xampp\mysql.

Good Luck
:)


ysf

Re: How to reset MySQL password?

PostPosted: 09. December 2012 01:32
by Twayne
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!

Re: How to reset MySQL password?

PostPosted: 09. December 2012 05:08
by JonB
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: