MySQL Database Cannot start
Date: September 22, 2011 07:04AM
I have installed MySQL on Solaris 10 which has been running for several months now. Suddenly as a result of power failure, MySQL can no longer start on issuing mysqld & command. The following error is displayed on issuing the mysqld & command:
110922 13:39:55 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
110922 13:39:55 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110922 13:39:55 InnoDB: The InnoDB memory heap is disabled
110922 13:39:55 InnoDB: Mutexes and rw_locks use Solaris atomic functions
110922 13:39:55 InnoDB: Compressed tables use zlib 1.2.3
110922 13:39:55 InnoDB: Initializing buffer pool, size = 128.0M
110922 13:39:55 InnoDB: Completed initialization of buffer pool
110922 13:39:55 InnoDB: highest supported file format is Barracuda.
110922 13:39:55 InnoDB: Waiting for the background threads to start
110922 13:39:56 InnoDB: 1.1.5 started; log sequence number 5447830845
110922 13:39:56 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Please can anyone help on solution to this problem.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.