高分求教：MySql 4.0.18远程连接的问题

[zhourongbiao]

我使用默认的root和空白密码可以远程登录上（在dos下使用mysql.exe)，可是哪怕只要在phpMyAdmin中更改root为root1都无法登录!添加用户使用：
grant all on db_name.* to 'test'@'%' identified by '111'后使用test的用户名也还是无法登录，怎么回事？我不能总用root＋空白密码登录吧？

[loveflea]

是不是你授权没有成功，建议你在本机上用mysql.exe添加一授权用户，看看有没有什么问题
如：

C:\Documents and Settings\Administrator>mysql -hfirewall -uroot -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.18-nt

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

mysql> grant all on test.* to 'test'@'%' identified by '111';
Query OK, 0 rows affected (0.03 sec)

mysql> exit
Bye

C:\Documents and Settings\Administrator>mysql -hfirewall -utest -p
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.18-nt

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

mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)

mysql> exit
Bye

[zhourongbiao]

谢谢，偶还犯了错误呵呵用phpMyAdmin改用户名后应该FLUSH PRIVILEGES;

[shuixin13]

grant all on db_name.* to test@"%" identified by '111'