Locked out

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

Locked out

Postby jbarron » 21. April 2010 18:09

I have installed Xampp 1.7.0 for Windows and it is working fine for my moodle site. Now I want to add another MySql database and set up another instance of Moodle and I am locked out of Xampp..........when I click on phpMyAdmin in Xampp I get the following error message.

MySQL said:

cannot connect: invalid settings.

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in you configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Where do I find the configuration file..........and is there a way to reset the passwords for this and allow it to connect?
Posts: 2
Joined: 21. April 2010 16:49

Re: Locked out

Postby MC10 » 26. April 2010 02:53

The configuration files are in \xampp\phpMyAdmin\config.inc.php, lines 18-22:

Code: Select all
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type']            = 'config';
$cfg['Servers'][$i]['user']                 = 'root';
$cfg['Servers'][$i]['password']             = '';
$cfg['Servers'][$i]['AllowNoPassword']      = true;

Add the password in between the '' in the password section, and try accessing phpMyAdmin again.
Posts: 148
Joined: 20. February 2010 20:13

Re: Locked out

Postby jbarron » 26. April 2010 22:36

Thank you so much that worked............I just had to put our password in that config file and it worked............

Thanks :D
Posts: 2
Joined: 21. April 2010 16:49

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 23 guests