hackattack142 wrote:This sometimes fixes this error:
Try opening your "/xampp/mysql/bin/my.ini" file, and finding this line:
- Code: Select all
#bind-address="127.0.0.1"
, remove the "#" in front of it, save the file, and restart MySQL. When you visit the phpMyAdmin page http://localhost/phpmyadmin make sure you manually refresh the page in your browser so you do not get a cached error page.
WOW
THANKS hackattack142 - i have just registed to say thanks , its took me two days to get the mysql connection working
i have tried for 48 hours looking through countless forums and trying loads of fixes and 6 installs , and finally your fix has solved it
I have just done what you said - removed the " #" from that line and its working yiippee
Also as Hackattack142 says - remember to restart you mysql service
For other users -i was trying to install xammp on windows 7 64k and was getting the error
Connection for controluser as defined in your configuration failed
and the mysql server in xammp was showing deactivated but my services were running ok, it seems to be a firewall problem but had tried everything till this, its the 1st place i have come across this fix
Also i was having the same problem when trying to install mysql and apache as seperate items, and the mysql server instatnce was jamming after staring the mysql service - on the finall security part
Hope this also helps other users
thanks again
Lg