MySql Won't Start Up [SOLVED]

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

MySql Won't Start Up [SOLVED]

Postby Henness0666 » 26. January 2012 00:03

I've installed Xampp 1.7.7, Apache runs just fine, but as soon as I click the "Start" button for MySql, it says that it's starting, but then a few seconds latter it goes off again...

This is what the console says

Code: Select all
XAMPP Control Panel Version 2.5 (16. March, 2011)
Windows 6.1 Build 7601 Platform 2 Service Pack 1
Current Directory: c:\xampp
Install(er) Directory: c:\xampp
WARN:This program must be run from your XAMPP root directory.
INFO: Perhaps this program running on a 64 bit plattform please ignore the message above.


At this point I clicked on the "Start" button for MySql

Code: Select all
XAMPP Control Panel Version 2.5 (16. March, 2011)
Windows 6.1 Build 7601 Platform 2 Service Pack 1
Current Directory: c:\xampp
Install(er) Directory: c:\xampp
WARN:This program must be run from your XAMPP root directory.
INFO: Perhaps this program running on a 64 bit plattform please ignore the message above.
Busy...
MySql started [Port 3306]


At this point the "Stop" button goes back to "Start" and shows MySql is not on but does not say it in the console.

Any advice is helpful. Thanks!
Henness0666
 
Posts: 3
Joined: 25. January 2012 23:40
Operating System: Window 7 64-bit

Re: MySql Won't Start Up

Postby Sharley » 26. January 2012 00:11

You could use the version 3 control panel found in the xampp installation folder:
xampp-control-3-beta.exe
Right click on it to select to run as an admin for best results.
Stop all XAMPP components and remove the ticks in the Svc check boxes then click on Exit in the older 2.5 version before starting this version 3 control panel.

The latest Control Panel Version3 download is linked in my signature.
Simply extract all the files from the archive to the xampp installation folder and overwrite when asked.
Then right click the exe file to run as administrator and to create a shortcut to the desktop, for example, for easier access.

Make sure that you have exited all other control panel versions before starting this latest version.

This new version has a better log window and is easier to copy and paste in here.

Also in the C:\xampp\mysql\data folder you will find the mysql_error.log file which may give clues and this log file among others is accessible from the latest XCPv3 with the click of a button.

Good luck. :)
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: MySql Won't Start Up

Postby Henness0666 » 26. January 2012 00:55

Sharley wrote:You could use the version 3 control panel found in the xampp installation folder:
xampp-control-3-beta.exe
Right click on it to select to run as an admin for best results.
Stop all XAMPP components and remove the ticks in the Svc check boxes then click on Exit in the older 2.5 version before starting this version 3 control panel.

The latest Control Panel Version3 download is linked in my signature.
Simply extract all the files from the archive to the xampp installation folder and overwrite when asked.
Then right click the exe file to run as administrator and to create a shortcut to the desktop, for example, for easier access.

Make sure that you have exited all other control panel versions before starting this latest version.

This new version has a better log window and is easier to copy and paste in here.

Also in the C:\xampp\mysql\data folder you will find the mysql_error.log file which may give clues and this log file among others is accessible from the latest XCPv3 with the click of a button.

Good luck. :)

I am now using The beta Control panel v3.0.11, But MySQL still will not start up.

This is what the console says

Code: Select all
3:47:47 PM  [main]    Initializing Control Panel
3:47:47 PM  [main]    Windows Version: Windows 7 Home Premium SP1 64-bit
3:47:47 PM  [main]    XAMPP Version: 1.7.7
3:47:47 PM  [main]    Control Panel Version: 3.0.11 [ Compiled: December 7th 2011 ]
3:47:47 PM  [main]    Running with Administrator rights - good!
3:47:47 PM  [main]    XAMPP Installation Directory: "c:\xampp\"
3:47:47 PM  [main]    Initializing Modules
3:47:47 PM  [apache]    XAMPP Apache Service is already running on port 80
3:47:47 PM  [apache]    XAMPP Apache Service is already running on port 443
3:47:47 PM  [main]    Starting Check-Timer
3:47:47 PM  [main]    Control Panel Ready

But after I click on "start" The console looks like this and stays this way.

Code: Select all
3:47:47 PM  [main]    Initializing Control Panel
3:47:47 PM  [main]    Windows Version: Windows 7 Home Premium SP1 64-bit
3:47:47 PM  [main]    XAMPP Version: 1.7.7
3:47:47 PM  [main]    Control Panel Version: 3.0.11 [ Compiled: December 7th 2011 ]
3:47:47 PM  [main]    Running with Administrator rights - good!
3:47:47 PM  [main]    XAMPP Installation Directory: "c:\xampp\"
3:47:47 PM  [main]    Initializing Modules
3:47:47 PM  [apache]    XAMPP Apache Service is already running on port 80
3:47:47 PM  [apache]    XAMPP Apache Service is already running on port 443
3:47:47 PM  [main]    Starting Check-Timer
3:47:47 PM  [main]    Control Panel Ready
3:48:36 PM  [mysql]    Starting mysql service...

I am still have the same problem can any one help? Here is the error File

Code: Select all
120125 15:48:36 [Note] Plugin 'FEDERATED' is disabled.
120125 15:48:36 InnoDB: The InnoDB memory heap is disabled
120125 15:48:36 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120125 15:48:36 InnoDB: Compressed tables use zlib 1.2.3
120125 15:48:36 InnoDB: Initializing buffer pool, size = 16.0M
120125 15:48:36 InnoDB: Completed initialization of buffer pool
120125 15:48:36 InnoDB: highest supported file format is Barracuda.
120125 15:48:36  InnoDB: Waiting for the background threads to start
120125 15:48:37 InnoDB: 1.1.8 started; log sequence number 1595675
120125 15:48:37 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
Henness0666
 
Posts: 3
Joined: 25. January 2012 23:40
Operating System: Window 7 64-bit

Re: MySql Won't Start Up

Postby Sharley » 26. January 2012 01:09

Code: Select all
120125 15:48:37 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
Here is the problem.

In the C:\xampp\mysql\data\mysql folder you should see a host.MYD file and it should have a zero size.

If this file is missing then it means that either you have run a clean-up utility that has deleted temp, tmp and zero length files (the xampp folder should be excluded) or they were not extracted when you installed XAMPP.

These files are needed and there are hundreds of zero length files in XAMPP.

You can either uninstall then install again using a different method as outlined in this post:
viewtopic.php?p=179699#p179699
or you can download the zip version and extract all the missing files to their correct locations (this method may be somewhat time consuming).
You could start by extracting from the zip archive, by comparing the data\mysql folder in the zip archive with the same folder in your installation, those zero length files that are missing.

Once you have these zero length files like the host.MYD file replaced then you may be able to start MySQL.

Good luck. :)
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: MySql Won't Start Up

Postby Henness0666 » 26. January 2012 01:45

Sharley wrote:
Code: Select all
120125 15:48:37 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
Here is the problem.

In the C:\xampp\mysql\data\mysql folder you should see a host.MYD file and it should have a zero size.

If this file is missing then it means that either you have run a clean-up utility that has deleted temp, tmp and zero length files (the xampp folder should be excluded) or they were not extracted when you installed XAMPP.

These files are needed and there are hundreds of zero length files in XAMPP.

You can either uninstall then install again using a different method as outlined in this post:
http://community.apachefriends.org/f/viewtopic.php?p=179699#p179699
or you can download the zip version and extract all the missing files to their correct locations (this method may be somewhat time consuming).
You could start by extracting from the zip archive, by comparing the data\mysql folder in the zip archive with the same folder in your installation, those zero length files that are missing.

Once you have these zero length files like the host.MYD file replaced then you may be able to start MySQL.

Good luck. :)

Thank you! I reinstalled and it works perfectly! Its much appreciated.
Henness0666
 
Posts: 3
Joined: 25. January 2012 23:40
Operating System: Window 7 64-bit

Re: MySql Won't Start Up

Postby Sharley » 26. January 2012 01:47

You're welcome and thanks for the feedback. 8)

I will close this topic and mark it solved.

Please feel free to start a new topic if you have any more issues with XAMPP for Windows.

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 45 guests