docker拉取mysql数据库镜像，并成功用新密码登录

docker安装

[root@root ~]# cat docker.sh

#!/bin/bash
yum -y install lsof wget htop net-tools
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo 
yum clean all
yum makecache
yum install -y yum-utils device-mapper-persistent-data lvm2
yum-config-manager --add-repo https://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
yum -y install docker-ce
systemctl stop firewalld
setenforce 0
systemctl start docker
ps ef|grep docker

拉取mysql镜像

docker pull daocloud.io/library/mysql:5.7
docker images
docker ps -a
docker run -itd 718a6da099d8 /bin/bash
docker ps
docker exec -it 69d50b1929e2 /bin/bash

升级下载vim

apt-get update
apt-get install vim
vim /etc/mysql/conf.d/docker.cnf

加上这4段

[mysqld]
skip-host-cache
skip-name-resolve
skip-grant-tables

创建mysql钥匙文件日志存放目录（已有不用操作）

mkdir -p /var/run/mysqld
chown mysql /var/run/mysqld/
service mysql restart

停止服务在进容器，破解密码进入数据库

docker stop 69d50b1929e2
docker restart 69d50b1929e2
docker exec -it 69d50b1929e2 /bin/bash
service mysql restart
mysql-uroot -p

更改容器内数据库密码

mysql -u root -p
use mysql;
UPDATE user SET authentication_string=PASSWORD(‘123’) where USER=‘root’;
flush privileges;
exit

把权限去掉，用密码登录

sed -i s’/skip-grant-tables/#skip-grant-tables/g’ /etc/mysql/conf.d/docker.cnf
root@69d50b1929e2:/# cat /etc/mysql/conf.d/docker.cnf
exit
service mysql restart
mysql -u root -p ‘123’

容器mysql5.7到这就处理完毕了。