Windows安装MySQL8提示：Error while setting value ‘STRICT_TRANS_TAB

安装MySQL提示错误如下：

2021-07-07T08:55:28.020058Z 0 [ERROR] [MY-000077] [Server] D:\mysql-8.0.25-winx64\bin\mysqld.exe: Error while setting value 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.
2021-07-07T08:55:28.020140Z 0 [ERROR] [MY-010187] [Server] Could not open file 'C:\ProgramData\MySQL\MySQL Server 5.5\Data\DESKTOP-KQB5CTE.err' for error logging: Permission denied
2021-07-07T08:55:28.032849Z 0 [ERROR] [MY-013236] [Server] The designated data directory C:/ProgramData/MySQL/MySQL Server 5.5/Data/ is unusable. You can remove all files that the server added to it.
2021-07-07T08:55:28.040115Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-07-07T08:55:28.040172Z 0 [Note] [MY-010120] [Server] Binlog end

更改my.ini文件的地址，注释my.ini文件的sql_mode，确保错误中的路径下所有MySQL文件全被删除，删除所有注册表，卸载原先的MySQL都不行。

最后直接去官方文档下载了安装包，不使用百度上用命令行安装MySQL。安装包会直接覆盖之前的配置，直接干掉所有问题。

MySQL官方安装教程：https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

里面包含了其他系统的安装，注意要看Windows的安装教程

MySQL官方8.0安装包下载地址：https://dev.mysql.com/downloads/installer/