Mysql(5):Docker下修改mysql5的密码
1、#进入docker里面
#docker exec -it “id” bash
docker exec -it af35448d73cd bash
![](https://img-blog.csdnimg.cn/img_convert/4c37070bf7807513b653385353b21897.png)
2、#登录mysql
mysql -u root -p
![](https://img-blog.csdnimg.cn/img_convert/2195f4b8ea9d11c724ec85ee83c9c0ec.png)
3、#创建用户:
CREATE USER 'hmf'@'%' IDENTIFIED BY '123456';
![](https://img-blog.csdnimg.cn/img_convert/2a18b8f6302ec842fa37ffb9f4a23fce.png)
4、#授权:
GRANT ALL ON *.* TO 'hmf'@'%';
![](https://img-blog.csdnimg.cn/img_convert/f87911a74c1ab14ce8191c39277c4ec3.png)
5、#查询用户:
select user,host from mysql.user;
![](https://img-blog.csdnimg.cn/img_convert/59d49704f567d60a588178db7f35a39c.png)
新建用户的访问:
![](https://img-blog.csdnimg.cn/img_convert/c9b62e8b2e73c45692c561734ee415da.png)