Docker手动安装mysql

1、创建centos镜像的容器

[root@localhost Tools]# docker run -i -d -h zabbix --name zabbix -p 3306:3306 --privileged=true -v /sys/fs/cgroup:/sys/fs/cgroup centos:7 /usr/sbin/init

2、进入容器

[root@localhost Tools]# docker exec -it zabbix /bin/bash

3、下载yum repo配置文件

• 由于CentOS 的yum源中没有mysql，需要到mysql的官网下载yum repo配置文件
• 安装必要的工具包，vim 编辑文件，net-tools 网络管理工具 wget 下载文件
• repo的安装

[root@zabbix /]# yum -y install vim net-tools wget  
[root@zabbix /]# mkdir Tools
[root@zabbix /]# cd Tools/
[root@zabbix Tools]# wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
[root@zabbix Tools]# rpm -ivh mysql57-community-release-el7-9.noarch.rpm

• rpm -ivh mysql57-community-release-el7-9.noarch.rpm执行完会在/etc/yum.repos.d目录下生成两个文件mysql-community.repo、mysql-community-source.repo
  

4、修改mysql的yum源

[root@zabbix Tools]# cd /etc/yum.repos.d
[root@zabbix yum.repos.d]# mv mysql-community.repo mysql-community.repo.bak
[root@zabbix yum.repos.d]# vim mysql-community.repo     
[root@zabbix yum.repos.d]# cat mysql-community.repo

• yum源修改为国内镜像源https://mirrors.cnnic.cn/help/mysql/

[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-connectors-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-tools-community]
name=MySQL Tools Community
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-tools-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-5.6-community]
name=MySQL 5.6 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-5.6-community-el7-$basearch/
enabled=0
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-5.7-community]
name=MySQL 5.7 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-5.7-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

[mysql-8.0-community]
name=MySQL 8.0 Community Server
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-$basearch/
enabled=1
gpgcheck=1
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql

5、配置key

[root@zabbix yum.repos.d]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

6、yum 安装

• 需在/etc/yum.repos.d路径下

[root@zabbix yum.repos.d]# yum -y install mysql-server

7、mysql服务管理

[root@zabbix yum.repos.d]# systemctl start mysqld   # 启动服务
[root@zabbix yum.repos.d]# systemctl restart mysqld # 重启服务
[root@zabbix yum.repos.d]# systemctl stop mysqld    # 停止服务 
[root@zabbix yum.repos.d]# systemctl status mysqld  # 查看状态 

8、获取临时密码(第一次登录)

[root@zabbix yum.repos.d]# grep 'temporary password' /var/log/mysqld.log

9、登录mysql

[root@zabbix yum.repos.d]# mysql -uroot -p'Pt1!yvM2w-k9'

10、修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Yangxiao214.';

11、开启远程控制

• user表中host的值为 % 代表任意的客户端,可替换成具体IP地址。

mysql> show databases;
mysql> use mysql
mysql> show tables
mysql> desc user;
mysql> select host,user from user;
mysql> update user set host='%' where user='root';
mysql> flush privileges;

12、验证