問題描述

service mysql startStarting 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 exist2016-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: 370681762016-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 key2016-05-18T01:39:08.015816Z 0 [Note] Server hostname (bind-address): ’*’; port: 33062016-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 exist2016-05-18T01:39:08.045878Z 0 [ERROR] Aborting

問題解答

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