Skip navigation links

MySQL Forums :: Cluster :: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.


Advanced Search

[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Posted by: Eve Dj ()
Date: February 20, 2012 01:13PM

Hi all,

I've been trying to setup a database clustering but encountered an error when it comes to get the mysqld up and connected to the management node.

MySQL Cluster version: 7.2.4
Machine OS: Windows XP

I got the following error:

120221 2:17:24 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
120221 2:17:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120221 2:17:24 InnoDB: The InnoDB memory heap is disabled
120221 2:17:24 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120221 2:17:24 InnoDB: Compressed tables use zlib 1.2.3
120221 2:17:25 InnoDB: Initializing buffer pool, size = 128.0M
120221 2:17:25 InnoDB: Completed initialization of buffer pool
120221 2:17: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!
120221 2:17: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...
120221 2:17:25 InnoDB: Waiting for the background threads to start
120221 2:17:26 InnoDB: 1.1.8 started; log sequence number 1595675
120221 2:17:26 [Note] NDB: NodeID is 101, management server 'localhost:1186'
120221 2:17:26 [Note] NDB[0]: NodeID: 101, all storage nodes connected
120221 2:17:26 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
120221 2:17:26 [Note] Starting Cluster Binlog Thread
120221 2:17:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist


Any kind soul out there who can shed a light on my problem?

Thanks!!

Options: ReplyQuote


Subject Views Written By Posted
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 28986 Eve Dj 02/20/2012 01:13PM
Re: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 16986 Bernhard Ocklin 02/20/2012 03:11PM
Re: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 16280 Eve Dj 02/20/2012 12:41PM
Re: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 12382 Bernhard Ocklin 02/20/2012 07:26PM
Re: [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 9800 bingbing liu 03/07/2012 10:15PM


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.