mysql 授权ip登陆
# 授权所有,youpassword为登录密码 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION; # 指定IP GRANT ALL PRIVILEGES ON *.* TO 'root'@'171.111.8.130' IDENTIFIED BY 'youpassword' WITH GRANT OPTION; # 如果失败删除后重新授权 delete from user where host = '171.111.8.130' and user = 'root'; # 保存配置 flush privileges;
本文来自博客园, 作者:Star-Hitian, 转载请注明原文链接:https://www.cnblogs.com/Star-Haitian/p/15155522.html