创建一张逻辑网卡

docker network create --driver bridge --subnet 172.20.0.0/16 my-network

启动

docker run --name some-mysql -p3306:3306 --network my-network --ip 172.20.0.11  -v /data/conf/custom:/etc/mysql/conf.d -v /data/own/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=1^HGnFCmS@VQxKWx6 -d mysql:5.7.32

首先系统时间

ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

# 设置全局时区
mysql> set global time_zone = '+8:00';
Query OK, 0 rows affected (0.00 sec)
# 设置时区为东八区
mysql> set time_zone = '+8:00';
Query OK, 0 rows affected (0.00 sec)

# 刷新权限使设置立即生效
mysql>  flush privileges; 
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | UTC    |
| time_zone        | +08:00 |
+------------------+--------+
2 rows in set (0.00 sec)


mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2021-01-08 10:07:15 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y-%m-%d %T');
+------------------------------------------------+
| FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y-%m-%d %T') |
+------------------------------------------------+
| 2021-01-08 10:09:27                            |
+------------------------------------------------+
1 row in set (0.00 sec)

vi /etc/my.cnf
 mysqld下边的配置中添加一行：
default-time_zone = '+8:00'
  重启mysql生效

select host,user,authentication_string from mysql.user;

grant all privileges on *.* to 'root'@'127.0.0.1' identified by '123456';
 flush privileges;