如何授权？100分
Host '192.168.1.250' is not allowed to connect to this MySQL server；
我如何在数据库服务器上给 192.168.1.250 授权访问？
问题点数：100、回复次数：5Top
1 楼hnsyf（鱼片儿）回复于 2002-12-09 11:52:29 得分 20
使用grant语句,参考http://expert.csdn.net/Expert/topic/1127/1127388.xml?temp=.7941095Top
2 楼bombshell（水中鱼）回复于 2002-12-09 13:04:15 得分 40
GRANT ALL ON *.* TO username@192.168.1.250 IDENTIFIED BY "password"
或者：
GRANT ALL ON *.* TO username@192.168.1.% IDENTIFIED BY "password"
username是用户名
password是该用户的密码Top
3 楼shuixin13（犬犬（心帆））回复于 2002-12-09 14:23:44 得分 40
再给你一个SQL操作的方法
INSERT INTO user VALUES("192.168.1.250", "username", PASSWORD("123"), "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y");
#添加用户
FLUSH PRIVILEGES;
#刷新权限表,Top
4 楼puyinghua（不尔）回复于 2002-12-09 16:57:12 得分 0
自己搜索一下"权限" shuixin13有关于权根的贴子, :) 很全的Top
5 楼tntxhy（落日使者）回复于 2002-12-09 22:27:24 得分 0
phpmyadmin也可以，比较简单直观。Top
