Error-MySql said: Cannot connect: invalid settings.

[abhijitp]

There was no password set for user 'root' on localhost. It was showing a warning at the bottom that the root has no password..etc.

Now I am getting this error message when i changed the password. And also my portal is not working. How do it resolve it?

[Wiedmann]

Error-MySql said: Cannot connect: invalid settings

I guess that's from phpMyAdmin?

Now I am getting this error message when i changed the password.

You must also set this password in the phpMyAdmin configuration file.

And also my portal is not working.

The same for your portal software.

[abhijitp]

You must also set this password in the phpMyAdmin configuration file.

Where will i find this file? Is it C:\xampp\phpmyadmin\config.inc.php ?
If yes, then its still not working (same error) after doing this:

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

Changed to :

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'test';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

[abhijitp]

Hey, its working..I deleted all cookies and temp files and clicked refresh and it worked.

Thanks!!

[lina88]

I had similar problems which persisted after re-installation of XAMPP.

clearing the cookings did the job for me at the end!