Centos7使用docker快速安装mysql 素颜马尾好姑娘i 2022-03-17 10:13 217阅读 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 ##如果是云服务需到云端配置安全组规则
还没有评论,来说两句吧...