Page 1 of 1

Error-MySql said: Cannot connect: invalid settings.

PostPosted: 30. July 2009 08:27
by 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?

Re: Error-MySql said: Cannot connect: invalid settings.

PostPosted: 30. July 2009 09:25
by 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.

Re: Error-MySql said: Cannot connect: invalid settings.

PostPosted: 30. July 2009 09:35
by 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;

Re: Error-MySql said: Cannot connect: invalid settings.

PostPosted: 30. July 2009 09:37
by abhijitp
Hey, its working..I deleted all cookies and temp files and clicked refresh and it worked.

Thanks!!

Re: Error-MySql said: Cannot connect: invalid settings.

PostPosted: 18. July 2012 09:55
by lina88
I had similar problems which persisted after re-installation of XAMPP.

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