Connect to MySQL and PostgreSQL

Create connection

The current version of Datazenit is able to connect to MySQL and PostgreSQL databases. Support for other relational databases is planned in the future.

Datazenit is able to connect to local and remote database connections, however keep in mind that for remote connections you will need to open necessary ports in your database server's firewall configuration, e.g., port 3306 for MySQL.

To improve performance and reduce latency it is recommended to host Datazenit on the same server as the database itself.

Create new connection

Once Datazenit is up and running, and you have logged in for the first time, a new connection form will be opened right away. Otherwise there is always a "+" button in the connection bar which will open a new connection form.

Create new connection screenshot

Click screenshot to zoom in.

Hostname, username, password and port are the connection parameters for that specific database connection. The default port is pre-filled for MySQL and PostgreSQL. Default database field is required for PostgreSQL and recommended for MySQL. The default database is used to connect and query meta information about the connection and databases. It will also be opened by default when activating the connection.

Title field is used to identify the database connection across the system. It also is showed in the connection bar.

Next: Create new database