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? 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? 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. 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 . . . 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... 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 . . . 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. 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. 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 . . . 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 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
Archived
This topic is now archived and is closed to further replies.