1、进入容器:
[root@localhost ~]#
docker exec -it 容器id bash
2、进入mysql:
root@324234:/#
mysql -uroot -p
3、输入密码,进入到mysql界面:
4、查看密码加密规则
select host,user,plugin,authentication_string from mysql.user;
4、对远程连接进行授权:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
5、更改密码的加密规则:
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
7、刷新权限:
mysql>
flush privileges;
8、使用客户端测试;