docker安装mysql5.7

[root@RdsRedisMongo ~]#docker pull mysql:5.7

[root@RdsRedisMongo ~]#mkdir -p /root/docker/mysql/conf.d
[root@RdsRedisMongo ~]#mkdir -p /root/docker/mysql/var/lib/mysql
[root@RdsRedisMongo ~]#vim /root/docker/mysql/conf.d/config-file.cnf
[root@RdsRedisMongo ~]#cat /root/docker/mysql/conf.d/config-file.cnf
[mysqld]
# 设置表名不区分大小写 linux下默认是区分的，windows下默认不区分
lower_case_table_names=1
#server-id=1
datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysqlx.sock
#symbolic-links=0
# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

docker run --name mysql \
--restart=always \
-p 3306:3306 \
-v /root/docker/mysql/conf.d:/etc/mysql/conf.d \
-v /root/docker/mysql/var/lib/mysql:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=laiyue202201052044 \
-e TZ=Asia/Shanghai \
-d mysql:5.7

SET PASSWORD = PASSWORD('laiyue202201052044');

[root@RdsRedisMongo ~]#docker exec -it mysql bash
root@e898a5bb1378:/# mysql -uroot -plaiyue202201052044(默认密码root)

mysql> GRANT ALL ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'laiyue202201052044';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit

备注修改登录密码：
mysql> SET PASSWORD = PASSWORD('laiyue202201052044');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>