小傅哥 bugstack 虫洞栈

# Q&A：常见开发问题错误解答

作者：小傅哥
博客：https://bugstack.cn (opens new window)
课程：https://t.zsxq.com/Yfbwo (opens new window)

沉淀、分享、成长，让自己和他人都能有所收获！😄

# 一、断点调试

# 二、开发问题

# 1. Parameter 'teamIds' not found.

如果遇到报错提示，有兼容问题，可以添加 @Param("teamIds") 到方法上 Integer queryAllUserCount(@Param("teamIds") Set<String> teamIds);

# 2. this is incompatible with sql_mode=only_full_group_by

添加 my.cnf 文件

[client]
port                    = 3306
default-character-set   = utf8mb4

[mysqld]
user                    = mysql
port                    = 3306
sql_mode                = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

default-storage-engine  = InnoDB
default-authentication-plugin   = mysql_native_password
character-set-server    = utf8mb4
collation-server        = utf8mb4_unicode_ci
init_connect            = 'SET NAMES utf8mb4'

slow_query_log
#long_query_time         = 3
slow-query-log-file     = /var/log/mysql/mysql.slow.log
log-error               = /var/log/mysql/mysql.error.log

default-time-zone       = '+8:00'

[mysql]
default-character-set   = utf8mb4

  
        @小傅哥: 代码已经复制到剪贴板
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

修改 docker compose

mysql:
  image: registry.cn-hangzhou.aliyuncs.com/xfg-studio/mysql:8.0.32
  container_name: mysql
  command: --default-authentication-plugin=mysql_native_password
  restart: always
  environment:
    TZ: Asia/Shanghai
    MYSQL_ROOT_PASSWORD: 123456
  ports:
    - "13306:3306"
  volumes:
    - ./mysql/my.cnf:/etc/mysql/conf.d/mysql.cnf:ro
    - ./mysql/sql:/docker-entrypoint-initdb.d
  healthcheck:
    test: [ "CMD", "mysqladmin" ,"ping", "-h", "localhost" ]
    interval: 5s
    timeout: 10s
    retries: 10
    start_period: 15s
  networks:
    - my-network

  
        @小傅哥: 代码已经复制到剪贴板
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
  • 修改 MySQL 8.0 安装配置

← 【更】第1-1节：拼团需求分析 →

京ICP备19031103号 |

京公网安备 11030102010881号

 | GPL Licensed | Copyright © 2019 小傅哥，All rights reserved.