请稍等 ...
×

采纳答案成功!

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

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

2回答

sqlercn 2019-04-19 17:20:33

这个要看一下mysql的错误日志中的记录才能判断原因

0 回复 有任何疑惑可以回复我~
提问者 宝慕林5517107 2019-04-19 10:41:23

mysql-error.log日志信息

2019-04-19T02:15:41.653364Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.

2019-04-19T02:15:41.653433Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-04-19T02:15:41.653509Z 0 [ERROR] [MY-010119] [Server] Aborting

2019-04-19T02:15:41.654337Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.15)  MySQL Community Server - GPL.

2019-04-19T02:24:13.422797Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.

2019-04-19T02:24:13.422844Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.

2019-04-19T02:24:13.422879Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2019-04-19T02:24:13.424070Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.

2019-04-19T02:24:13.424105Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.15) starting as process 3007

2019-04-19T02:24:13.425262Z 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-04-19T02:24:13.434189Z 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-04-19T02:24:13.436990Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.


0 回复 有任何疑惑可以回复我~
  • sqlercn #1
    看日志是MySQL的系统数据库没有正确初始化的原因。把undo_log,sql_log,data目录下的数据全部清空,然后再重新初始化一下系统数据库试一下。
    回复 有任何疑惑可以回复我~ 2019-04-19 17:21:55
问题已解决,确定采纳
还有疑问,暂不采纳
意见反馈 帮助中心 APP下载
官方微信