[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
I have a MYSQL NDB Cluster with the below configuration:
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.252.4.92 (mysql-5.6.28 ndb-7.4.10, Nodegroup: 0)
id=3 @10.252.4.93 (mysql-5.6.28 ndb-7.4.10, Nodegroup: 0, *)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.252.4.89 (mysql-5.6.28 ndb-7.4.10)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 10.252.4.92)
id=5 @10.252.4.93 (mysql-5.6.28 ndb-7.4.10)
But i am unable to start the id:4 (SQL Node) as it is failing with the below error :
2019-08-27 05:49:04 0 [Note] /usr/sbin/mysqld (mysqld 5.6.28-ndb-7.4.10-cluster-gpl) starting as process 7764 ...
2019-08-27 05:49:04 7764 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2019-08-27 05:49:04 7764 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[root@sjgrcabt104 mysql]# cat /etc/my.cnf
[mysqld]
#innodb=OFF
#ignore-builtin-innodb
#skip-innodb
ndbcluster
ndb-connectstring=10.252.4.89 # IP address for server management node
default_storage_engine=ndbcluster # Define default Storage Engine used by MySQL
default-tmp-storage-engine=ndbcluster
#user=root
#password=MyNewPass123
#skip-grant-tables
#datadir=/usr/lib64/mysql
[mysql_cluster]
ndb-connectstring=10.252.4.89 # IP address for server management node
Subject
Views
Written By
Posted
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
8966
August 27, 2019 12:51AM
1916
August 27, 2019 07: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.