Apache Friends Support Forum

No way of telling what the MySQL root password is. I installed xampp and the xampp security page claims that there is a password for mysql.

I tried "mysqladmin.exe -u root password secret" but I get the error: "Can't open named pipe to host"
what do I do?

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.html
Subheading:
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.