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.

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.

Thank for the reply. could you show me how to use query to do it?

Hai, I use datagridview to display all the data from database. There is a field named userlevel in the database. The value stored in the database is '1', '2' and so on. So, when display in the datagridview, can it change the '1' to admin and '2'to power user and so on. Thank in advance.