返回文章列表
Mysql授权某个IP访问
工具
# 查看
SELECT host, user FROM mysql.user WHERE host = '192.168.1.5';
# 授权登录
CREATE USER 'username'@'192.168.1.5' IDENTIFIED BY 'password';
# 授权数据库
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'192.168.1.5';
# 刷新
FLUSH PRIVILEGES;