请稍等 ...
×

采纳答案成功!

向帮助你的同学说点啥吧!感谢那些助人为乐的人

初始化MYSQL报错

启动mysql的时候 :/etc/init.d/mysqld start
报了一个error的错误:
Starting MySQL… ERROR! The server quit without updating PID file (/usr/local/mysql/data/192.168.80.129.pid).
这是错误日志
2019-08-29T10:17:29.197103Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.17) starting as process 19215
2019-08-29T10:17:29.198585Z 0 [Warning] [MY-013242] [Server] --character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2019-08-29T10:17:29.212437Z 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used. InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2019-08-29T10:17:30.332355Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2019-08-29T10:17:30.527866Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2019-08-29T10:17:30.540585Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2019-08-29T10:17:30.542349Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-08-29T10:17:30.545172Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2019-08-29T10:17:30.545403Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we’re sending the information to the error-log instead: MY-001146 - Table ‘mysql.component’ doesn’t exist
2019-08-29T10:17:30.545418Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we’re sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2019-08-29T10:17:30.545881Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
2019-08-29T10:17:30.545919Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the ‘Upgrading MySQL’ section from the MySQL manual.
2019-08-29T10:17:30.546181Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-08-29T10:17:31.887211Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.

正在回答 回答被采纳积分+3

1回答

sqlercn 2019-08-30 09:50:39

这个应该是mySQL系统库初始化的问题,在启动之前需要先使用mysqld命令对系统库进行初始化。

0 回复 有任何疑惑可以回复我~
问题已解决,确定采纳
还有疑问,暂不采纳
意见反馈 帮助中心 APP下载
官方微信