docker/podman安装mysql8并远程连接(阿里云服务器)----简单

docker/podman安装mysql8并远程连接(阿里云服务器：centos8)–简单

1. 打开服务器防火墙端口:3306

docker run -itd --name mysql8 -p 3306:3306 -e MYSQL_ROOT_PASSWORD=835677 mysql:8.0

3. 配置mysql8

 1. docker exec -it mysql8 bash
 2. mysql -u root -p
 3. use mysql;
 4. grant all privileges on *.* to 'root'@'%';
 5. flush privileges;
 6. ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';

完成以上即可。