1.进入容器

docker exec -it [msyql容器id] bash

2.登录mysql

msyql -uroot -p123456

3.创建用户并授权

CRETETE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'127.0.0.1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
# 查看所有用户
SELECT User, Host FROM mysql.user;