Configure external access

External access can be granted on a per database and database user level.
By default Sock adds the FQDN and IP addresses of the server that is associated with the database as a hostname.
When this server is part of a clustered setup Sock will also include their FQDNs and IP addresses.

Each hostname will create a grant for that user to access the database from that source.
This will also create a firewall rule to allow access for that hostname on the database server(s).

---

To provide external access to a database navigate to the account or virtual server it is linked to,
and select Details in the Database widget for the respective database.

Add the required Hostname to the database user(s) in the Database logins section.
The following content is allowed for the Hostname fields:

The hostname of a server
A single IP address
A range of IP addresses in subnet mask notation (eg. 172.16.0.0/255.240.0.0) or CIDR notation (e.g. 172.16.0.0/12)

Confirm the changes via Update Database.