ubuntu docker下搭建MySql

docker下搭建mysql

1、下载mysql镜像

sudo docker pull mysql:5.7

2、创建volumes

sudo docker volume create vol_mysql

3、查看volumes

docker volume ls

4、创建mysql容器

sudo docker run --name mysql -p 3306:3306 --mount source=vol_mysql,target=/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

5、连接shell

 docker exec -it mysql bash

参考：

https://hub.docker.com/r/_/mysql/?spm=5176.8351553.8577797.38.20f11991xAkDOH

mysql数据库创建

1、添加用户

• 本地用户

• create user 'test'@'localhost' identified by '123456';

• 外网用户

create user 'test'@'%' identified by '123456';

2、刷新授权

flush privileges;

3、创建数据库

create database test DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

4、对用户授权

grant all privileges on test.* to 'test'@'%' identified by '123456';

grant all privileges on test.* to 'test'@'localhost' identified by '123456';

5、刷新权限

flush privileges;