Wednesday, November 27, 2013

phpMyAdmin - can't connect - invalid setings - ever since I added a root password - locked out

I Got the Error:

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.
and I Solved it by using the solution written Below.

For wamp server:
IN: C:\wamp\apps\phpmyadminVERSION\config.inc.php
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true; 

$cfg['Servers'][$i]['AllowNoPasswordRoot'] = false; 
For xampp server:
because of xampp server had the following settings.
C:\xampp\phpMyAdmin\config.inc.php
$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = ''; // which is default setting in xampp server

$cfg['Servers'][$i]['password'] = 'your password';//type your password you have changed
DONE..

No comments:

Post a Comment