XAMPP Day 1 / MySQL password

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

XAMPP Day 1 / MySQL password

Postby BLT » 14. January 2012 01:57

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.
BLT
 
Posts: 1
Joined: 13. January 2012 20:23
Operating System: OS X 10.6.6

Re: XAMPP Day 1 / MySQL password

Postby Altrea » 14. January 2012 02:57

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 112 guests