进入docker
docker exec -it mysql8.0 bash
进入mysql
mysql -uroot -p
use mysql
添加用户并设置密码
create user '用户名'@'%' identified by '密码';
添加用户权限
grant all privileges on *.* to '用户名'@'%' ;
查看用户
select user,host from mysql.user;
修改用户权限
update user set host = '要修改的权限' where user='用户名' and host='当前权限';
删除用户
DROP USER '用户名'@'权限';
刷新权限
flush privileges;