MySQL service not starting

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

MySQL service not starting

Postby Tjoene » 05. September 2012 09:12

I have a problem with MySQL service.
It suddenly refuses to start. If I run it from the bat file, it starts fine, but as service it refuses to start without any error.

If I manually start the service (net start "mysql") I get an 1067 system error.
I have this problem on my 64-bit Vista computer (running XAMPP 1.8.0 and the 1.8.1 beta) and on my 64-bit Win7 Laptop (XAMPP 1.8.0).
I have tried to do a fresh install, but it didn't help.

This is what XAMPP Debug give me when I install and start MySQL

Code: Select all
10:18:15  [mysql]    Installing service...
10:18:15  [mysql]    Executing "d:\xampp1.8.1\xampp\mysql\bin\mysqld.exe" --install "mysql" --defaults-file="d:\xampp1.8.1\xampp\mysql\bin\my.ini"
10:18:15  [mysql]    Return code: 0
10:18:15  [mysql]    Checking for service (name="mysql"): Service installed
10:18:15  [mysql]    Service Path: D:\xampp1.8.1\xampp\mysql\bin\mysqld.exe --defaults-file=d:\xampp1.8.1\xampp\mysql\bin\my.ini mysql
10:18:15  [mysql]    Successful!
10:18:27  [mysql]    Attempting to start MySQL service...
10:18:27  [mysql]    Executing "net start "mysql""
10:18:34  [mysql]    Return code: 0


Thanks on advance,

Tjoene
User avatar
Tjoene
 
Posts: 19
Joined: 03. January 2012 18:14
Location: Belgium
XAMPP version: 5.6.30
Operating System: Windows 10 (64-bit)

Re: MySQL service not starting

Postby JonB » 05. September 2012 23:50

AFAIK - you are supposed to report Beta problems via the Form provided.

Feedback
Please send us your experiences and your opinion about the beta version you downloaded.

http://www.apachefriends.org/en/xampp-beta.html

The support forums are for software already in release.

Good Luck
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 service not starting

Postby Tjoene » 06. September 2012 07:25

This problem isn't only on the beta, but also on current release.
I have tested the beta to see if the problem persist.
User avatar
Tjoene
 
Posts: 19
Joined: 03. January 2012 18:14
Location: Belgium
XAMPP version: 5.6.30
Operating System: Windows 10 (64-bit)

Re: MySQL service not starting

Postby JonB » 06. September 2012 14:54

Did you follow the instructions about installing the MS C++ 2008 runtimes? (most often cause of MySQL not running)

viewtopic.php?f=16&t=51021

Good Luck
8)


ysfw
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 service not starting

Postby Tjoene » 06. September 2012 16:09

yes I have, on both my computer and laptop.
User avatar
Tjoene
 
Posts: 19
Joined: 03. January 2012 18:14
Location: Belgium
XAMPP version: 5.6.30
Operating System: Windows 10 (64-bit)

Re: MySQL service not starting

Postby JonB » 06. September 2012 16:39

OK - 1067 system error.

Windows Service - process terminated unexpectedly.

There are a couple of places to look for this issue. Its actually an OS error.
The first place to look is in the Windows Event Viewer check the System and Application logs.
Since MySQL crashed, it may or may not have written to the MySQL error log, but that is also worth looking at.

Do you have the same firewall installed on both machines? Do you have any MySQL connectors or tools installed?

Port 3306 may be in use or blocked.

Did you use the Netstat tool???

I just had a thought - did you have auto-start enabled before you made MySQL a service???

Good Luck
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 service not starting

Postby Tjoene » 07. September 2012 07:30

There are 3 errors and 2 warnings in the event viewer (errors from my laptop):

1) (Error) Can't find messagefile 'C:\xampp\mysql\share\errmsg.sys'
2) (Warning) Can't create test file \xampp\mysql\data\PC_JEROEN.lower-test
3) (Warning) Can't create test file \xampp\mysql\data\PC_JEROEN.lower-test
4) (Error) Aborting
Then an other error saying that the mysql services stopped working.

And yes I have the same firewall on both machines (Norman Firewall) and as far as I know, they aren't blocked.
No other MySQL connectors has been installed.
And port 3306 isn't in use (checking with the netstat).
Also, the auto-start is disabled.
User avatar
Tjoene
 
Posts: 19
Joined: 03. January 2012 18:14
Location: Belgium
XAMPP version: 5.6.30
Operating System: Windows 10 (64-bit)

Re: MySQL service not starting

Postby JonB » 07. September 2012 18:07

My guess is you have a Windows language problem, which is keeping the 'real' error message from being displayed.

(Error) Can't find messagefile 'C:\xampp\mysql\share\errmsg.sys'

I don't think that MySQL can find the right language share - What is the 'home language' of the laptop? If it is not "EN" install the English language pack, and give that a whirl. Or copy the English version into 'C:\xampp\mysql\share\errmsg.sys'

Mine:
Image

If the 'Home Language' is EN, then I need another go at what might be wrong...

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 service not starting

Postby Tjoene » 07. September 2012 19:52

I have Windows Home Premium, so I can't change the language. The language used now is Dutch.

But the problem is that Windows can't find 'C:\xampp\mysql\share\errmsg.sys', because XAMPP is located on the D-drive.
If I follow the path, the file is there.
User avatar
Tjoene
 
Posts: 19
Joined: 03. January 2012 18:14
Location: Belgium
XAMPP version: 5.6.30
Operating System: Windows 10 (64-bit)

Re: MySQL service not starting

Postby JonB » 07. September 2012 20:12

OK -

I think we have multiple issues about the MySQL error messages. As there's no way to resolve them other than to create that path on C:, let us pass them by.

A. In what folder/path is XAMPP actually installed?

B. What is in \xampp\mysql\data\mysql_error.log?

Edited - is D a removable drive??? If so, you should make it a persistent device. Windows does not like to start services on removable devices (think about it).

:)
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 service not starting

Postby Tjoene » 08. September 2012 09:28

The path is D:/XAMPP and the D-drive is a partition on the HDD.

And this is the content on the MySQL error log:

Code: Select all
120907  8:29:29 [Note] Plugin 'FEDERATED' is disabled.
120907  8:29:29 InnoDB: The InnoDB memory heap is disabled
120907  8:29:29 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120907  8:29:29 InnoDB: Compressed tables use zlib 1.2.3
120907  8:29:29 InnoDB: Initializing buffer pool, size = 16.0M
120907  8:29:29 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file \xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
120907  8:29:29  InnoDB: Setting file \xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120907  8:29:30  InnoDB: Log file \xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file \xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
120907  8:29:30  InnoDB: Log file \xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file \xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
120907  8:29:32  InnoDB: Waiting for the background threads to start
120907  8:29:33 InnoDB: 1.1.8 started; log sequence number 0
120907  8:29:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120907  8:29:33 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120907  8:29:33 [Note] Server socket created on IP: '0.0.0.0'.
120907  8:29:36 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)


Thanks on advance for the help :)
User avatar
Tjoene
 
Posts: 19
Joined: 03. January 2012 18:14
Location: Belgium
XAMPP version: 5.6.30
Operating System: Windows 10 (64-bit)

Re: MySQL service not starting

Postby hackattack142 » 10. September 2012 23:20

Are the paths in your '/xampp/mysql/bin/my.ini' file correct?
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: MySQL service not starting

Postby Tjoene » 11. September 2012 07:22

hackattack142 wrote:Are the paths in your '/xampp/mysql/bin/my.ini' file correct?


The only path that seems wrong is plugin_dir = "/xampp/mysql/data/lib/plugin/"
It should be plugin_dir = "/xampp/mysql/lib/plugin/"

And socket = "/xampp/mysql/mysql.sock", I can't locate that file

But it isn't fixed if I change the plugin_dir to the correct path.
User avatar
Tjoene
 
Posts: 19
Joined: 03. January 2012 18:14
Location: Belgium
XAMPP version: 5.6.30
Operating System: Windows 10 (64-bit)

Re: MySQL service not starting

Postby JonB » 11. September 2012 17:39

Are both the installs form the same DL?

If so, my guess is you may have a bad DL, did you do a checksum on the file after DL'ing?

Code: Select all
120907  8:29:36 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)


:?:
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 service not starting

Postby Tjoene » 11. September 2012 20:09

JonB wrote:Are both the installs form the same DL?

If so, my guess is you may have a bad DL, did you do a checksum on the file after DL'ing?

Code: Select all
120907  8:29:36 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2)


:?:


If I have taken the host.MYD from an old xampp and it still didn't start.
The DL was fine. No corruption.
Somewhere in the code, that installs the service, says that the path has to be C:\xampp\...
If I move xampp to the C-Drive, it starts just fine.
But it won't start from any other folder.
User avatar
Tjoene
 
Posts: 19
Joined: 03. January 2012 18:14
Location: Belgium
XAMPP version: 5.6.30
Operating System: Windows 10 (64-bit)

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 139 guests