2回答

sqlercn

2019-04-19

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

0

0

宝慕林5517107

提问者

2019-04-19

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

1

sqlercn

看日志是MySQL的系统数据库没有正确初始化的原因。把undo_log,sql_log,data目录下的数据全部清空，然后再重新初始化一下系统数据库试一下。

2019-04-19

共1条回复