由于原本存放软件的起名不规范,最近修改了文件夹的名称,今天需要文件夹里安装的Mysql启动不了。
执行net start mysql 无服务
执行mysqld --initialize出现以下字段
2021-10-28T10:51:54.128445Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-10-28T10:51:54.131202Z 0 [Warning] '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. 2021-10-28T10:51:54.131212Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2021-10-28T10:51:54.154442Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting. 2021-10-28T10:51:54.155529Z 0 [ERROR] Aborting
操作如下:
一、找到Mysql安装目录下的文件