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

user_127212 0
Viewed 189736

I run XAMPP, a few days back i had set up a password for the root password through phpmyadmin I am not able to access phpMyAdmin ever since that moment

I followed help on this link but everything seems fine there (in config.inc.php). I even tried unistalling xampp fully, restarting windows and then reinstalling xampp, but still pointing to localhost/phpmyadmin I get the following 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.

I Also tried to reset root password through mysqld.bat as given on mysql's website help but to no avail

Please Help! Here's a screenshot describing the situation: enter image description here

phpmyadmin root mysql
14 Answers

For any ubuntu users visiting this page, I was facing the same error and the issue was XAMPP (LAMPP in ubuntu) was not able to connect to mysql because another mysql service was working so my solution to this issue was

stop mysql service

sudo service mysql stop

restart lampp

sudo /opt/lampp/lampp restart
user_9179290

For AMPPS, I have to add this is my phpMyAdmin/config.inc.php

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

Note: In Ubuntu, I had to locate where the file is and I used locate config.inc.php

This answer is only meant for local, development purposes :)

user_20984930

This happened to me. The best way to solve is to go to computer>Local disk>xampp. Right click on the xampp folder and restore it to a previous date that worked. It worked perfectly for me.

user_66693830
Related