MySQL Forums
Forum List  »  NDB clusters

[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.
84218
February 20, 2012 01:13PM


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.