MySQL Forums
Forum List  »  General

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!

Options: ReplyQuote


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.