搭建docker、mysql8环境

中文

搭建docker环境

wget http://10.0.42.1:4201/docker/docker-ce-18.06.offline.tar
mkdir docker1806
cd docker1806/
tar xf ../docker-ce-18.06.offline.tar
rpm -ivh --replacefiles --replacepkgs *.rpm
systemctl enable docker
systemctl start docker
systemctl status docker
docker ps
cat > /etc/docker/daemon.json <<EOL
{
    "insecure-registries": [ "10.131.9.12:5000"]
}
EOL
systemctl restart docker
systemctl start docker.service

备注：docker1806内容

                         libnetfilter_conntrack-1.0.6-1.el7_3.x86_64.rpm  libtool-ltdl-2.4.2-22.el7_3.x86_64.rpm
audit-libs-2.8.4-4.el7.x86_64.rpm          libnfnetlink-1.0.1-4.el7.x86_64.rpm              policycoreutils-2.5-29.el7_6.1.x86_64.rpm
audit-libs-python-2.8.4-4.el7.x86_64.rpm   libseccomp-2.3.1-3.el7.x86_64.rpm                policycoreutils-python-2.5-29.el7_6.1.x86_64.rpm
checkpolicy-2.5-8.el7.x86_64.rpm           libselinux-2.5-14.1.el7.x86_64.rpm               python-IPy-0.75-6.el7.noarch.rpm
container-selinux-2.95-2.el7_6.noarch.rpm  libselinux-python-2.5-14.1.el7.x86_64.rpm        selinux-policy-3.13.1-229.el7_6.12.noarch.rpm
docker-ce-18.06.3.ce-3.el7.x86_64.rpm      libselinux-utils-2.5-14.1.el7.x86_64.rpm         selinux-policy-targeted-3.13.1-229.el7_6.12.noarch.rpm
iptables-1.4.21-28.el7.x86_64.rpm          libsemanage-2.5-14.el7.x86_64.rpm                setools-libs-3.3.8-4.el7.x86_64.rpm
libcgroup-0.41-20.el7.x86_64.rpm           libsemanage-python-2.5-14.el7.x86_64.rpm
libmnl-1.0.3-7.el7.x86_64.rpm              libsepol-2.5-10.el7.x86_64.rpm

搭建mysql8环境

docker login 10.131.9.12:5000
docker pull 10.131.9.12:5000/base/mysql:8.0.20
docker run -di -p 3404:3306 -e MYSQL_ROOT_PASSWORD=u8BPcLZMdn7orgXw -v /Users/zhaoyan/data/mysql80:/var/lib/mysql:rw --name mysql --restart=always mysql:8.0.20 --lower_case_table_names=1
docker run -di -p 3404:3306 -e MYSQL_ROOT_PASSWORD=u8BPcLZMdn7orgXw -v /Users/zhaoyan/data/mysql80:/var/lib/mysql:rw --name mysql --restart=always 10.131.9.12:5000/base/mysql:8.0.20 --lower_case_table_names=1
docker ps
lsof -i:3404
mysql -uroot -h 127.0.0.1 -p 3404
mysql -uroot -h localhost -p 3404
docker exec -it 2922c224bb0b /bin/bash
docker ps
docker stop 2922c224bb0b
docker rm 2922c224bb0b

mkdir /var/mysql
docker run -di -p 3404:3306 -e MYSQL_ROOT_PASSWORD=u8BPcLZMdn7orgXw -v /var/mysql:/var/lib/mysql:rw --name mysql --restart=always 10.131.9.12:5000/base/mysql:8.0.20 --lower_case_table_names=1
ls /var/mysql/
ls /Users/zhaoyan/data/mysql80/
rm -rf /Users
ll
docker ps

mysql8配置

/etc/mysql/my.cnf

主要是更改字符集，否则php5版本因为字符集无法连上。

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8

修改账号密码认证方式，否则提示密码无法认证：

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