查看容器应用IP：

  1. docker inspect --format='{{.NetworkSettings.IPAddress}}' mysql

mysql

docker run -d --name mysql -v /mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=root -p 3306:3306 mysql:5.7

docker exec -it mysql /bin/bash 

mysql -uroot -proot

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

FLUSH PRIVILEGES;

use mysql; 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
FLUSH PRIVILEGES;

docker cp mysql:./etc/mysql/mysql.conf.d/mysqld.cnf  ~/mysql/mysqld.cnf 

[mysqld]
lower_case_table_names=1
#拷贝修改后的mysqld.cnf文件到容器
docker cp ~/mysql/mysqld.cnf  mysql:./etc/mysql/mysql.conf.d/mysqld.cnf 

docker restart mysql 

docker logs mysql

xxl-job


docker run -e PARAMS="--spring.datasource.url=jdbc:mysql://192.168.144.1:3306/xxl_job?Unicode=true&characterEncoding=UTF-8 --spring.datasource.username=root --spring.datasource.password=root --xxl.admin.login=false" -p 9080:8080 --name xxl-job-admin -d xuxueli/xxl-job-admin:2.3.1