Page 1 of 1

MySQL blocked by Firewall!

PostPosted: 01. September 2010 21:46
by ayushchd
Hi all,

I recently started getting this error on xampp which says MySQL is not running or is blocked by a Firewall.

I re installed xampp and firewall asked me if I wanted to allow the Apache Server and the MySQL server, I allowed them.

Now, when I start xampp, I get the same error. The Control Panel shows Xampp as running. I have read all over the place and haven't found a solution. Please help!

Re: MySQL blocked by Firewall!

PostPosted: 02. September 2010 09:37
by ayushchd
Its just the Windows Firewall. And the problem persists even if I disable Windows Firewall. Apache runs perfectly. The only issue is with MySQL!

Re: MySQL blocked by Firewall!

PostPosted: 02. September 2010 14:34
by JonB
What version of XAMPP?

Are you getting this error on localhost or when you access the server from a different machine?

in xampp/mysql/data/ there is the mysql.err file, why don't you paste the last few instance sets (they are separated by blank lines) into your reply, and put the code tags around them?

Good Luck
:)

Re: MySQL blocked by Firewall!

PostPosted: 02. September 2010 17:03
by ayushchd
Version : 1.7.3

I get the error on localhost

Code: Select all
100902  3:16:20 [Note] Plugin 'FEDERATED' is disabled.
100902  3:16:20  InnoDB: Started; log sequence number 0 46409
100902  3:16:20 [Note] Event Scheduler: Loaded 0 events
100902  3:16:20 [Note] C:\myhost\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.1.41'  socket: ''  port: 3306  Source distribution
100902  3:29:11 [Note] Plugin 'FEDERATED' is disabled.
100902  3:29:16  InnoDB: Started; log sequence number 0 46409
100902  3:29:22 [Note] Event Scheduler: Loaded 0 events
100902  3:29:22 [Note] C:\myhost\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.1.41'  socket: ''  port: 3306  Source distribution
100902 15:06:14 [Note] C:\myhost\xampp\mysql\bin\mysqld.exe: Normal shutdown

100902 15:06:15 [Note] Event Scheduler: Purging the queue. 0 events
100902 15:06:16  InnoDB: Starting shutdown...
100902 15:06:17  InnoDB: Shutdown completed; log sequence number 0 46409
100902 15:06:17 [Note] C:\myhost\xampp\mysql\bin\mysqld.exe: Shutdown complete

Re: MySQL blocked by Firewall!

PostPosted: 02. September 2010 20:48
by JonB
MySQL sure thinks it is working

can you run:

http://localhost/phpmyadmin

:?:

Re: MySQL blocked by Firewall!

PostPosted: 02. September 2010 21:12
by ayushchd
Yeah, but cannot login, gives me this error
Code: Select all
#2003 - Can't connect to MySQL server on 'localhost' (10060)
Connection for controluser as defined in your configuration failed.

Re: MySQL blocked by Firewall!

PostPosted: 03. September 2010 06:45
by JonB
I'm toast and its late - so no details tonite

BUT - the problem is most likely the config.inc.php

:shock: