由于原本存放软件的起名不规范，最近修改了文件夹的名称，今天需要文件夹里安装的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安装目录下的文件 my.ini
?将方框内的路径更改为现在更改后的路径
二、windows + r 打开“运行”，输入regedit回车打开注册表，HKEY_LOCAL_MACHINE-->SYSTEM-->CurrentControlSet-->services下找到MySQL服务键
也可打开后在输入框里直接输入
计算机\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL57
然后选择ImagePath右键修改
属性值为my.ini文件新的绝对路径。
例:
"D:\CourseSoftware\mysql\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="D:\CourseSoftware\mysql\MySQL Server 5.7\my.ini" MySQL57
完成~
打开任务管理器-服务-MySql-右键启动成功
附上帮我解决了部分问题的链接:https://jingyan.baidu.com/article/eb9f7b6d7e02b1869364e828.html