How do I connect to a database from another server?

[chris8lunch]

Don't I replace 'localhost' with the other server IP address?

 

[jayh38]

Yes, and you will probably need to setup an access host on the remote database
to allow connections from outside it its own "localhost" either in the cpanel of the
account you are connecting or directly from phpmyadmin or any other way you
edit your user and permissions.

 

[ajitharavindan]

QUOTE=jayh38;275701]Yes, and you will probably need to setup an access host on the remote database
to allow connections from outside it its own "localhost" either in the cpanel of the
account you are connecting or directly from phpmyadmin or any other way you
edit your user and permissions.[/QUOTE]



how to setup a connection to the remote database..
what is the format...
for example...
i have created a database with the name CatchQatar and our domain name is www.catchqatar.com
how can we specify it in the java connection string

 

[nabuhonodozor]

afaik, You ll have to permit external acces to this database in the cPanel (mysql section)
Database should be then accessible on port # 3306 (www.catchqatar.com:3306)
If You have installed firewall on your server (apf or CSF) You will also have to open this port in firewall.
salam allaikum & regards,
piotr