MySQL couldn't start

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

MySQL couldn't start

Postby Wiggy boy » 29. August 2011 17:38

Hey xD, I'm having a damn stupid error saying MySQL cannot start this error is starting to piss me off because some of my earlier PC have said it to... i've looked around over google and in alot of forums NOTHING seems to work -.-'

I've disable'd skype,
Tried reinstalling,
Tried Resarting software and PC
I tried to follow a forum where another guy had the same error, but some files he used i couldn't find for example "xampp-portcheck.exe"

please, help me Dx
Wiggy boy
 
Posts: 11
Joined: 29. August 2011 17:33

Re: MySQL couldn't start

Postby JonB » 29. August 2011 17:58

what version of XAMPP and what version of Windows?

:shock:
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 couldn't start

Postby Wiggy boy » 29. August 2011 21:28

Right now i'm running a Win7 Ultimate x64 and i installed the latest version i'm afraid?(xampp-win32-1.7.4-VC6-installer)
Wiggy boy
 
Posts: 11
Joined: 29. August 2011 17:33

Re: MySQL couldn't start

Postby JonB » 29. August 2011 22:30

1. - If you haven't done it already, download and install the new XAMMP control Panel 3, it has better diagnostics

about:
viewtopic.php?f=16&t=46743

DL
http://arloh.de/xampp/xampp_control3.0.2.zip

extract it and put xampp-contro3.exe in your \xampp folder. Make a shortcut for it, it won't conflict with the existing XAMPP control panel.

2. - What is the error message you are getting??? that might tell us what's wrong...
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 couldn't start

Postby Wiggy boy » 30. August 2011 06:32

When i start Xampp i get an MsgBox saying
Code: Select all
XAMPP Component Status Check Failure [3].
Current directory: c:\xampp
Run this program only from your XAMPP root directory.


and i get this, when i was trying to run MySQL at the end it says "MySQL started [port 3306]" then the MySQL got "started" on the control but 3 sec later, it went off.
Image
Wiggy boy
 
Posts: 11
Joined: 29. August 2011 17:33

Re: MySQL couldn't start

Postby Wiggy boy » 30. August 2011 06:35

I downloaded the new Control Panel
Control Panel Log(as you can see here MySQL quit as soon i start it):
Code: Select all
07:33:11  [main]    Initializing main
07:33:11  [main]    Windows version: 6.1 (build 7600)
07:33:11  [main]    Xampp version: 1.7.4
07:33:11  [main]    Control center version: 3.0.2 [ Compiled: Jul 21th 2011 - build #1 ]
07:33:11  [main]    Running as admin - good!
07:33:11  [main]    Working with basedir: "c:\xampp\"
07:33:11  [main]    Initializing moduls
07:33:11  [apache]    Possible problem detected: Port 80 in use by "httpd.exe"!
07:33:11  [apache]    Possible problem detected: Port 443 in use by "httpd.exe"!
07:33:11  [main]    Starting check-timer
07:33:14  [mysql]    Starting mysql service...
07:33:15  [mysql]    Status change detected: running
07:33:15  [mysql]    Status change detected: stopped
07:33:28  [mysql]    Starting mysql service...
07:33:29  [mysql]    Status change detected: running
07:33:29  [mysql]    Status change detected: stopped


MySQL Log:
Code: Select all
110829 18:15:49 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld: Can't find file: 'plugin' (errno: 2)
110829 18:15:49 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:15:49  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:15:49  InnoDB: Completed initialization of buffer pool
110829 18:15:49  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:15:49  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...
110829 18:15:49  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:15:49 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:15:56 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld: Can't find file: 'plugin' (errno: 2)
110829 18:15:56 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:15:56  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:15:56  InnoDB: Completed initialization of buffer pool
110829 18:15:56  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:15: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...
110829 18:15:56  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:15:56 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:18:05 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld: Can't find file: 'plugin' (errno: 2)
110829 18:18:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:18:05  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:18:05  InnoDB: Completed initialization of buffer pool
110829 18:18:05  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:18:05  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...
110829 18:18:08  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:18:08 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:18:45 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:18:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:18:45  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:18:45  InnoDB: Completed initialization of buffer pool
110829 18:18:45  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:18:45  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...
110829 18:18:46  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:18:46 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:18:48 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:18:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:18:48  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:18:48  InnoDB: Completed initialization of buffer pool
110829 18:18:48  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:18:48  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...
110829 18:18:48  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:18:48 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:18:52 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:18:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:18:52  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:18:52  InnoDB: Completed initialization of buffer pool
110829 18:18:52  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:18: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...
110829 18:18:52  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:18:52 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:18:58 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:18:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:18:59  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:18:59  InnoDB: Completed initialization of buffer pool
110829 18:18:59  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:18:59  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...
110829 18:18:59  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:18:59 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:24:22 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:24:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:24:22  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:24:22  InnoDB: Completed initialization of buffer pool
110829 18:24:22  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:24:22  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...
110829 18:24:22  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:24:22 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:28:38 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld: Can't find file: 'plugin' (errno: 2)
110829 18:28:38 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:28:38  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:28:38  InnoDB: Completed initialization of buffer pool
110829 18:28:38  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:28:38  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...
110829 18:28:38  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:28:38 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:29:00 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:29:00 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:29:00  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:29:00  InnoDB: Completed initialization of buffer pool
110829 18:29:00  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:29:00  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...
110829 18:29:00  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:29:00 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:29:05 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:29:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:29:05  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:29:05  InnoDB: Completed initialization of buffer pool
110829 18:29:05  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:29:05  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...
110829 18:29:05  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:29:05 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:30:03 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:30:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:30:03  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:30:03  InnoDB: Completed initialization of buffer pool
110829 18:30:03  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:30:03  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...
110829 18:30:04  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:30:04 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:30:07 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:30:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:30:07  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:30:07  InnoDB: Completed initialization of buffer pool
110829 18:30:07  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:30:07  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...
110829 18:30:08  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:30:08 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:30:10 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:30:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:30:10  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:30:10  InnoDB: Completed initialization of buffer pool
110829 18:30:10  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:30:10  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...
110829 18:30:10  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:30:10 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:30:11 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:30:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:30:11  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:30:11  InnoDB: Completed initialization of buffer pool
110829 18:30:11  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:30:11  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...
110829 18:30:12  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:30:12 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110829 18:31:04 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110829 18:31:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110829 18:31:04  InnoDB: Initializing buffer pool, size = 16.0M
110829 18:31:04  InnoDB: Completed initialization of buffer pool
110829 18:31:04  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110829 18:31: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...
110829 18:31:05  InnoDB: 1.1.4 started; log sequence number 1840060
110829 18:31:05 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110830  7:24:58 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110830  7:25:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110830  7:25:11  InnoDB: Initializing buffer pool, size = 16.0M
110830  7:25:11  InnoDB: Completed initialization of buffer pool
110830  7:25:11  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110830  7:25:11  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...
110830  7:25:12  InnoDB: 1.1.4 started; log sequence number 1840060
110830  7:25:12 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110830  7:29:13 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110830  7:29:13 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110830  7:29:13  InnoDB: Initializing buffer pool, size = 16.0M
110830  7:29:13  InnoDB: Completed initialization of buffer pool
110830  7:29:13  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110830  7:29:13  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...
110830  7:29:19  InnoDB: 1.1.4 started; log sequence number 1840060
110830  7:29:19 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110830  7:29:25 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110830  7:29:25 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110830  7:29:25  InnoDB: Initializing buffer pool, size = 16.0M
110830  7:29:25  InnoDB: Completed initialization of buffer pool
110830  7:29:25  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110830  7:29:25  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...
110830  7:29:26  InnoDB: 1.1.4 started; log sequence number 1840060
110830  7:29:26 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110830  7:29:28 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110830  7:29:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110830  7:29:28  InnoDB: Initializing buffer pool, size = 16.0M
110830  7:29:28  InnoDB: Completed initialization of buffer pool
110830  7:29:28  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110830  7:29:28  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...
110830  7:29:29 [Note] Plugin 'FEDERATED' is disabled.
mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110830  7:29:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110830  7:29:29  InnoDB: Initializing buffer pool, size = 16.0M
110830  7:29:29  InnoDB: Completed initialization of buffer pool
110830  7:29:29  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this err10830o 7.
29:29  InnoDB: 1.1.4 started; log sequence number 1840060
110830  7:29:29 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110830  7:29:39  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110830  7:29: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...
110830  7:29:40  InnoDB: 1.1.4 started; log sequence number 1840060
110830  7:29:40 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110830  7:33:14 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110830  7:33:14 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110830  7:33:14  InnoDB: Initializing buffer pool, size = 16.0M
110830  7:33:14  InnoDB: Completed initialization of buffer pool
110830  7:33:14  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110830  7:33: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...
110830  7:33:15  InnoDB: 1.1.4 started; log sequence number 1840060
110830  7:33:15 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
110830  7:33:28 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Can't find file: 'plugin' (errno: 2)
110830  7:33:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110830  7:33:28  InnoDB: Initializing buffer pool, size = 16.0M
110830  7:33:28  InnoDB: Completed initialization of buffer pool
110830  7:33:28  InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110830  7:33:28  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...
110830  7:33:29  InnoDB: 1.1.4 started; log sequence number 1840060
110830  7:33:29 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
Wiggy boy
 
Posts: 11
Joined: 29. August 2011 17:33

Re: MySQL couldn't start

Postby JonB » 30. August 2011 13:48

Did you try 'copying' MySQL data files from a different machine, or a prior installation on this machine? :?:
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 couldn't start

Postby Wiggy boy » 30. August 2011 14:58

what do u mean? all my PC who had a working mysql xampp has broken, just like this... mysql worked before...
Wiggy boy
 
Posts: 11
Joined: 29. August 2011 17:33

Re: MySQL couldn't start

Postby JonB » 30. August 2011 15:01

this means your innoDB data ir corrupt

110830 7:33:28 InnoDB: Initializing buffer pool, size = 16.0M
110830 7:33:28 InnoDB: Completed initialization of buffer pool
110830 7:33:28 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110830 7:33:28 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...
110830 7:33:29 InnoDB: 1.1.4 started; log sequence number 1840060
110830 7:33:29 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)

its a MySQL corruption problem, not a XAMPP issue

do you have a backup of your MySQL data?
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 couldn't start

Postby Wiggy boy » 30. August 2011 15:46

guess not, where can i find that?
Wiggy boy
 
Posts: 11
Joined: 29. August 2011 17:33

Re: MySQL couldn't start

Postby JonB » 30. August 2011 17:13

You haven't given much details BUT -

1. Do you have 'real data' in your XAMPP MySQL databases??
(if so you should google perhaps 'innoDB recovery')

2. If this has happened on more than one machine, its pretty weird. Normally -my offhand guess would be disk fault or crash during updating, but for it to happen on more than one machine is way out there. How many machine do you have XAMPP on???

3. You should learn to backup MySQL properly - IE Use phpMyAdmin (import/export), MySQL Workbench or mysqldump.exe

Good Luck
8)


tcf
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 couldn't start

Postby Wiggy boy » 30. August 2011 17:44

i've happend to 3 and this PC

Win7 Ultimate x64
Win7 Professional x32
WinXP Professional x32
WinXP ? x32

I don't need to restore anything i haven't used MySQL yet on this PC but i know it've worked(I'm gna make a database and then i've got a file to import), so i installed MySQL and some MySQL workbence or something, basically i google'd mysql download, so i installed it but XAMPP doesn't get access to it, it can either start or stop MySQL,

does this have anything to do with the password?

and when i try to go to "http://localhost/phpmyadmin/" it says
Code: Select all
MySQL access denied

MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured
Wiggy boy
 
Posts: 11
Joined: 29. August 2011 17:33

Re: MySQL couldn't start

Postby Wiggy boy » 30. August 2011 19:10

Oh well, i removed MySQL and reinstalled it, still didn't work, i entered Windows Services and notice'd i had
Code: Select all
mysql
MySQL55

and removed and reinstalled MySQL and notice'd at the "Configuration" i'm naming this serivice to "MySQL55" so i told it to name it "mysql" and now XAMPP can start and stop MySQL but i still cannot access it with "" it just says
Code: Select all
Error

MySQL said: Documentation
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.


I'm afraid this means it doesn't have the right password, and that wouldn't be odd since in the MySQL installtion it require'd a password set, but where can i tell XAMPP or which config file should i edit to tell it the password? i checked the my.ini but i couldn't find anything,
Wiggy boy
 
Posts: 11
Joined: 29. August 2011 17:33

Re: MySQL couldn't start

Postby JonB » 30. August 2011 20:13

You can only have ONE instance of MySQL working on the same local socket (port), and the datastores must be separate on any given machine(server). (also the service names must be unique, as you noted)

Running mutliple MySQL servers is out-of-scope for XAMPP and its support folksies

Typically the ports used are 3306 (default), then 3307

The default MySQL installation of MySQL uses port 3306, has 'root' as primary user, and does not have a password set.

Normally the 'right thing to do' is to make one of the services so it has a 'manual' start (the one you don't want to use with XAMPP).

Why do you have XAMPP/MySQL installed on all these machines? You normally only need one instance of a webserver and database server (unless you are doing master/slave repications) That too is out of scope for here...

This actually is the answer(s) to your question, although it may not appear so. :shock:

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 couldn't start

Postby Wiggy boy » 30. August 2011 21:47

Well, when it didn't work on 1 pc i tried another and neither it did work there that's why i got it on all, but also cuz i love at my dad/mom which gives me 2 PC to host on

And Nope didn't understand anything of that...
Wiggy boy
 
Posts: 11
Joined: 29. August 2011 17:33

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 23 guests