docker 安装 mysql5.7与mariadb:10

docker 安装 mysql5.7与mariadb:10 1.安装mysql5.7 docker镜像

拉取官方mysql5.7镜像 

docker pull mysql:5.7
mkdir -p /data/mysql/data /data/mysql/logs /data/mysql/conf
touch /data/mysql/conf/my.cnf
docker run --restart=always -p 13306:3306 --name mysql -v /data/mysql/conf:/etc/mysql/conf.d -v /data/mysql/logs:/logs -v /data/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=111111 -d mysql:5.7
docker start mysql

-d: 后台运行容器

-p 将容器的端口映射到本机的端口

-v 将主机目录挂载到容器的目录

-e 设置参数

2.安装mariadb:10 docker镜像,并且创建testdb数据库授权外网访问

docker pull mariadb:10.0   
docker run --name mariadb -p 13306:3306 -e MYSQL_ROOT_PASSWORD=nihaoma -d d1bde56970c6
docker exec -it mariadb bash
mysql -u root -pnihaoma
mysql
> CREATE DATAbase IF NOT EXISTS testdb COLLATE = 'utf8_general_ci' CHARACTER SET = 'utf8';
> GRANT ALL ON testdb.* TO 'tvb9ring'@'%' IDENTIFIED BY 'tvb9ring';
> GRANT ALL ON testdb.* TO 'tvb9ring'@'localhost' IDENTIFIED BY 'tvb9ring';
> FLUSH PRIVILEGES;
exit
exit