Sorry that I cannot remember exactly where I saw something about this, but it might have been on apachefriends.org OR nyphp.org/phundamentals
OK, actually, here it is:
http://www.apachefriends.org/en/faq-xampp-windows.htmlSubheading:
How I can set a "root" password in MySQL? (method 2)
- Code: Select all
With the"XAMPP Shell" (command prompt) you can also change the password. Open the shell and execute this command:
mysqladmin.exe -u root password secret
Of course, your password should not be "secret", too. In the next step you must adjust the phpMyAdmin configuration for this new password. In the file "\xampp\phpMyAdmin\config.inc.php" change the lines:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
to:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'secret';
Instead in the XAMPP Shell, you can also change the password with phpMyAdmin, and then adjust the phpMyAdmin configuration.