MySQL said: Cannot connect: invalid settings | Xampp-Phpmyadmin

mysql-said-cannot-connect-invalid-settings

When you tried to access http://localhost/phpmyadmin [Phpmyadmin] on your localhost [Xampp installation] you may encounter the below error due to changes in the user privileges.You should be careful when dealing with the password of users.
xampp-MySQL-said--Cannot-connect-invalid-settings

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 your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I have tried several ways to resolve the above but that didn't worked out for me.Try this following simple steps to fix the phpmyadmin issue.

1.Goto local-disk (c)>> Xampp >Phpmyadmin
2.Open Config.inc.php
3.Goto the below line

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

4.Change the settings from 'Config' to 'http' on the line $cfg['Servers'][$i]['auth_type'] = 'config';
5. Now set any name for the the line $cfg['Servers'][$i]['password'] = '';
Example:-   $cfg['Servers'][$i]['password'] = 'test';
6.Save the Config.inc.php file
7.Now load your web-browser
8.A box will pop-up asking for Authentication using username and password
Tyle the username as “root” password as “test
9.That's it

category: