search

Home  >  Q&A  >  body text

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

伊谢尔伦伊谢尔伦2824 days ago890

reply all(1)I'll reply

  • PHPz

    PHPz2017-04-17 14:46:40

    You have upgraded from a lower version. You are prompted to run mysql_upgrade to create the missing plugin table.
    If this is not the problem, it is most likely due to the user permissions of your mysql running, or the directory of your mysql. The permissions are incorrect

    reply
    0
  • Cancelreply