MySQL service does not open 3306 port [solved]

[isabel]

Hello,

I have just installed XAMPP 1.7.7 and using XAMPP control panel 3.0.2 on a Windows Xp SP3

When I check security it says "A MySQL server is not running or is blocked by a firewall!" and the status is unknown. But it is running and I have checked the firewall and see that the service has complete access. And phpmyadmin works. The only issue is that I can't change password.

I think that it is a problem with the port, as in the control panel it does not show any port nor in Netstat, but I can't understand why the port is not opened and it works.

I've checked my.ini and php.ini and both are right.

Any idea?

Thanks in advance.

[isabel]

I've seen this in my.ini file :
socket = "C:/xampp/mysql/mysql.sock"
But there is no mysql.sock file, nor in XAMPP zip file

[isabel]

I've already solved.
I've found this post: http://community.apachefriends.org/f/viewtopic.php?f=16&t=50472
and this was the solution:

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.

Thanks anyway