How do I connect to a database from another server?

jayh38

Well-Known Member
Mar 3, 2006
1,213
0
166
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

Registered
Jan 19, 2008
3
0
51
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:confused::confused:
 

nabuhonodozor

Member
Jun 22, 2007
23
0
51
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