[mysqld]
port=3306
server-id=1
log-bin=mysql-bin
binlog_format=row
binlog-do-db=shopping_mall_main

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8mb4

version: '3'

services:
  db:
   

select `user`.id as user_id, `user`.username as 用户名, `role`.name as 角色, `power`.name as 权限
from `user`  
    left join (`user

查询是否开启
SHOW VARIABLES LIKE ‘slow_query%’;

查询超时时间
SHOW VARIABLES LIKE ‘long_query_time%’;

[mysqld]
show_query_log=on/off  # 开启或关闭
log-slow-queries=dir/filename
long_query_time=n       # 忍耐时间
log_ou