Page 1 of 1

MySQL starting and stopping (Win 7 64bit) 1.7.7 [SOLVED]

PostPosted: 10. October 2011 15:18
by krazyjakee
I am on Windows 7 64 bit.
XAMPP 1.7.7

MySQL starts and stops again.
When run directly from explorer it says "there was an error and it has to close".
PHPMyAdmin says
Code: Select all
"#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"

I have removed and reinstalled xampp entirely.
Allowed through the firewall and turned the firewall off.
Turned off UAC.
Emptied windows host file.
Restarted.
My computer is malware free.

WHY IS THIS HAPPENING?!?!?!?

Re: MySQL starting and stopping.

PostPosted: 10. October 2011 15:20
by Sharley
We require your XAMPP version to provide the correct version support - please read the following Announcements.
viewtopic.php?f=16&t=48331
viewtopic.php?f=16&t=32670

Thanks.

Re: MySQL starting and stopping.

PostPosted: 10. October 2011 15:28
by krazyjakee
Done, thanks.

Re: MySQL starting and stopping.

PostPosted: 10. October 2011 15:46
by Sharley
Try uncommenting this line in the \xampp\mysql\bin\my.ini file
Code: Select all
#bind-address = "127.0.0.1"
So it looks like this
Code: Select all
bind-address = "127.0.0.1"
Save the file and restart Apache and MySQL.

Use a text editor only.

Please let me know if that helps.

Thanks. :)

Re: MySQL starting and stopping.

PostPosted: 10. October 2011 16:06
by krazyjakee
Initially it didn't work. I removed all xampp files, reinstalled, changed this setting and now it works.
Thanks VERY much Sharley, I can now continue developing in peace!
I googled this to death, glad I came here.

Thanks again.

Re: MySQL starting and stopping.

PostPosted: 10. October 2011 16:09
by Sharley
Your welcome and thanks for the feedback, great result. 8)

Best wishes. :)