No idea what MySQL password is, Can't change it either

Problems with the Windows version of XAMPP, questions, comments, and anything related.

No idea what MySQL password is, Can't change it either

Postby 0ni » 24. February 2010 20:22

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?
0ni
 
Posts: 3
Joined: 22. February 2010 22:23

Re: No idea what MySQL password is, Can't change it either

Postby Mobius » 25. February 2010 00:35

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.
Mobius
 
Posts: 8
Joined: 24. February 2010 00:48


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 52 guests