mysqld.exe: Error while setting value ‘STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION’ to ‘sql_mode’

2022-07-15T08:13:07.431741Z 0 [ERROR] Aborting

mysqld.exe: Error while setting value ‘STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION’ to ‘sql_mode’

2022-07-15T08:13:07.431741Z 0 [ERROR] Aborting

本地电脑使用phpstudy,启动出现这个错误，将

sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

sql_mode 各项之间的空格去掉，保存，重启就好了