Mysql设置只允许Ip远程连接

1.切换至mysql -》 use mysql;

2.设置

GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.60' IDENTIFIED BY 'csdn' WITH GRANT OPTION;
flush privileges;

例：设置root用户只允许IP为127.0.0.60用csdn这密码远程连接

3.检查

select user,passwored ,host from user 即可看到设置结果