MYSQL的一个安装的小问题
安装MYSQL显示成功,但是却无法初始化 初始化后会出现如下的代码
E:\MYSQL\mysql-8.0.17-winx64\bin>mysqld -initialize
以下是出现的结果:
2019-09-24T11:22:00.535388Z 0 [Warning] [MY-010915] [Server] ‘NO_ZERO_DATE’, ‘NO_ZERO_IN_DATE’ and ‘ERROR_FOR_DIVISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2019-09-24T11:22:00.535537Z 0 [System] [MY-010116] [Server] E:\MYSQL\mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) starting as process 12384
2019-09-24T11:22:00.535601Z 0 [ERROR] [MY-010338] [Server] Can’t find error-message file ‘D:\mysql-5.7.23-winx64\share\errmsg.sys’. Check error-message file location and ‘lc-messages-dir’ configuration directive.
2019-09-24T11:22:00.536278Z 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-09-24T11:22:00.537499Z 0 [Warning] [MY-010091] [Server] Can’t create test file D:\mysql-5.7.23-winx64\data\mysqld_tmp_file_case_insensitive_test.lower-test
2019-09-24T11:22:00.537528Z 0 [Warning] [MY-010091] [Server] Can’t create test file D:\mysql-5.7.23-winx64\data\mysqld_tmp_file_case_insensitive_test.lower-test
2019-09-24T11:22:00.537787Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to ‘D:\mysql-5.7.23-winx64\data’ (OS errno: 2 - No such file or directory)
2019-09-24T11:22:00.622548Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-09-24T11:22:00.622972Z 0 [System] [MY-010910] [Server] E:\MYSQL\mysql-8.0.17-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL