MySQL said: Cannot connect: invalid settings. xampp

Question

I changed the root password to test and now I cannot able to login to phpMyAdmin page in XAMPP. I looked on the internet, which basically says changed config.inc.php file in XAMPP\PHPMYADMIN folder.

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'test';    <---- changed this
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'test'; <--- I changed this too (Edit: Not needed)

This code below works which uses the above password

if($_SERVER['REMOTE_ADDR']=="127.0.0.1")
{
define("DATABASE_SERVER", "localhost");
define("DATABASE_USERNAME", "root");
define("DATABASE_PASSWORD", "test");
define("DATABASE_NAME", "TIGERWOODS"); 

}  

This happened to me before on Mac and I could not resolve it. Now it happened again on Windows XP. I am using the Xampp 1.7.4. 

Answer 1

The solution for this is you need to change the line #9 in the above code.

$cfg['Servers'][$i]['AllowNoPassword'] = true;   <--- change this
$cfg['Servers'][$i]['AllowNoPassword'] = false;  <--- to this fixed the problem.

Note: There are other areas in localhost, where you neet to change the password manually. For example, in "CD Collection" example. The password is hard coded there rather than picking it up from the config.inc.php.

If you want to learn more about SQL, Check out this SQL Certification by Intellipaat.