使用Docker部署MySQL作为测试环境
使用Docker部署MySQL作为测试环境
这里说明了作为测试环境,生产环境下不建议将MySQL使用Docker部署
查找镜像
root@centos7-docker opt]# docker search mysql
NAME DESCRIPTION STARS OFFICIAL AUTOMATED
mysql MySQL is a widely used, open-source relation… 12527 [OK]
mariadb MariaDB Server is a high performing open sou… 4819 [OK]
percona Percona Server is a fork of the MySQL relati… 575 [OK]
phpmyadmin phpMyAdmin - A web interface for MySQL and M… 527 [OK]
bitnami/mysql Bitnami MySQL Docker Image 70 [OK]
linuxserver/mysql-workbench 36
linuxserver/mysql A Mysql container, brought to you by LinuxSe… 35
ubuntu/mysql MySQL open source fast, stable, multi-thread… 31
circleci/mysql MySQL is a widely used, open-source relation… 25
google/mysql MySQL server for Google Compute Engine 21 [OK]
vmware/harbor-db Mysql container for Harbor 10
bitnami/mysqld-exporter 3
ibmcom/mysql-s390x Docker image for mysql-s390x 2
newrelic/mysql-plugin New Relic Plugin for monitoring MySQL databa… 1 [OK]
vitess/mysqlctld vitess/mysqlctld 1 [OK]
nasqueron/mysql 1 [OK]
cimg/mysql 0
silintl/mysql-backup-restore Simple docker image to perform mysql backups… 0 [OK]
drud/mysql-local-57 ddev mysql local container 0
drud/mysql 0
drud/mysql-docker-local-57 This repo has been deprecated, new tags are … 0
drud/mysql-docker-local docker containers for local womysql rk 0 [OK]
docksal/mysql MySQL service images for Docksal - https://d… 0
mirantis/mysql 0
drud/mysqld-exporter 0
建立目录映射
mkdir -p /opt/docker/mysql
mkdir -p /opt/docker/mysql/logs
mkdir -p /opt/docker/mysql/data
mkdir -p /opt/docker/mysql/mysql-files
运行
docker run -p 3306:3306 --name mysql-3306 \
-v /opt/docker/mysql/conf:/etc/mysql \
-v /opt/docker/mysql/logs:/var/log/mysql \
-v /opt/docker/mysql/data:/var/lib/mysql \
-v /opt/docker/mysql/mysql-files:/var/lib/mysql-files/ \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql
修改可以远程连接
进入容器
docker exec -it mysql-3306 /bin/bash
登录mysql
mysql -u root -P 123456
授权
mysql> use mysql;
Database changed
mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> GRANT ALL ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.01 sec)
mysql> GRANT ALL ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.01 sec)
如果使用Navicat的话。 因为Navicat只支持旧版本的加密,需要更改mysql的加密规则
ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;