How to change or reset XAMPP MySQL root password?

If you want to reset or change xampp mysql password, or have forgot the password for accessing phpMyAdmin then just follow the below step to reset the password or change the password.


You can do this by two methods.


Method 1

The easiest way is to use the security console, which you can access at http://localhost/security/
This “console” creates a password for the MySQL user “root” and is adjusting the phpMyAdmin configuration.



Method 2

With the “XAMPP Shell” (command prompt) you can also reset the password. Open the shell and execute this command
mysqladmin.exe -u root password newpassword


Of course, your password should not be “newpassword”, too. In the next step you must adjust the phpMyAdmin configuration for this new password. In the file “D:\xampp\phpMyAdmin\” change the lines:

$cfg['Servers'][$i]['user']     = 'root';
$cfg['Servers'][$i]['password'] = '';


$cfg['Servers'][$i]['user']     = 'root';
$cfg['Servers'][$i]['password'] = 'newpassword';


Instead in the XAMPP Shell, you can also change the password with phpMyAdmin, and then adjust the phpMyAdmin configuration.

I hope, it will help.

One thought on “How to change or reset XAMPP MySQL root password?”

  1. I do not even know the way I ended up here, but I thought this post was once great.
    I don’t know who you might be but definitely you are going to
    a famous blogger in the event you aren’t already.

Leave a Reply

Your email address will not be published. Required fields are marked *