安装mysql-5.7.12-linux后,启动报错,求解读
伊谢尔伦
伊谢尔伦 2017-04-17 14:44:40
0
1
873

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

伊谢尔伦
伊谢尔伦

小伙看你根骨奇佳,潜力无限,来学PHP伐。

Antworte allen(1)
PHPzhong

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

Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage