connect database server from other computer in network

[peterjc]

I am building a VB.Net system using MySql database from XAMPP. The problem is, i try to run the system from other computer and change the localhost to 10.0.0.15 because the 10.0.0.15 is the ip for the computer running the database. But, i get the error message "Unable to connect to any of the specified MySQL hosts" I do a lot of searching and i find that i need to add privilage to mysql. But i try many time and still fail. I not really sure how to add it. I am really new to it. I am using phpmyadmin running windows xp. So, example computer A has the mysql server install(using XAMPP) and the ip adress is 10.0.0.15. On the other hand, i install the system on computer B(IP = 10.0.0.20) and want to run the system from computer B but access the database at computer A. So, what is the thing that i need to do? Could someone tell me what i need to add at the privileges and at the connection string, what i need to put at the 'Server' for the connection string? Example connection string: server=localhost; user id=root; password=; database=cegms; Thank.

[Hesbon Ongira]

Shouldn't the server be 10.0.0.15 instead of localhost? Eliminate all the LAN issues if any and enable the port 3306. When you are trying out the connection, is the Mysql service running or not?

--------------------------- Both optimists and pessimists are important in technology. The optimist invented the aeroplane; the pessimist invented the parachute. Regards, Hesbon Ongira Nairobi, Kenya.

[peterjc]

I already change the localhost to 10.0.0.15 actually. I think the problem is on mysql. I am using phpmyadmin. Could you tell me how to enable the port 3306? And any other thing that i need to configure? I also do some searching and found need to "grant access to remote IP address" but i does not know how to do it! I am really new and never configure the mysql, so any detail explain of the step is appreciated. Thank you.