使用grant all(访问权限) on 数据库名.表名 to 账号@localhost identified by "设置的密码";
给 192.168.0.1 主机上的用户 username 赋予权限 mysql -u root mysql mysql> INSERT INTO user (Host,User,Password) VALUES('192.168.0.1','username',password('password')); mysql> FLUSH PRIVILEGES;给所有主机上的用户 username 赋予权限 mysql -u root mysql mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',password('password')); mysql> FLUSH PRIVILEGES;
http://www.csdn.net/expert/topic/1029/1029509.xml?temp=.5241968
注意+---------------+-------+
| Host | User |
+---------------+-------+
| localhost | root |
| 192.168.0.% | root |
+---------------+-------+给加上密码吧
顶多进他自己的库.有密码也没有用.
mysql -u root mysql
mysql> INSERT INTO user (Host,User,Password) VALUES('192.168.0.1','username',password('password'));
mysql> FLUSH PRIVILEGES;给所有主机上的用户 username 赋予权限
mysql -u root mysql
mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',password('password'));
mysql> FLUSH PRIVILEGES;
------------------------------------
可以结贴了!