Mysql service will not start
Posted: 07. November 2015 20:41Started having a problem where Mysql will not start. Uninstalled and reinstalled and it then started ok. Copied my databases over to c:\xampp\mysql\data, stopped mysql and then tried to restart it but after showing the pid number it then disappeared and advised mysql not started. Following are the entries in the log file:
151107 14:31:57 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
151107 14:31:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
151107 14:31:57 InnoDB: The InnoDB memory heap is disabled
151107 14:31:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
151107 14:31:57 InnoDB: Compressed tables use zlib 1.2.3
151107 14:31:57 InnoDB: Initializing buffer pool, size = 16.0M
151107 14:31:57 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
151107 14:31:57 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
151107 14:31:57 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
151107 14:31:57 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\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
151107 14:31:58 InnoDB: Waiting for the background threads to start
151107 14:31:59 InnoDB: 1.1.8 started; log sequence number 0
151107 14:31:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
151107 14:31:57 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
151107 14:31:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
151107 14:31:57 InnoDB: The InnoDB memory heap is disabled
151107 14:31:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
151107 14:31:57 InnoDB: Compressed tables use zlib 1.2.3
151107 14:31:57 InnoDB: Initializing buffer pool, size = 16.0M
151107 14:31:57 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
151107 14:31:57 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
151107 14:31:57 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
151107 14:31:57 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\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
151107 14:31:58 InnoDB: Waiting for the background threads to start
151107 14:31:59 InnoDB: 1.1.8 started; log sequence number 0
151107 14:31:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist