Centos7使用docker快速安装mysql

素颜马尾好姑娘i 2022-03-17 10:13 251阅读 0赞

# 一、docker安装 #

## 1、拉取镜像及创建挂载文件 ##

#拉取mysql镜像
    docker pull hub.c.163.com/library/mysql:5.7
    #用于挂载mysql数据文件
    mkdir /home/mysql/data 
    #用于挂载mysql配置文件
    mkdir /home/mysql/conf 
    #用于挂载mysql日志文件
    mkdir /home/mysql/logs
    #修改image的tgs
    docker tag hub.c.163.com/library/mysql:5.7 mysql:5.7

## 2、启动容器 ##

docker run -p 3306:3306 --name mysql5.7 -v /home/mysql/conf:/etc/mysql/conf.d -v /home/mysql/logs:/logs -v /home/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
    #-p 3306:3306：将容器的3306端口映射到主机的3306端口
    #-v /home/mysql/conf:/etc/mysql/conf.d：将主机/home/mysql/conf目录挂载到容的/etc/mysql/conf.d
    #-e MYSQL_ROOT_PASSWORD=123456：初始化root用户的密码
    #-d: 后台运行容器，并返回容器ID
    
    #进入mysql控制端
    docker exec -it  2a7a85124400  /bin/bash

# 二、docker-compose安装 #

version: '3'
    services:
        mysql:
          image: 'mysql:8.0.19'
          restart: always
          container_name: mysql
          environment:
            MYSQL_ROOT_PASSWORD: 123456
          command:
            --default-authentication-plugin=mysql_native_password
            --character-set-server=utf8mb4
            --collation-server=utf8mb4_general_ci
            --explicit_defaults_for_timestamp=true
            --lower_case_table_names=1
          ports:
            - '3306:3306'
          volumes:
            - /srv/dev-disk-by-id-ata-HITACHI_HUA723030ALA640_YHJL158A-part1/appdata/mysql/data:/var/lib/mysql

# 三、进入mysql设置远程连接权限 #

#进入mysql
    mysql -h 127.0.0.1 -u root -p
    #设置远程连接权限
    grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
    #刷新权限
    flush privileges;
    
    #8.0.18版本
    # 新建一个用户
    create user 'test'@'%' identified by '123456';
    # 授权
    GRANT ALL PRIVILEGES ON *.* TO 'test'@'%';
    # 刷新权限
    flush privileges;
    # 设置远程访问
    ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
    # 刷新权限
    flush privileges;

# 四、防火墙设置 #

#编辑防火墙配置文件
    vi /etc/sysconfig/iptables
    -A IN_public_allow -p tcp -m tcp --dport 3306 -m conntrack --ctstate NEW -j ACCEPT
    #重启防火墙
    systemctl restart iptables
    
    ##如果是云服务需到云端配置安全组规则