一般另外一條記錄的host為%

我本打算在我的伺服器執行一下，把結果給你看，但是我的伺服器上已經沒用了遠端root使用者，我執行的過程如下：

E:\mysql5.0.51a\bin>mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 41

Server version: 5.0.51a-community-log MySQL Community Edition (GPL)

Type "help;" or "\h" for help. Type "\c" to clear the buffer.

mysql> use mysql

Database changed

mysql> select host,user from user where user="root";

+-----------+------+

| host | user |

+-----------+------+

| 127.0.0.1 | root |

| localhost | root |

+-----------+------+

2 rows in set (0.02 sec)

delete from user where user="root" and host!="localhost";