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;