MySQL won't run.

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

MySQL won't run.

Postby Akula04 » 21. July 2009 09:36

Hi Guys,

First, I did a forum search, couldn't find an answer.

I can't run MySQL, Apache works fine. Control Panel output:

Code: Select all
Busy...
MySQL started [Port 3306]


However, it starts and then dies out. I thought it might be an issue with protection, since I have passwords. Logging into xampp was possible, trying to login into PHPMyAdmin was not possible.

I ran mysql_uninstallservice.bat - even though it's a not a service, but who knows - , output:

Code: Select all
now stopping MySQL when it runs
Systeemfout 1060.

De opgegeven service is geen geïnstalleerde service.

Uninstalling MySql-Service
Service "mysql" is not deinstalled.
Druk op een toets om door te gaan. . .


I then ran mysql_installservice.bat , output:

Code: Select all
Installing MySQL as an Service
Service "mysql" is installed.
Try to start the MySQL deamon as service ...
Systeemfout 5.

Toegang geweigerd.

Druk op een toets om door te gaan. . .


However, I don't want it to run as a service. Lastly, I ran rootreset.bat , output:

Code: Select all
090721 10:35:33 [Note] Plugin 'InnoDB' disabled by command line option
ERROR: 1017  Can't find file: 'user' (errno: 2)
090721 10:35:33 [ERROR] Aborting

090721 10:35:33 [Warning] Forcing shutdown of 2 plugins
090721 10:35:33 [Note] bin\mysqld.exe: Shutdown complete


Passwoerter fuer Benutzer "root" und "pma" wurden nicht geloescht!
Passwords for user "root" and "pma" were not deleted!

Druk op een toets om door te gaan. . .


No effect though.

Found the error log

Code: Select all
090721 10:16:52  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:16:53  InnoDB: Started; log sequence number 0 46409
090721 10:16:53 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:17:34  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:17:35  InnoDB: Started; log sequence number 0 46409
090721 10:17:35 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:17:51  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:17:51  InnoDB: Started; log sequence number 0 46409
090721 10:17:51 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:17:55  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:17:56  InnoDB: Started; log sequence number 0 46409
090721 10:17:56 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:17:58  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:17:58  InnoDB: Started; log sequence number 0 46409
090721 10:17:58 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:19:14  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:19:14  InnoDB: Started; log sequence number 0 46409
090721 10:19:14 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:19:19  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:19:19  InnoDB: Started; log sequence number 0 46409
090721 10:19:20 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:20:14  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:20:14  InnoDB: Started; log sequence number 0 46409
090721 10:20:14 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:21:04  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:21:04  InnoDB: Started; log sequence number 0 46409
090721 10:21:04 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:24:54  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:24:54  InnoDB: Started; log sequence number 0 46409
090721 10:24:54 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:24:56  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:24:57  InnoDB: Started; log sequence number 0 46409
090721 10:24:57 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:25:09  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:25:09  InnoDB: Started; log sequence number 0 46409
090721 10:25:09 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:34:39  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:34:40  InnoDB: Started; log sequence number 0 46409
090721 10:34:40 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:34:41  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:34:42  InnoDB: Started; log sequence number 0 46409
090721 10:34:42 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:34:42  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:34:42  InnoDB: Started; log sequence number 0 46409
090721 10:34:42 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090721 10:34:50  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090721 10:34:50  InnoDB: Started; log sequence number 0 46409
090721 10:34:50 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
Akula04
 
Posts: 3
Joined: 21. July 2009 09:26

Re: MySQL won't run.

Postby Wiedmann » 21. July 2009 09:54

Found the error log

That's a new XAMPP installation?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MySQL won't run.

Postby Akula04 » 21. July 2009 10:21

Wiedmann wrote:
Found the error log

That's a new XAMPP installation?


08. April 2009 1.7.1 Beta5
Akula04
 
Posts: 3
Joined: 21. July 2009 09:26

Re: MySQL won't run.

Postby Wiedmann » 21. July 2009 10:34

Let me ask in other words:
Are you working with this installation, or can you deinstall and reinstall the whole thing?

(btw: why are you using 1.7.1-beta5, and not 1.7.1?)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MySQL won't run.

Postby Akula04 » 21. July 2009 10:43

Wait I'm an idiot. Here's what I dl'd:

xampp-win32-1.7.1-installer.exe

I could reinstall, you think that's the only way?

I recently formatted my PC, still downloading win updates for vista (yes I am on vista, XP would cost me 200 euros), might be the system?
Akula04
 
Posts: 3
Joined: 21. July 2009 09:26

Re: MySQL won't run.

Postby Wiedmann » 21. July 2009 10:47

I could reinstall, you think that's the only way?

Maybe extracting only the databases (\xampp\mysql\data\*) from the XAMPP zip can also help.

(Well, I've never seen this error in a fresh XAMPP installation)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 48 guests

cron