创建流程
1.下载mysql镜像
docker pull mysql:8.0.31
2.创建容器
docker run --name=mysql_container
-p 8080:3306
-v /home/mysql/conf:/etc/mysql/conf.d
-v /home/mysql/data:/var/lib/mysql
-e MYSQL_ROOT_PASSWORD=123456
-d mysql:8.0.31
--character-set-server=utf8mb4
--collation-server=utf8mb4_unicode_ci
docker run --name=mysql_container -p 8080:3306 -v /home/mysql/conf:/etc/mysql/conf.d -v /home/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:8.0.31 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
3.进入mysql容器
docker exec -it mysql_container bash
4.登录mysql
mysql -u root -p
# Enter password:123456
5.登录成功,操作数据库
show databases;
create database test;
# 修改远程登录的权限
alter user 'root'@'%' identified with mysql_native_password BY '123456';
# 更新缓存
FLUSH PRIVILEGES;
6.退出mysql联接
\q