msyql 授权ip

使用myuser/mypassword从ip为61.129.51.8的主机连接到mysql服务器:
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'61.129.0.0' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 
FLUSH PRIVILEGES;

posted @ 2014-01-13 12:20  code_life  阅读(121)  评论(0编辑  收藏  举报