reset MySQL root password

[Harry57]

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?

[Wiedmann]

How do I do this please?

How have you changed the password the first time?

[Harry57]

I simply started it using the Control Panel and changed the password using the security page http://localhost/security/xamppsecurity.php

[Wiedmann]

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?

[Harry57]

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 ?

[Sharley]

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.

[Harry57]

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.