首頁  >  問答  >  主體

安装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

伊谢尔伦伊谢尔伦2743 天前832

全部回覆(1)我來回復

  • PHPz

    PHPz2017-04-17 14:46:40

    你是低版本升級上來的吧, 提示你要運行一下mysql_upgrade創建缺失的plugin表呢
    如果不是這個問題, 很有可能是你的mysql運行的用戶權限, 或者你的mysql的目錄的權限不對

    回覆
    0
  • 取消回覆