mysql指定ip访问

GRANT ALL PRIVILEGES ON *.* TO ‘root’@’localhost’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’192.168.1.204’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
flush privileges;

select * from user;

如果是更新
update user set host =’192.168.1.2′ where user = ‘root’ and Host=’localhost’;

发表评论