MySQL service does not open 3306 port [solved]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL service does not open 3306 port [solved]

Postby isabel » 24. May 2012 10:13

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.
Last edited by isabel on 24. May 2012 11:16, edited 1 time in total.
isabel
 
Posts: 3
Joined: 24. May 2012 07:07
Operating System: Windows XP SP3

Re: MySQL service does not open 3306 port

Postby isabel » 24. May 2012 10:45

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
 
Posts: 3
Joined: 24. May 2012 07:07
Operating System: Windows XP SP3

Re: MySQL service does not open 3306 port

Postby isabel » 24. May 2012 11:15

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
isabel
 
Posts: 3
Joined: 24. May 2012 07:07
Operating System: Windows XP SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 47 guests