How to connect to database (phpMyAdmin, phpPgAdmin, adminer)

Mainly 3 tools are used for database management, phpMyAdmin, phpPgAdmin and adminer. We will show you how to connect to the database using these two tools.

1. Database data

If you do not know the login data for the database, it is possible to find them, for example, from your application or from the administration of hosting services admin.hukot.net​

In the administration of hosting services in the left panel, select Databases.
For the required database in the Server column, click on the column value.

A pop-up window will appear with information about the database.
Note: You need to find the password either in the application or have it generated if you do not know the password.

2. Connection to the database

Address for phpMyAdmin: https://mysql.hukot.net/
Address for adminer: https://mysql.hukot.net/adminer/
Address for phpPgAdmin: https://pgsql.hukot.net/

phpMyadmin
Name: is database name
Server: you select according to the value in the server column, this is host information, for example: host: db80

adminer
Server: you select according to the value in the server column, this is host information, for example: host: db80
Uživatel: is database name
Databáze: is the name of the database, but does not need to be filled out.

phpPgAdmin
In the left panel, select eam.securitynet.cz or vix.securitynet.cz according to the value in the server column
User name: is database name

3. Connection in the application

To connect to the database in the application, set according to the following template:

Server: you select according to the value in the server column, the guest value, for example: db80
Username: is the name of the database
Database Name: is the name of the database

Example in PHP:

$mysqli = new mysqli('db80', 'databasename', 'databasepassword', 'databasename');