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;
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/15837.html
