Fix MySQL said Cannot connect invalid settings phpmyadmin xampp

Solve retry to connect xampp error.

Sometimes process of changing username or password into phpmyadmin xampp control panel by mistake you will change its some other settings and it will display you a error message ” MySQL said Cannot connect invalid settings ” and after then phpmyadmin user cannot starts phpmyadmin database control panel. So here is the complete step by step tutorial for Fix MySQL said Cannot connect invalid settings phpmyadmin xampp.

Fix MySQL said Cannot connect invalid settings phpmyadmin xampp

Error message look like this :

MySQL said:

Cannot connect: invalid settings.

phpmyadmin tried to connect to MySQL server, and the server rejects the connection. You should check the Host, Username or password in your configuration and make sure that they correspond to the information given by the administrator or MySQL.

How to Fix MySQL said Cannot connect invalid settings phpmyadmin xampp.

1. Goto C:\xampp\phpMyAdmin .

2. Locate and open config.inc.php file .

3. Find below lines :

/* Authentication type and info */
$cfg[‘Servers’][$i][‘auth_type’] = ‘http’;
$cfg[‘Servers’][$i][‘user’] = ‘root’;
$cfg[‘Servers’][$i][‘password’] = ”;
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = true;
$cfg[‘Lang’] = ”;

4. Now replace the config to http inside $cfg[‘Servers’][$i][‘auth_type’] = ‘config’ line .Line after changing should look like this :

$cfg[‘Servers’][$i][‘auth_type’] = ‘http’;

5. Now enter any password inside $cfg[‘Servers’][$i][‘password’] = ”; . Line will look like this after changing password.

$cfg[‘Servers’][$i][‘password’] = ‘pass’;

6. Save the config.inc.php file.

7. Type localhost/phpmyadmin again inside your web browsers address bar. Now it will ask you username & password so enter username as root and password as pass .

Leave a Reply

Your email address will not be published. Required fields are marked *