phpMyAdmin error: "Cannot connect: invalid settings" in XAMPP

Question

I installed XAMPP and phpMyAdmin was working properly after the installation. But after finishing my work, when I restart my computer, the phpMyAdmin page says access denied and gives an error message, saying "Cannot connect: invalid settings".

Cannot connect: invalid settings

I did not change the username or password. I reinstalled XAMPP many times. It works properly after reinstalling, but it stops working after restarting my computer. The version is 5.5.38.

using your xampp controll panel, can you actually see mysql is running? — davejal
– davejal, Commented Feb 2, 2017 at 3:03
I think this question is better asked at superuser instead of stackoverflow — davejal
– davejal, Commented Feb 2, 2017 at 3:04
Just out of curiosity, are you running Skype? It (or another program) may be conflicting with your XAMP server. Try starting the server before all other programs after boot up (including auto-start programs). — Sablefoste
– Sablefoste, Commented Feb 2, 2017 at 3:16
This question has multiple answers, did none of them work for you? stackoverflow.com/q/7180893/3664960 — davejal
– davejal, Commented Feb 2, 2017 at 4:06

Peter Mortensen · Accepted Answer · 2023-07-31 10:14:53Z

1

I had a similar problem with MAMP when I first started using it.

There was a file called config.inc.php that I had to edit. This question might help you, it's pretty much the exact thing I did to fix it.

This link will take you to the XAMPP equivalent answer to what I used for MAMP: XAMPP MySQL password setting (Can not enter in PHPMYADMIN)

Specifically this part: (Couldn't get the code in the blockquote)

From "Xampp/phpmyadmin" directory in config.inc.php file find the below code. And follow the given instructions below. I have tried like this and I was successful to run both localhost/phpMyAdmin on browser, MySQL Command prompt as well as MySQL query browser.

$cfg['Servers'][$i]['auth_type']    = 'config';
$cfg['Servers'][$i]['user']         = 'pma';
$cfg['Servers'][$i]['password']     = '';
$cfg['Servers'][$i]['controluser']  = 'user_name/root';
$cfg['Servers'][$i]['controlpass']  = 'passwaord';

And replace the above each statement with the below each corresponding code.

$cfg['Servers'][$i]['auth_type']    = 'config';
$cfg['Servers'][$i]['user']         = 'root';
$cfg['Servers'][$i]['password']     = 'Muhammad Ashikuzzaman';
$cfg['Servers'][$i]['controluser']  = 'root';
$cfg['Servers'][$i]['controlpass']  = 'Muhammad Ashikuzzaman';

Basically, I had to change the file from the defaults to my username and password. After that I never had another login error.

edited Jul 31, 2023 at 10:14

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Feb 2, 2017 at 3:22

Jenny Holder

632 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

davejal Over a year ago

Links to external resources are encouraged, but please add context around the link so your fellow users will have some idea what it is and why it’s there. Always quote the most relevant part of an important link, in case the target site is unreachable or goes permanently offline. How to Answer

Jenny Holder Over a year ago

Thanks for the tips :) I just changed it.

davejal Over a year ago

I actually think the OP's server doesn't start up after boot, maybe he didn't install it as a service, but the OP didn't reply anymore

Jenny Holder Over a year ago

I'm not too familiar with XAMPP but if it's like MAMP I thought you had to have the servers up to open the myPHPadmin page and get that error. If the servers are down I get an error like this when trying to open myPHPadmin: This site can’t be reached localhost refused to connect. Try: Checking the connection Checking the proxy and the firewall ERR_CONNECTION_REFUSED

davejal Over a year ago

on windows I had times apache/nginx started with windows when installed with standard options and Mysql would need to install a service to be started at boot. If you didn't do that apache is started but MySQL isn't.

|

Isaac Bennetch · Accepted Answer · 2017-02-03 14:29:41Z

0

If you don't need any of the features provided by the phpMyAdmin configuration storage, you could edit config.inc.php and remove references to those tables (or, at the least, the lines about controluser, controlpass, and pmadb). If the problem is simply with authenticating the controluser, this will work around that problem.

answered Feb 3, 2017 at 14:29

Isaac Bennetch

12.5k2 gold badges37 silver badges46 bronze badges

Comments

Peter Mortensen · Accepted Answer · 2023-07-31 10:09:33Z

0

I use XAMMP on Windows 10.

I had commented these two lines of code.

/* User for advanced features */
//$cfg['Servers'][$i]['controluser'] = 'pma';
//$cfg['Servers'][$i]['controlpass'] = '';

Remove comments and it will work:

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

edited Jul 31, 2023 at 10:09

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Jun 16, 2017 at 16:26

juanitourquiza

2,2241 gold badge33 silver badges54 bronze badges

Collectives™ on Stack Overflow

phpMyAdmin error: "Cannot connect: invalid settings" in XAMPP

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related