I'm running v 4.0.22 on Win XP 2003 Server with a client running XP Pro.
I have mysql running on 192.168.0.8 and I want to administer it from 192.168.0.202 (aka SALES). While on 192.168.0.8 running mysql, I issued the following commands: mysql> GRANT ALL ON *.* TO 'root'@'192.168.0.22'; Query OK, 0 rows affected (0.02 sec) mysql> GRANT ALL ON *.* TO 'root'@'192.168.0.202'; Query OK, 0 rows affected (0.01 sec) mysql> GRANT ALL ON *.* TO 'root'@'SALES'; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.49 sec) mysql> SET PASSWORD FOR 'root'@'SALES' = PASSWORD('xyzabc'); Query OK, 0 rows affected (0.12 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.01 sec) mysql> GRANT ALL ON *.* TO 'root'@'SALES'; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.09 sec) mysql> exit Bye However, I still get "Error 1045: Access denied for user: '[EMAIL PROTECTED]' (using password:YES) when using the command Mysql -u root -p -h 192.168.0.8 What am I doing wrong? Incidentally, this is an internal network so there is no firewall. Thanks! Siegfried