日期:2014-05-16  浏览次数:20639 次

is not allowed to connect to this MySQL server 问题??
授权
---------------
mysql>   select   host,user   from   user;
+-------------+----------+
|   host                 |   user           |
+-------------+----------+
|   %                       |   root           |
|   localhost       |   ezmlm         |
|   localhost       |   vpopmail   |
|   qmailserver   |                     |
+-------------+----------+
4   rows   in   set   (0.00   sec)

mysql>   GRANT   ALL   PRIVILEGES   ON   *.*   TO   'root '@ '% '   IDENTIFIED   BY   'xxxxxxxx ';
Query   OK,   0   rows   affected   (0.01   sec)

mysql>


连接mysql
---------------------
C:\Documents   and   Settings\Administrator> mysql   -h   192.168.1.88   -u   root   -p
Enter   password:   *******
ERROR   1130   (00000):   Host   '192.168.0.174 '   is   not   allowed   to   connect   to   this   MySQL   server

C:\Documents   and   Settings\Administrator>


为什么还报is   not   allowed   to   connect   to   this   MySQL   server???

------解决方案--------------------
1.密码正确不?
2。flush privileges;