docker mysql 8安装 并解决only_full_group_by 问题解决

 docker run -p 3306:3306 --name mysql8 -v /data/mysql/mysql/config:/etc/mysql/conf.d -v /data/mysql/mysql/logs:/logs -v /data/mysql/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -d mysql:8

**进入 mysql8 容器 连接mysql 修改密码 **

docker exec -it mysql8 bash
mysql -uroot -p
use mysql;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '更新一下用户的密码'; #
FLUSH PRIVILEGES; #刷新权限

sql_mode=only_full_group_by 问题解决

set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';