1.缺少msvcr120.dll
C:\Windows\system32>"C:\Program Files\mysql-5.7.31-winx64\bin\mysqld.exe" --initialize-insecure
执行初始化命令时,报错缺少msvcr120.dll
懒人修复法(顺便解决缺失其他系统文件)
下载DirectXRepair39 百度网盘 请输入提取码
提取码:nhlb
工具->选项->实验室->C++强烈修复
2.没有以管理员身份执行初始化指令
报错:
mysqld: Could not create or access the registry key needed for the MySQL application
to log to the Windows EventLog.
解决:以管理员身份打开cmd执行初始化指令
3.之前初始化的时候已经生成data文件导致Aborting
报错:
C:\Windows\system32>"C:\Program Files\mysql-5.7.31-winx64\bin\mysqld.exe" --initialize-insecure
2022-03-28T08:11:48.681395Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-03-28T08:11:49.751699Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2022-03-28T08:11:49.752376Z 0 [ERROR] Aborting
修复:
把mysql根目录下data文件夹删除,重新以管理员身份执行initialize-insecure