Locked out

[jbarron]

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?

[MC10]

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.

[jbarron]

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

Thanks