1. docker进行拉取和启动

docker run -d \
--name mysql \
--restart=always \
-p 13306:3306 \
-e MYSQL_ROOT_PASSWORD=123456 \
mysql:latest

2. 进入docker里面

3.创建一个账号并设置密码

create user 'jebf'@'%' identified with mysql_native_password by 'sLjjeZLYvSkteRVC';

4.设置 ‘root’@‘%’ 的密码永不过期,密码为sLjjeZLYvSkteRVC

ALTER USER 'jebf'@'%' IDENTIFIED BY 'sLjjeZLYvSkteRVC' PASSWORD EXPIRE NEVER;

5.这里为刚才创建的yaku@% 用户授予所有数据库的所有表的所有操作访问权限

grant all privileges on *.* to 'jebf'@'%' with grant option;

6. 刷新权限

flush privileges;