Table 'mysql.plugin' doesn't exist
Posted by:
Xiaoyun Li
Date: April 13, 2016 03:11AM
Hello,
Apologies if this post has been misplaced. But this problem really bothers me.
I installed MySQL 5.7.11 on Oracle Linux 6.5. Put my own my.cnf file under a customized directory named /u01/app/oracle/mysql/mycnf/my.cnf
Then I ran the following command to configure MySQL and start mysql:
/usr/sbin/mysqld --datadir=/u01/app/oracle/mysql/data --user=oracle --initialize-insecure --defaults-file=/u01/app/oracle/mysql/mycnf/my.cnf
/usr/bin/mysqld_safe --defaults-file=/u01/app/oracle/mysql/mycnf/my.cnf --user=oracle --datadir=/u01/app/oracle/mysql/data --pid-file=/u01/app/oracle/mysql/data/mysqld.pid
But I failed to start mysqld this way with some error like the following:
2016-04-13T08:12:44.413460Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 0
2016-04-13T08:12:44.414320Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2016-04-13T08:12:44.414535Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-04-13T08:12:44.414983Z 0 [Note] Salting uuid generator variables, current_pid: 10141, server_start_time: 1460535140, bytes_sent: 0,
2016-04-13T08:12:44.418881Z 0 [Note] Generated uuid: '8013906a-014f-11e6-b5e9-0021f6000002', server_start_time: 2854437740283307777, bytes_sent: 35442768
2016-04-13T08:12:44.418899Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8013906a-014f-11e6-b5e9-0021f6000002.
2016-04-13T08:12:44.484994Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-04-13T08:12:45.225161Z 0 [Note] Auto generated SSL certificates are placed in data directory.
2016-04-13T08:12:45.240477Z 0 [Warning] CA certificate ca.pem is self signed.
2016-04-13T08:12:45.697990Z 0 [Note] Auto generated RSA key files are placed in data directory.
2016-04-13T08:12:45.698193Z 0 [Note] Server hostname (bind-address): '*'; port: 49500
2016-04-13T08:12:45.706306Z 0 [Note] IPv6 is available.
2016-04-13T08:12:45.706328Z 0 [Note] - '::' resolves to '::';
2016-04-13T08:12:45.706379Z 0 [Note] Server socket created on IP: '::'.
2016-04-13T08:12:45.856805Z 0 [Warning] Failed to open optimizer cost constant tables
2016-04-13T08:12:45.857008Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-04-13T08:12:45.857114Z 0 [ERROR] Aborting
Does anyone know what the problem is in my case and how to solve this problem? Any suggestions would be great appreciated!
Thanks in advance!
Subject
Written By
Posted
Table 'mysql.plugin' doesn't exist
April 13, 2016 03:11AM
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.