MySQL is not running! [Solved]

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

MySQL is not running! [Solved]

Postby bluelantern1163 » 19. June 2012 06:54

According to the XAMPP Security Page, it says:
A MySQL server is not running or is blocked by a firewall! (version 5.5)

It says the same thing for FTP and POP3 (what exactly are these?)

When MySQL is started, the error log displays the following:

120618 22:50:12 [Note] Plugin 'FEDERATED' is disabled.
120618 22:50:12 InnoDB: The InnoDB memory heap is disabled
120618 22:50:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120618 22:50:12 InnoDB: Compressed tables use zlib 1.2.3
120618 22:50:12 InnoDB: Initializing buffer pool, size = 16.0M
120618 22:50:12 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file C:\xampp\mysql\data\ibdata1 is of a different size
InnoDB: 256 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
120618 22:50:12 InnoDB: Could not open or create data files.
120618 22:50:12 InnoDB: If you tried to add new data files, and it failed here,
120618 22:50:12 InnoDB: you should now edit innodb_data_file_path in my.cnf back
120618 22:50:12 InnoDB: to what it was, and remove the new ibdata files InnoDB created
120618 22:50:12 InnoDB: in this failed attempt. InnoDB only wrote those files full of
120618 22:50:12 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
120618 22:50:12 InnoDB: remove old data files which contain your precious data!
120618 22:50:12 [ERROR] Plugin 'InnoDB' init function returned error.
120618 22:50:12 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120618 22:50:12 [ERROR] Unknown/unsupported storage engine: InnoDB
120618 22:50:12 [ERROR] Aborting

120618 22:50:12 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

What should I do here?
bluelantern1163
 
Posts: 31
Joined: 17. June 2012 02:18
Operating System: Windows 7

Re: MySQL is not running!

Postby JonB » 19. June 2012 19:26

I'm at a bit of a loss:
According to the XAMPP Security Page, it says:
A MySQL server is not running or is blocked by a firewall! (version 5.5)

It says the same thing for FTP and POP3 (what exactly are these?)


IF XAMPP doesn't think a MySQL server is running, how do you explain this:

When MySQL is started, the error log displays the following:


I suspect you have a corrupt installation

Is it a XAMPP fresh install?

Did you use the Installer, ZIP or the 7Z download?

If its not a fresh installation did you install other MySQL based scripts, or modify my.ini/my.cnf?

Have you had other installations of XAMPP.WAMP or MySQL previously?

What does it tell you when you run the XAMPP Control Panel???
Thanks
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: MySQL is not running!

Postby bluelantern1163 » 19. June 2012 20:37

I worded this improperly; when I try to run MySQL, nothing happens, and the "stop" button immediately says "start" again. When I look at the MySQL error log afterwards, it displays the above message.

MySQL was installed with XAMPP

I used the installer to install XAMPP

I did not modify any ini files or anything related to MySQL

I have installed MySQL and XAMPP in the past, but uninstalled it before I installed this XAMPP

When I try to run MySQL on XAMPP, it says "running MySQL (port 3306)" and nothing happens, MySQL never starts up, and the stop button immediately becomes a start button again.
bluelantern1163
 
Posts: 31
Joined: 17. June 2012 02:18
Operating System: Windows 7

Re: MySQL is not running!

Postby JonB » 20. June 2012 15:34

OK

I suggest the following:

(on the presumption you do not have anything to save in the installation)

If you made any of XAMPP's features into services, stop the service and remove them by using the Control Panel - you may need to restart the machine

Remove XAMPP's installer using Windows Control Panel, Programs

Now delete your \xampp folder

Download either the .zip or .7z compressed versions of XAMPP. You might want to validate the checksums.

Extract the files (you will get a \xampp folder with all the files in it)

Copy that folder to the root of one of your drives. C:\ is just fine for that if you want.

run the setup_xampp.bat file in the root of \xampp.

Launch the xampp-control-3-beta.exe file, and see if Apache and MySQL will start.

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: MySQL is not running!

Postby bluelantern1163 » 21. June 2012 07:44

Ok, so it finally appears to be working, thanks JonB. I just wanted to ask a few questions about XAMPP before I draw this to a close:

1) How do I make a shortcut to start up XAMPP (like a desktop shortcut?)

2) What exactly is FileZilla? Do I need it for something like a web server?

3) I noticed under security the following:

a)These XAMPP pages are accessible by network for everyone
b)The MySQL admin user root has NO password
c) PhpMyAdmin is free accessible by network
d) PHP is NOT running in "safe mode"

How do I resolve these issues, to make my server more secure?
bluelantern1163
 
Posts: 31
Joined: 17. June 2012 02:18
Operating System: Windows 7

Re: MySQL is not running!

Postby JonB » 22. June 2012 01:47

1 - A. You can make a shortcut to the Control Panel on your desktop.

A-2 - You can make Apache and MySQL into services - they will start when the machine starts that way.

2. FileZilla is an FTP server so you can upload files to the server from a different machine or location.

3. Ummmm - I would have to say, at least at this moment, you are probably not ready to make your XAMPP install available to others. Those are 'real issues' if you were to expose your XAMPP server to the Internet. BUT, if you just want to use it to learn how things work and don't setup your router to expose the XAMPP machine, they are of little concern.

4. I kinda fudged that last answer as I don't know what you plan to do. IF you plan to make XAMPP into a webserver that is open to the public, I caution you against that idea. I have a site that discusses some of the XAMPP security issues, its in my 'signature line'.

If you could explain what you are trying to accomplish with XAMPP, I can give you a much better response.

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: MySQL is not running! [Solved]

Postby bluelantern1163 » 22. June 2012 07:26

Essentially, I am trying to create a site similar to this one, a data-driven site with login, signup, and profile capabilities, along with forums as well. It will be accessible to the public, and email will be sent out and received. In a nutshell, that is what I am looking for.
bluelantern1163
 
Posts: 31
Joined: 17. June 2012 02:18
Operating System: Windows 7

Re: MySQL is not running! [Solved]

Postby JonB » 23. June 2012 22:54

Then you should by all means read my page on XAMPP security. Bear in mind that XAMPP was not built 'hardened', but was created as a development tool. Hence, you are on your own when it comes to security (as I was). I have covered most things other than PHP & MySQL hardening (complete topics of their own).

http://bravo.newnetenterprises.com/word ... -security/

I strongly caution you against setting up a public mailserver, unless you feel up to an additional major security challenge. But you are going to do what you will. Most ISP's have mailservers (SMTP) you can use. You don't need a mailsever to do 'sendmail' with PHP or Perl based scripts. XAMPP has a 'fake sendmail' for Windows included as a stand-in for the Linux/Unix server sendmail utility. The reason for this caution on mailservers is 'open mail relays'.

Lastly, 'PHP safe mode' is deprecated so don't concern yourself with that.

I have to say that if you didn't know what an FTP server was - there's a BIG learning curve ahead.

Good Luck with your project
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


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 56 guests