Hosts use port numbers to determine to which application, service, or process a connection must be established. Port: A number that identifies a connection point between hosts. For example, in MySQL you can run SHOW GRANTS. Run a query in a database command line to see names of all available databases.
User: A name of a user that has sufficient privileges to perform actions with a database. For example, in MySQL you can run SHOW DATABASES. In some cases, it is possible to run a query in a database command line to see names of all available databases. You can find the database name in the settings of your database server, or you can ask your database administrator.
It can be an IP address 127.0.0.1 or a domain name localhost.ĭatabase: A name of the database to which you want to connect. Host: A hostname of a computer or other device that stores a database. Most database include the connection settings: Check your connection propertiesĮach database (MySQL, PostgreSQL, Oracle, or any other vendor) has its own connection settings. The telnet command allows you to check if the port is opened for communication. For security reasons, DBMS usually drops all telnet connections.
