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
