centos7 docker 安装mysql 并开启远程 访问

1. docker 中下载 mysql

docker pull mysql

2. 启动

docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=Lzslov123! -d mysql

3. 进入容器

docker exec -it mysql bash

4. 登录mysql

mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Lzslov123!';

5. 添加远程登录用户

CREATE USER 'zxh'@'%' IDENTIFIED WITH mysql_native_password BY 'laL@hell';

GRANT ALL PRIVILEGES ON . TO 'zxh'@'%';

6. 使用Navicat测试远程连接