Solution to phpMyAdmin - can't connect - invalid setings
phpMyAdmin - can't connect - invalid
setings - ever since I added a root password - locked out
MySQL Error:
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.
For wamp server:
Go to this folder C:\wamp\apps\phpmyadminVERSION\config.inc.php
and change this given lines.
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;
For xampp
server:
Go to this folder C:\xampp\phpMyAdmin\config.inc.php and
change this given lines.
$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 e.g.’root’
Comment below for any queries and suggestions. :-)
No comments:
Post a Comment