Windows phpstudy 启动 MySQL报错
来自维基鲸
Windows phpstudy 启动 MySQL报错
2020-12-23T02:17:31.813638Z 0 [ERROR] E:\phpstudy_pro\COM…\Extensions\MySQL5.7.26\bin\mysqld.exe: Error while setting value ‘STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION’ to ‘sql_mode’ 2020-12-23T02:17:31.813822Z 0 [ERROR] Aborting 2020-12-23T02:17:31.813844Z 0 [Note] Binlog end
解决办法:
根据报错提示路径找到E:\phpstudy_pro\COM…\Extensions\MySQL5.7.26 my.ini文件 打开文件找到sql_mode=这一行,删除逗号后面的空格,然后重启MySQL就可以了.
