Apache Friends Support Forum

Hi all,

Trying to install XAMPP for a friend. For some reason, it isn't allowing me to load MySQL. I was having troubles launching Apache so a simple uninstall and downgrade to version 1.8.0 (I think), solved the issue.

17:25:30 [mysql] Starting mysql app...
17:25:31 [mysql] Status change detected: running
17:25:32 [mysql] Status change detected: stopped

Error log for MySQL:
http://pastebin.com/est9VKiH

Any ideas?

Cheers

Hi Wasley,

first: v3.0.12 is just the version number of the XAMPP control panel.
The correct version information for the XAMPP package can be found in the readme file which is located in your xampp directory.

121101 17:11:20 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)

This is the issue.
This is a 0 Byte file MySQL needs to found.
Very common this happens if you are choosing the .7z version of XAMPP and you are using an extractor which don't extract these 0 Byte files.

best wishes,
Altrea

Altrea,

Thanks for the quick reply. I used the .exe file on sourceforge. How do I work around this? Will i need to re-download?

Quick update.

Re-installed xampp and running on a slightly older version. MySQL now working, but Apache isn't.

I've changed the port from 80 to 1223 but every time I try and "start" Apache on xampp, it trys launching it on port 80?

I edited httpd.conf

EDIT - I'm slowly getting some where. As stated above, I've edited the httpd.conf file to port 1223 and I've also edited the file XAMPP.INI to the said port and placed it into the root directory.

XAMPP shows that it's trying to start of 1223 but is declared "busy" when the start button is pushed.

EDIT 2 - Problem Solved.

# Secure (SSL/TLS) connections
Include conf/extra/httpd-ssl.conf

change to this by adding the comment character:
# Secure (SSL/TLS) connections
# Include conf/extra/httpd-ssl.conf

EDIT 2 - Problem Solved.

# Secure (SSL/TLS) connections
Include conf/extra/httpd-ssl.conf

change to this by adding the comment character:
# Secure (SSL/TLS) connections
# Include conf/extra/httpd-ssl.conf

That really helped! I had a smooth installation running on my local PC which suddenly started refusing to start Apache after I upgraded to the new XAMPP version. Spent quite some time to figure out why Apache wouldn't start.

With the above line disabled, the problem went away!

Thank you!