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 即可看到设置结果
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 即可看到设置结果