解决 java.sql.SQLSyntaxErrorException: Expression

Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘dys_msme.scene_his_info.scene_his_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘dys_msme.scene_his_info.scene_his_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

修改配置文件

vi /etc/mysql/mysql.conf.d/mysqld.cnf
添加以下配置
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

重启msyql

systemctl restart mysql

 FLUSH PRIVILEGES

在docker 中永久修改
映射配置文件

volumes:
      - /workspace/config/mysql/datadir:/var/lib/mysql
      - /workspace/config/mysql/conf:/etc/mysql/conf.d
      - /workspace/config/mysql/conf/mysql.conf.d:/etc/mysql/mysql.conf.d 
      - /workspace/config/mysql/conf/my.cnf:/etc/mysql/my.cnf 
      - /workspace/config/mysql/logs:/var/log/mysql

在my.conf中添加以下代码

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

修改当前会话sql_mode

SET SESSION sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE';

mysql 8.0修改mysql密码

mysql> show databases;

mysql> use mysql;

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
或者
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '123456';

mysql> flush privileges;   --刷新MySQL的系统权限相关表

mysql> exit;

在 Ubuntu 上安装 MySQL 的完整步骤如下（支持 ​​Ubuntu 20.04/22.04/24.04​​）：


​​步骤1：更新软件包并安装MySQL​​
sudo apt update
sudo apt install mysql-server -y  # 安装最新稳定版
​​关键配置与操作​​
修改配置文件：
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
找到 bind-address 并改为：
bind-address = 0.0.0.0
重启MySQL：
sudo systemctl restart mysql