mtwhite Posted January 29, 2012 Share Posted January 29, 2012 I installed XAMPP 1.7.7 about 3-4 months ago (I'm using Vista Home Premium). I've had no problems since the install and use this as my sandbox to develop Wordpress sites. Today I am unable to get to the phpmyadmin panel either from the XAMPP control panel or from the browser XAMPP Tools area. It responds with "Cannot connect: invalid settings". I have made no changes and the config.inc.php is correct as far as user and password. The only item that could be even remotely related is I downloaded Drupal and unzipped the program in a separate folder (not in the XAMPP directory). I did not install it, only unzipped the zip file. I cannot imagine this had anything to do with it but wanted to include all info in this post. The only help I see in any of these boards is to review the config.inc.php file and that is correct. Any thoughts? Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/ Share on other sites More sharing options...
Pikachu2000 Posted January 29, 2012 Share Posted January 29, 2012 And you're sure MySQL is running, right? Have you tried a stop/start of Apache and MySQL? Rebooted WinD'ohs? Anything else you've done to try to diagnose this? Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/#findComment-1312100 Share on other sites More sharing options...
mtwhite Posted January 29, 2012 Author Share Posted January 29, 2012 Yes, both Apache and MySQL are running and I can stop and restart them without error. I have rebooted Windows. The Wordpress site that I'm working on can still be viewed so I'm stumped. Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/#findComment-1312102 Share on other sites More sharing options...
Pikachu2000 Posted January 29, 2012 Share Posted January 29, 2012 I've had this problem, but never locally. If I recall, I had to clear my session cookies and site cookies but it's been quite some time ago, so I'm not certain that was all it took . . . Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/#findComment-1312103 Share on other sites More sharing options...
mtwhite Posted January 29, 2012 Author Share Posted January 29, 2012 Ok, cleared the session and my browser cache, same error. I saw in other forums where XAMPP was uninstalled and reinstalled but that fixed it in less than 1/3 of the instances. I've seen others say it was virus related but I'm good there. I'm out of ideas. This captcha to post sure is a pain... Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/#findComment-1312105 Share on other sites More sharing options...
Pikachu2000 Posted January 29, 2012 Share Posted January 29, 2012 I don't really remember what fixed it for me, so I'm about as far as I can go with it. I can't even recreate the scenario to see what may cause it, since I'm on Mac OS. The captcha will go away after (IIRC) 10 posts . . . Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/#findComment-1312117 Share on other sites More sharing options...
mtwhite Posted January 29, 2012 Author Share Posted January 29, 2012 Thanks for your help Pikachu2000, I'll look around a little more and then it's not resolved I'll try reinstalling after backing up the databases. Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/#findComment-1312281 Share on other sites More sharing options...
mtwhite Posted January 29, 2012 Author Share Posted January 29, 2012 You are not going to believe this but I just went in and it's now working. I made NO changes. Ghost in the machine I guess. Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/#findComment-1312284 Share on other sites More sharing options...
Pikachu2000 Posted January 29, 2012 Share Posted January 29, 2012 Oh, well that's good. I hope it lasts . . . Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/#findComment-1312322 Share on other sites More sharing options...
Tinytod Posted July 27, 2012 Share Posted July 27, 2012 I also faced this kind of problem. But i resolved in the below process. step 1: Open the file with notepad with the following path: C:\xampp\phpMyAdmin\config.inc.php step 2: modify the configuration settings like this : /* Authentication type and info */ $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'root'; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['AllowNoPassword'] = false; now try to open phpmyadmin. Happy logged in and created unlimited databases. :) Regards, Nagendra www.imnagendra.in Quote Link to comment https://forums.phpfreaks.com/topic/255961-mysql-said-cannot-connect-invalid-settings/#findComment-1364856 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.