DOCKER安装Mysql

1.docker启动mysql

docker run -d \
-p 3306:3306 \
--restart=always \
--name mysql \
-v /docker/mysql/log:/root/logs \
-v /docker/mysql/data:/root/data \
-v /docker/mysql/conf:/root/conf \
-e MYSQL_ROOT_PASSWORD=123456 \
-e TZ=Asia/shanghai \
mysql:5.7

2.设置新用户

1.进入容器

docker exec -it mysql bash

2.登录mysql

mysql -u root -p

3.新建用户

create user 'admin' identified with mysql_native_password by '123456';
# mysql_native_password 
# 密码加密方式为mysql_native_password
# admin新用户  密码为123456

4.添加权限

grant all privileges on *.* to 'admin';

5.刷新权限

flush privileges;

外部连接mysql提示客户端不支持服务器请求的身份验证协议；考虑升级MySQL客户端