Connection parameters examples

PostgreSQL

host	db-host
port	5432
database	test
user	postgres
password	test
SQL test	`select * from test`

MySQL

host	db-host:3306
database	test
user	root
password	test
SQL test	`select * from test`

User account and accessed database must have the remote access enabled.

How Do I Grant Access To An Existing Database?

Let us assume that you are always making connection from remote IP called 202.54.10.20 for database called webdb for user webadmin, To grant access to this IP address type the following command At mysql> prompt for existing database, enter:
mysql> update db set Host='202.54.10.20' where Db='webdb';
mysql> update user set Host='202.54.10.20' where user='webadmin';

Oracle

host	db-host
port	1521
driver	V14_10_2_0_1
user	tester
password	test
SID	XE
SQL test	`select * from test`

MS SQL

host	db-host
port	1034
user	sa
password	test
database	test
SQL test	`select * from test`

You need an SQL account to access the MS SQL remotely.

Page tree

Connection parameters examples

PostgreSQL

MySQL

How Do I Grant Access To An Existing Database?

Oracle

MS SQL