安装
$ docker run --name mysql01 -e MYSQL_ROOT_PASSWORD=123 -p 3306:3306 -d mysql
报错:
Client does not support authentication protocol
(1)容器中登录mysql,进入mysql>命令行
1、docker exec -it mysql01 bash //mysql01是mysql容器的别名
2、mysql -uroot -p //-uroot
3、输入密码:123
(2)
$ ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';
$ ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
$ SELECT plugin FROM mysql.user WHERE User = 'root';