# 下载镜像
docker pull mysql:8.0
# 启动容器(注意:mysql8.0 需要在初始化时设置lower_case_table_names配置大小写不敏感)
docker run --name mysql8.0 -p 3308:3306 -e MYSQL\_ROOT\_PASSWORD=123456 -d mysql/mysql-server:8.0 --lower_case_table_names=1
# 进入容器
docker exec -it mysql8.0 bash
# 登录数据库(这里默认数据库密码为123456)
mysql -uroot -p123456
# 授权远程
mysql>use mysql;
mysql>update user set host = '%' where user = 'root' and host='localhost';mysql>flush privileges;mysql>GRANT ALL ON *.* TO 'root'@'%' ;mysql>flush privileges;
# 修改加密方式
mysql>ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
mysql>flush privileges;