Mysql network connection

[sang]

Hi
I am working in a Mysql and Java Platform. For my Project some computers are connected in network to share the files and etc. I want to access the mysql database through the network connection. Is it possible. If it is possible please give me the method to access the database.

Thanks and Regards,
Sang

[sang]

Hi
I am working in a Mysql and Java Platform. For my Project some computers are connected in network to share the files and etc. I want to access the mysql database through the network connection. Is it possible. If it is possible please give me the method to access the database.

Thanks and Regards,
Sang

I my Mysql prompt

mysql> GRANT ALL ON test.* TO root@'192.168.1 .70' IDENTIFIED BY 'PASSWORD';
Query OK

In the Command prompt

C:\Program Files\MySQL\MyS QL Server 5.0\bin>mysql -u root -h 192.168.1.70
ERROR 1130 (00000): Host 'my systemname' is not allowed to connect to this MySQL server

What can i do to solve the problem,please help ASAP b'coz it is very urgent.

For this issue i am not able to do further work so please help to solve it.

Thanks and regards,
Sang