MySQL8.0查询报错

错误信息:

1231 - Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

1. 临时解决

   select version();
   select @@global.sql_mode   查询sql_mode
   set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

2. 永久解决

   • 修改my.cnf (一般会在/etc目录下)

   • 去掉ONLY_FULL_GROUP_BY参数:

   • 添加以下

     sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

3. 重启MySQL:systemctl restart mysqld