MySQL权限问题

数据库被黑了，淦

查看MySQL的访问IP权限

# 进入mysql
docker exec -it mysql /bin/bash
mysql -u root -p

# 设置本地IP才可以访问127.0.0.1改为本地公网IP
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'root'

# 刷新权限
flush privileges;

exit

docker restart mysql