mysql访问问题

1.如何使用本机IP登录mysql或者允许局域网其他主机登录。

mysql> select host ,user from user;
+-----------------------+------+
| host                  | user |
+-----------------------+------+
| 127.0.0.1             | root |
| localhost             |      |
| localhost             | root |
| localhost.localdomain |      |
| localhost.localdomain | root |
+-----------------------+------+
5 rows in set (0.00 sec)

mysql数据库下的user是管理登录信息的，这里面没有允许其他客户端使用本机IP登录，所以我的做法是：

 update user set host="%" where user="root";

这样就可以了。

mysql> select host,user from mysql.user; 
+-----------------------+------+
| host                  | user |
+-----------------------+------+
| %                     | root |
| 127.0.0.1             | root |
| localhost             |      |
| localhost.localdomain |      |
| localhost.localdomain | root |
+-----------------------+------+
5 rows in set (0.00 sec)