By default, all Datasources of a given type share the same port on the client side. This port is normally the default port for that Datasource type (e.g., port
3306 for MySQL or port
5432 for Postgres) but it auto-increments if the port is already taken on the client. In order to connect to a different Datasource of the same type, the user has to disconnect from the first Datasource and connect to the second. If they have to connect to multiple Datasources of the same type simultaneously, however, there are two possible methods that users can try: Port Overrides and [/user-guide/connect-to-resources/ad-hoc-ports](Ad Hoc Ports). This document describes the Port Overrides method.
SSH servers are automatically assigned their own persistent ports and do not use Ad Hoc ports or Port Overrides.
Port Overrides is enabled by default. If, however, you already had Port Overrides turned off, you have the option to turn them on in the Admin UI, in section Settings > Port Overrides.
Enabling Port Overrides will interrupt and sever any active Datasource and Server connections.
Port Overrides ensures that users automatically have ports assigned for each Datasource and can connect to as many as they like at any time.