Databases on Managed Servers

Last change on 2021-12-02 • Created on 2020-01-20 • ID: KO-EB55A

In this area, you can construct databases; you can attach a database to a specific account, your you can leave it unattached to an account.

You can also click on the life-ring icon to restore a backup.

MariaDB/MySQL

How to create a new MariaDB/MySQL database

  1. Click on 'Add'.
  2. Select a name for the database and a name for the respective database user.
  3. On the following page, you will see the recommended (random) access details for your database. If you prefer, you can provide your own password.
  4. The main password is the most important one. It provides access to the entire database and allows you to create, change, or delete database information, columns, or rows.
  5. The R/W (Read/Write) password only gives the user read/write access. This is mostly used by CMS (content management systems) to add or change information in the database.
  6. The R/O (Read Only) password only allows the user to read information from the database; the user cannot change information with this password.
  7. Click on 'Save' to create the database.
  8. You should see a message that the database was successfully created. Click on 'Back' to return to the database list.

Tip: If you get an error message while you are creating the database, try to change the database name and/or username.

Manage your database(s)

After you have created a database, you will see that three new links appear at the top of the page: 'Edit', 'Delete' and 'phpMyAdmin'.

Clicking on 'Edit' allows you to change the passwords for the database, and 'Delete' removes the database. If you would like to delete a database, konsoleH will ask you to confirm that you want to delete it. Be careful when you confirm the deletion; you cannot un-do it.

What is phpMyAdmin?

phpMyAdmin is a graphic database administrations tool for MariaDB/MySQL.

Using the interface you can add, edit, and delete information easily.

For more information about phpMyAdmin, please visit the official website http://www.phpmyadmin.net/

PostgreSQL

How to create a new PostgreSQL database

  1. Click on 'Add'.
  2. On the following page, you will see the recommended (random) access details for your database. You can change these if you want to.
  3. Click on 'Save' to create your database.
  4. You should see a message that the database was successfully created. Click on 'Back' to return to the database list.

Manage your database(s)

After you have created a database, you will see that two new links appear at the top of the page: 'Edit' and 'Delete'.

Clicking on 'Edit' allows you to change the passwords for the database, and 'Delete' removes the database. If you would like to delete a database, konsoleH will ask you to confirm that you want to delete it. Be careful when you confirm the deletion; you cannot un-do it.

Is there also phpMyAdmin for PostgreSQL?

phpMyAdmin is written for MariaDB/MySQL and does not support PostgreSQL. However, there is a web-based application for PostgreSQL, which is very similar to phpMyAdmin. You can download it at http://phppgadmin.sourceforge.net/. Install the tool on your account and follow the operating instructions to manage your PostgreSQL databases.

Table of Contents