1.拉取mysql8镜像(指定具体版本)
docker pull mysql:8.0.25
2.查看镜像
docker images
3.使用镜像mysql:8.0.25创建容器,指定端口,root用户初始密码
docker run -itd —name mysql8 -p13306:3306 -e MYSQLROOT_PASSWORD=123456 mysql:8.0.25 —lower_case_table_names=1
4.查看运行的容器
docker ps
5.进入容器
docker exec -it 容器id bash
6.连接mysql数据库并切换到mysql数据库
mysql -uroot -p123456
use mysql;
7.创建用户
create user ‘vuls’@’%’ identified by ‘123456AAaa’;
8.给创建好的用户赋予远程登录权限
grant all on ._ to ‘vuls’@’%’ with grant option;
9.刷新权限
flush privileges;
10.mysql8跟之前版本加密方式不一样,如果需要navcat客户端能正常连接则需要进行一下步骤
mysql>alter user ‘vuls’@’%’ identified by ‘123456AAaa’ password expire never;
msyql>alter user ‘vuls’@’%’ identified with mysql_native_password by ‘123456AAaa’;
mysql>flush privileges;