登录

安装mysql-5.7.12-linux后,启动报错,求解读

service mysql start
Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/CDCS-213041021.pid).[FAILED]

CDCS-213041021.err:
2016-05-18T01:39:07.993966Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2016-05-18T01:39:07.994110Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-05-18T01:39:07.994456Z 0 [Note] Salting uuid generator variables, current_pid: 12363, server_start_time: 1463535546, bytes_sent: 0,
2016-05-18T01:39:07.994495Z 0 [Note] Generated uuid: '500c6eda-1c99-11e6-af00-fa163ed96cd8', server_start_time: 3479875138537388037, bytes_sent: 37068176
2016-05-18T01:39:07.994503Z 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: 500c6eda-1c99-11e6-af00-fa163ed96cd8.
2016-05-18T01:39:08.015549Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-05-18T01:39:08.015620Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-05-18T01:39:08.015816Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-05-18T01:39:08.015860Z 0 [Note] IPv6 is available.
2016-05-18T01:39:08.015870Z 0 [Note] - '::' resolves to '::';
2016-05-18T01:39:08.015908Z 0 [Note] Server socket created on IP: '::'.
2016-05-18T01:39:08.045746Z 0 [Warning] Failed to open optimizer cost constant tables

2016-05-18T01:39:08.045838Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-05-18T01:39:08.045878Z 0 [ERROR] Aborting

# MySQL
伊谢尔伦 伊谢尔伦 2559 天前 753 次浏览

全部回复(1) 我要回复

  • PHPz

    PHPz2017-04-17 14:46:40

    你是低版本升级上来的吧, 提示你要运行一下mysql_upgrade创建缺失的plugin表呢
    如果不是这个问题, 很有可能是你的mysql运行的用户权限, 或者你的mysql的目录的权限不对

    回复
    0
  • 取消 回复 发送