Apache Friends Support Forum

Installed XAMPP. First time doing this.

Saw a warning about how not having a root password was very unsafe, so I set a password. (Wrote it down.)

Now phpMyAdmin fails to connect to MySQL, with the following error:

--------------------
Error
MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
-------------------

1) Where can I get a password prompt? OR
1b) Where is the configuration file where I should enter the password? (How am I supposed to know this?)
2) Does any truly "beginner documentation" exist? Most of what I've seen here assumes a great deal of prior knowledge. All I want to do is set up a parallel WP environment for testing themes and plug-ins - should be really standard.

Thanks.

Hi BLT,

BLT wrote:1) Where can I get a password prompt?

• Please open your \xampp\phpMyAdmin\config.inc.php file
• Search for $cfg['Servers'][$i]['auth_type'] = 'config';
• Change the line to $cfg['Servers'][$i]['auth_type'] = 'cookie'; and save the file

After that change you should get a login prompt.

BLT wrote:1b) Where is the configuration file where I should enter the password? (How am I supposed to know this?)

In the same file. But it is not recommend.

BLT wrote:2) Does any truly "beginner documentation" exist?

Thus XAMPP is just a preconfigured package of well known single components, there is not such a beginner guide.
All Users have a different knowledge and demand to that components so it would be very difficult to fit it all.
A good start is the readme_en.txt file which comes with your XAMPP installation.
There are also some good tips on the XAMPP for Windows page or the XAMPP for Windows FAQ

BLT wrote:Most of what I've seen here assumes a great deal of prior knowledge.

What have you seen?

BLT wrote:All I want to do is set up a parallel WP environment for testing themes and plug-ins - should be really standard.

Indeed, it is.

best wishes,
Altrea