授权法:
从任何主机连接到mysql服务器。
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
允许用户myuser 从ip为192.168.0.28的主机连接到mysql服务器,并使用password作为密码
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.0.28' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
//修改立即生效
flush privileges;
在安装mysql的机器上运行:
1、d:\mysql\bin\>mysql -h localhost -u root
2、mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION
//赋予任何主机访问数据的权限
3、mysql>FLUSH PRIVILEGES ;//修改生效
4、mysql>EXIT;
分享到:
2010-12-08 17:16
浏览 6496
分类:数据库
评论