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

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

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

Postby woodcycl » 10. October 2011 19:17

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
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: New to XAMMP -- Unable to run MySQL

Postby JonB » 10. October 2011 20:11

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
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: New to XAMMP -- Unable to run MySQL

Postby woodcycl » 10. October 2011 20:28

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:

Image
Image

Edited to add screenshot of xampp control panel:
Image

Any thoughts?

Many thanks!
Brian
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: New to XAMMP -- Unable to run MySQL

Postby hackattack142 » 10. October 2011 20:34

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.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: New to XAMMP -- Unable to run MySQL

Postby woodcycl » 10. October 2011 20:48

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?

Image

Thanks,
Brian
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3

Re: New to XAMMP -- Unable to run MySQL

Postby hackattack142 » 10. October 2011 20:54

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.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: New to XAMMP -- Unable to run MySQL

Postby woodcycl » 10. October 2011 21:08

Thanks - will do!
woodcycl
 
Posts: 17
Joined: 10. October 2011 19:08
Location: Southern Indiana
Operating System: WinXP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 47 guests