docker-compose up -d

docker-compose down

CREATE USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%';
FLUSH PRIVILEGES;

地址 127.0.0.1
端口 3306
账号 test
密码 123456

SHOW VARIABLES LIKE 'sql_mode%';

删除里面的 NO_ZERO_IN_DATE,NO_ZERO_DATE（每个人的sql_mode 不一样 先查询自己的在替换）

[mysqld]
sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#sql_mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

0 1 * * *  /mysql/copy.sh