reset MySQL root password

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

reset MySQL root password

Postby Harry57 » 25. October 2008 17:35

Having installed the package (on Vista Ult) and changed the root password for MySQL I now wish to revert to the default setting of null password. How do I do this please?
Harry57
 
Posts: 5
Joined: 25. October 2008 17:31

Postby Wiedmann » 25. October 2008 17:41

How do I do this please?

How have you changed the password the first time?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Harry57 » 25. October 2008 23:17

I simply started it using the Control Panel and changed the password using the security page http://localhost/security/xamppsecurity.php
Harry57
 
Posts: 5
Joined: 25. October 2008 17:31

Postby Wiedmann » 25. October 2008 23:51

and changed the password using the security page http://localhost/security/xamppsecurity.php

I've never tried this, but can't you use an empty password on this page?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Harry57 » 26. October 2008 10:23

I wouldn't ask if it was possible to do this.
Null password is not allowed to be set by this route.
Any idea how else I could change it ?
Harry57
 
Posts: 5
Joined: 25. October 2008 17:31

Re: reset MySQL root password

Postby Sharley » 26. October 2008 11:35

Harry57 wrote:Having installed the package (on Vista Ult) and changed the root password for MySQL I now wish to revert to the default setting of null password. How do I do this please?

Open phpMyAdmin.

Go to Privileges.

Click on the little Edit icon at the end of the user root row (looks like a pencil).

Scroll down to the Change Password box and select No Password - no need to change the hash setting.
Click on the Go in this box.

To test, close phpMyAdmin then open it again by simply entering root with no password.

Click on Go.

Job done and when you are ready you can follow this procedure to add a new password or use the XAMPP Security page you used in the first instance.

You should be aware of the resulting Warning Message:
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Postby Harry57 » 26. October 2008 11:52

very helpful, thanks.
I obviously should have known this but as I hadn't yet got to the phpAdmin functions your reply was just what I needed.
Thanks again.
Harry57
 
Posts: 5
Joined: 25. October 2008 17:31


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 47 guests