mysql授权指定ip远程登录

use user

//更新用户表：

UPDATE `user` SET `Host` = '175.6.6.230' where `Host` = '175.6.6.230';

//授权用户表：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'175.6.6.230' IDENTIFIED BY 'gudanboke' WITH GRANT OPTION;

//强制刷新

flush privileges;