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)