Solution to phpMyAdmin - can't connect - invalid setings - Tech Geek Loves Music

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. :-)

Bluestacks App Error | Physical Memory Error Solution

Bluestacks App Error | Physical Memory Error Solution | *What can you achieve by doing this?* 1. Solutions to Increase the Memor...

Powered by Blogger.