1.7.7 - MySQL not running or blocked by firewall (SOLVED)

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

1.7.7 - MySQL not running or blocked by firewall (SOLVED)

Postby totti01 » 06. October 2011 05:16

Hi,

I successfully installed XAMPP v1.7.7 but I am having problems with MySQL. I am running Windows XP SP3.

Apache works and I can access localhost just fine, and both Apache and MySQL are listed as Running in the Control panel. XAMPP Status says MySQL, PHP,.. are activated. However, XAMPP Security says:

Code: Select all
MySQL status is Unknown - "A MySQL server is not running or is blocked by a firewall!"

And, when I go to [http://localhost/security/xamppsecurity.php] I can only add a username/password for .htaccess.. But nothing under MySQL

Code: Select all
MYSQL SECTION: "ROOT" PASSWORD
MySQL SuperUser:    root     
The MySQL server is not running or is blocked by a firewall! Please check this problem first ...


I tried disabling Norton (and Windows) firewall; unchecked [use port 80] in Skype; installed/uninstalled MySQL server 5.5; installed/uninstalled XAMPP 1.7.7; and installed/uninstalled XAMPP 1.7.4... without any success!
[Right now, I only have XAMPP 1.7.7 installed]

I should mention that both Apache and MySQL are not (listed as) Services. I always start/stop from XAMPP control panel, and uninstall from Apachefriends>XAMPP>Uninstall. I also do a Clean Registry (from Norton Utilities) after each uninstall, and reboot!

A bit of history... I had old versions of Apache, MySQL, PhpMyAdmin installed and were working fine - all were uninstalled before installing XAMPP 1.7.7

So you can understand my frustration.. Have I missed or messed :) anything?


Thanks,
Totti

Here're the log files.

=========Apache error.log says:=========
Code: Select all
[Thu Oct 06 15:46:28 2011] [notice] Digest: generating secret for digest authentication ...
[Thu Oct 06 15:46:28 2011] [notice] Digest: done
[Thu Oct 06 15:46:31 2011] [notice] Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Thu Oct 06 15:46:31 2011] [notice] Server built: Sep 10 2011 11:34:11
[Thu Oct 06 15:46:31 2011] [notice] Parent: Created child process 836
[Thu Oct 06 15:46:33 2011] [notice] Digest: generating secret for digest authentication ...
[Thu Oct 06 15:46:33 2011] [notice] Digest: done
[Thu Oct 06 15:46:34 2011] [notice] Child 836: Child process is running
[Thu Oct 06 15:46:34 2011] [notice] Child 836: Acquired the start mutex.
[Thu Oct 06 15:46:34 2011] [notice] Child 836: Starting 150 worker threads.
[Thu Oct 06 15:46:34 2011] [notice] Child 836: Starting thread to listen on port 443.
[Thu Oct 06 15:46:34 2011] [notice] Child 836: Starting thread to listen on port 80.
[Thu Oct 06 15:46:34 2011] [notice] Child 836: Starting thread to listen on port 443.
[Thu Oct 06 15:46:34 2011] [notice] Child 836: Starting thread to listen on port 80.

=========MySQL error.log says:=========
Code: Select all
111006 16:31:11 [Note] Plugin 'FEDERATED' is disabled.
111006 16:31:11 InnoDB: The InnoDB memory heap is disabled
111006 16:31:11 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111006 16:31:11 InnoDB: Compressed tables use zlib 1.2.3
111006 16:31:11 InnoDB: Initializing buffer pool, size = 16.0M
111006 16:31:11 InnoDB: Completed initialization of buffer pool
111006 16:31:11 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
111006 16:31:11  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
111006 16:31:11  InnoDB: Waiting for the background threads to start
111006 16:31:12 InnoDB: 1.1.8 started; log sequence number 1595675
111006 16:31:12 [Note] Event Scheduler: Loaded 0 events
111006 16:31:12 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16'  socket: ''  port: 3306  MySQL Community Server (GPL)
totti01
 
Posts: 2
Joined: 06. October 2011 03:44

Re: XAMPP 1.7.7 - MySQL not running or blocked by firewall

Postby Sharley » 06. October 2011 05:22

Thanks for the detailed post. 8)

Use the version 3 control panel found in the xampp folder, which has many more features than the standard 2.5 version and see what it has to say about it - there is a log file created in the xampp folder.

Make sure that any other security type application is not blocking port 3306

Make sure your firewall has port 3306 open as it is not port 80 related.

IMHO, something is blocking access to port 3306 on your system as MySQL has started no problem but you are prevented from access it.

It may also help to uncomment (remove the #) from this line in the xampp\mysql\bin\my.ini file
Code: Select all
#bind-address="127.0.0.1"
Save the file and restart MySQL.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: XAMPP 1.7.7 - MySQL not running or blocked by firewall

Postby totti01 » 06. October 2011 07:36

Hi Sharley,

Thanks for the quick reply. I removed the comment from the [bind-address="127.0.0.1"] and IT WORKED!

YOU are a lifesaver... Thanks a ton :)

GO AUSSIES :)
totti01
 
Posts: 2
Joined: 06. October 2011 03:44

Re: XAMPP 1.7.7 - MySQL not running or blocked by firewall

Postby Sharley » 06. October 2011 07:39

Great result and thanks for the feed back. 8)

Best wishes. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 124 guests