New to XAMMP -- Unable to run MySQL 1.7.4 [SOLVED}

[woodcycl]

Hello,

I'm totally new to Apache and XAMMP. I'd like to create a working local environment to create Wordpress sites before doing so on my host account. I found out about XAMPP and have attepted a installation, but I am unable to get mySQL to run. I chose Apache to run as a service, but nothing else. I'm running WinXP SP3 and have opened up ports on hardware and software firewalls. Attached is my localhost file as well as the XAMPP Control Panel Application screenshot.

Don't see file attachment options ... here is the PDF of the two screenshots mentioned above: http://woodcycl.com/images/xammp%20screenshots%201.pdf

By the way, I'm not a Linux guy unfortunately.

Any help is appreciated.

Thank much,
Brian

[JonB]

A: do not use pdf files for inline attachments, use a png or jpg, and then use an image tag.

It would be useful to know the version of XAMPP as well -

BUT - that said - and presuming its XAMPP 1.7.7

B. - try looking in \xampp\mysql\data\mysql_error.log

C. also use the Control Panel 3 (beta) - its a beta in name only - better diagnostics.
xampp-control-3-beta.exe

Good luck

[woodcycl]

Thanks JonB.

Not sure why, but the xampp-control-3-beta.exe you mentioned isn't installed in my xampp root -- onlyi the xampp-control.exe.

Here is the xampp readme for version numbers ... just installed last Friday:

###### ApacheFriends XAMPP (Basispaket) version 1.7.4 ######

+ Apache 2.2.17
+ MySQL 5.5.8 (Community Server)
+ PHP 5.3.5 (VC6 X86 32bit) + PEAR
+ XAMPP Control Version 2.5 from www.nat32.com
+ XAMPP Security
+ SQLite 2.8.15
+ OpenSSL 0.9.8o
+ phpMyAdmin 3.3.9
+ ADOdb 5.11
+ Mercury Mail Transport System v4.62
+ FileZilla FTP Server 0.9.37
+ Webalizer 2.01-10
+ Zend Optimizer 3.3.0
+ Perl 5.10.1
+ Mod_perl 2.0.4
+ Tomcat 7.0.3

Here are a couple images of the mysql_error.log files:




Edited to add screenshot of xampp control panel:


Any thoughts?

Many thanks!
Brian

[hackattack142]

Do you have any other MySQL servers running? Did you install any other server stacks (like WAMP) or install MySQL manually at any point? Is there a MySQL service running (Start > Run > services.msc) named 'mysql'? Your error log suggests that something is using port 3306. MySQL will not start if something is using that port.

You might also consider using this control panel: viewtopic.php?f=16&t=46743
It is newer, provides more information, and has a better port information utility.

[woodcycl]

Thanks hackattack142.

I noticed 3306 was wide open on my hardware firewall ... woah!! I closed it! Then checked services and there weren't any. I then installed CP v3 and was able to start the MySQL ... very strange. Does this looks like it is working as needed?



Thanks,
Brian

[hackattack142]

It appears to be. It will show those possible problems if you had Apache running before starting the Control Panel. You can always check to make sure you can go to the xampp site, use phpMyAdmin, and do everything you need to do. The 1.7.4 release had some problems. If you continue to have problems, you could also consider an upgrade to the 1.7.7 version.

[woodcycl]

Thanks - will do!