A port is a number that has been assigned to identify a connection endpoint individually and to direct data to a particular service. In other words, when a message from the internet or another network enters a server, a port number can be used to specify the precise process to which the message should be delivered.
The list of default ports that various SQL databases or data stores use is as follows.
Sl | Database Name | Default Port |
1 | Oracle SQL*Plus | 1521, 1830 |
2 | Postgres | 5432 |
3 | MySQL | 3306 |
4 | SQL Server | 1433, 1434 |
5 | MaxDB | 7210 |
6 | MariaDB | 3306 |
7 | DB2 | 446 |
8 | Ingres | 117 |
9 | Teradata | 1025 |
10 | DynamoDB | 8000 |
11 | Amazon Aurora MySQL | 3306 |
12 | Amazon Aurora PostgreSQL | 5432 |
13 | Azure SQL | 1433 |
14 | SQLite | None |