Command Palette
Search for a command to run...
#1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'stack_wordpress.wp_postmeta.meta_value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
1055 - Expression 1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'stack_wordpress.wp_postmeta.meta_value' which is not functionally dependent on columns in GROUP BY c...
MySQL中binlog过多的正确处理方式
登录MySQL mysql -u root -p 查看binlog过期时间 命令： show variables like 'expire_logs_days'; Empty set 或者 0：永不过期 10：保留最近10天的binlog文件 设置自动清理binlog 修改配置文件，在[mysqld]标签下增加内容： MySQL8.0之前： expire_logs_days=10 max_binl...
1Panel的MySql数据库异常警告
装上1Panel后用了一段时间，发现MySQL 8.2.0日志不停报错，内容为： 2023-11-28T05:14:24.537671Z 12560 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ‘‘mysql_native_password’ is deprecated and will be remo...