xampp - connecting to a local database from another local ma

[jayapalchandran]

Hi, I am using XAMPP to create php projects. My system is: name=con7 and local ip=192.168.1.20 Another system is: name=con12 and local ip=19.168.1.10

I want to connect to a database in con12 from con7.

I read that we need to provide access permission for the host(ip) which is trying to connect from a different machine like the Access Host in cPanel->databases (the control panel for linux hostings).

I have access to that system as that person(con7) does the data entry and me the manipulation. some thing like that.

So how to do this?

[JonB]

Presumably, its a MySQL issue (you didn't say what database), if so:

If you intend to directly input the data from the remote computer (make a remote connection), you will need to use phpMyAdmin and GRANT PRIVILEGES on the relevant database(or tables) to a USER that are not limited to localhost. You can either create a MySQL statement to do it, or use the Priviliges tab. You can use a hostname (or IP as a hostname) or use the wildcard '%'.

As this is an important security aspect of MySQL, I suggest you invest some time in the documentation.

http://dev.mysql.com/doc/refman/5.1/en/grant.html

although this is for *nix, this is a good primer:
http://www.cyberciti.biz/tips/how-do-i- ... erver.html

The best thing to do would be learn the MySQL syntax, as it will make your programming intuitive.

Good luck with our project.