docker-compose.yml文件
version: ‘3‘ services: wordpress: image: wordpress ports: - 8080:80 environment: WORDPRESS_DB_HOST: mysql WORDPRESS_DB_PASSWORD: root networks: - my-bridge mysql: image: mysql environment: MYSQL_ROOT_PASSWORD: root MYSQL_DATABASE: wordpress volumes: - mysql-data:/var/lib/mysql networks: - my-bridge volumes: mysql-data: networks: my-bridge: driver: bridge
docker-compose up
#进入mysql容器 docker-compose exec mysql bash #登陆数据库 mysql -u root -p use mysql; #开启root远程访问权限 grant all on *.* to ‘root‘@‘%‘; #修改加密规则 alter user ‘root‘@‘localhost‘ identified by ‘123456‘ password expire never; #更新密码 alter user ‘root‘@‘%‘ identified with mysql_native_password by ‘123456‘; #刷新权限 flush privileges;
再次浏览器打开就可以了
原文：https://www.cnblogs.com/soymilk2019/p/11584201.html