docker实际使用mysql例三

例三：当虚拟机安装MySQL使用

宿主机操作

• useradd mysql
• id mysql
  • uid=1002(mysql) gid=1002(mysql) groups=1002(mysql)
• mkdir -p /usr/local/docker/mysql8027/conf  /usr/local/docker/mysql8027/data  /usr/local/docker/mysql8027/logs
• cp /etc/profile  /usr/local/docker/mysql8027/conf/profile  ##注意同版本干净的profile 
• echo 'export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/local/mysql/bin'>> /usr/local/docker/mysql8027/conf/profile    ##注意/usr/local/mysql/bin的实际路径
• vim /usr/local/docker/mysql8027/conf/my.cnf   ##此处略 

• docker pull centos:8.4.2105
• docker network create --driver bridge --subnet=10.0.0.0/24 --gateway=10.0.0.254 mysql

• docker run -itd \
  --name mysql8027 --hostname mysql8027 \
  --net mysql --ip=10.0.0.11 -p 8027:8027 \
  -v /usr/local/docker/mysql8027/conf/my.cnf:/etc/my.cnf \
  -v /usr/local/docker/mysql8027/conf/profile:/etc/profile \
  -v /usr/local/docker/mysql8027/data:/usr/local/mysql/data \
  -v /usr/local/docker/mysql8027/logs:/usr/local/mysql/logs \
  -v /etc/localtime:/etc/localtime \
  centos:8.4.2105

• tar -xvf mysql-commercial-8.0.27-linux-glibc2.12-x86_64.tar.xz
• docker cp /home/Jaylon/download/mysql_stup/mysql-commercial-8.0.27-linux-glibc2.12-x86_64 mysql8027:/usr/local/

进入容器

• docker exec -it mysql8027 /bin/bash
• ##预备MySQL实例程序
  • cd /usr/local
  • mv  mysql-commercial-8.0.27-linux-glibc2.12-x86_64/*   /usr/local/mysql
  • rm -rf  mysql-commercial-8.0.27-linux-glibc2.12-x86_64
  • chown -R mysql:mysql  /usr/local/mysql
• groupadd -g 1002 mysql
• useradd -u 1002 -g mysql mysql
• id mysql
  • uid=1002(mysql) gid=1002(mysql) groups=1002(mysql)  ##uid  gid与宿主机保持一致
• ldd /usr/local/mysql/bin/mysql

  • • linux-vdso.so.1 (0x00007ffd3e9b4000)
      libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f8bc6ffa000)
      libdl.so.2 => /lib64/libdl.so.2 (0x00007f8bc6df6000)
      libcrypto.so.1.1 => /usr/local/mysql/bin/../lib/private/libcrypto.so.1.1 (0x00007f8bc6944000)
      libssl.so.1.1 => /usr/local/mysql/bin/../lib/private/libssl.so.1.1 (0x00007f8bc66b4000)
      libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f8bc649d000)
      librt.so.1 => /lib64/librt.so.1 (0x00007f8bc6295000)
      libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f8bc606a000)
      libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f8bc5cd5000)
      libm.so.6 => /lib64/libm.so.6 (0x00007f8bc5953000)
      libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f8bc573b000)
      libc.so.6 => /lib64/libc.so.6 (0x00007f8bc5376000)
      /lib64/ld-linux-x86-64.so.2 (0x00007f8bc721a000)

• ldd /usr/local/mysql/bin/mysqld

  • • linux-vdso.so.1 (0x00007ffefacef000)
      libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f63e38a9000)
      libdl.so.2 => /lib64/libdl.so.2 (0x00007f63e36a5000)
      librt.so.1 => /lib64/librt.so.1 (0x00007f63e349d000)
      libcrypto.so.1.1 => /usr/local/mysql/bin/../lib/private/libcrypto.so.1.1 (0x00007f63e2feb000)
      libssl.so.1.1 => /usr/local/mysql/bin/../lib/private/libssl.so.1.1 (0x00007f63e2d5b000)
      libprotobuf-lite.so.3.11.4 => /usr/local/mysql/bin/../lib/private/libprotobuf-lite.so.3.11.4 (0x00007f63e2ac9000)
      libaio.so.1 => /lib64/libaio.so.1 (0x00007f63e28c6000)
      libnuma.so.1 => /lib64/libnuma.so.1 (0x00007f63e26ba000)
      libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007f63e2325000)
      libm.so.6 => /lib64/libm.so.6 (0x00007f63e1fa3000)
      libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f63e1d8b000)
      libc.so.6 => /lib64/libc.so.6 (0x00007f63e19c6000)
      /lib64/ld-linux-x86-64.so.2 (0x00007f63e3ac9000)

• /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize-insecure --user=mysql &   #初始化root无密码
• /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &
• mysql -uroot -p  #回车直接登陆
• update user set host='%' where user='root' and host='localhost';
• ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'xxx' PASSWORD EXPIRE NEVER;
• FLUSH PRIVILEGES;