docker 容器下安装 mysql 8.0.21
1.下载mysql容器镜像 docker pull mysql:8.0.21 (具体见docker hub地址 https://hub.docker.com/_/mysql?tab=tags)
2.docker run -itd --name mysql-test -p 33306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql (运行容器 将3306端口映射到33306端口,不需要映射端口的话都填3306就好了 )
3.docker ps 查看容器是否安装成功
4.docker exec -it 容器名 bash 进入容器
5.mysql -h localhost -u root -p 访问mysql库
6.修改加密方式(mysql8.0加密方式和5.6版本不一致,需要先切换加密方式)
ALTER USER ‘root’@’%’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘password’;
- 授予root远程登录权限
select host,user from user where user=‘root’;
update user set host=’%’ where user = ‘root’;
flush privileges;