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;
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;