Sep 03, 2013, by admin
Hi all now in the post we are going to see How to change or reset XAMPP MySQL root password? hope this would be useful
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.
http://localhost/security/xamppsecurity.php
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:xamppphpMyAdminconfig.inc.php” change the lines:
$cfg[‘Servers’][$i][‘user’] = ‘root’;
$cfg[‘Servers’][$i][‘password’] = ”;
To:
$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.
Thanks To Scriptarticle