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;