Hetzner - DokuWiki

KonsoleH:Datenbanken (Managed Server)/en

Inhaltsverzeichnis

Databases

In this area you can construct databases which are not to be attached to any particular account.

MySQL

How to create a new MySQL database:

  1. Click on 'Add'.
  2. Select a name for the database as well as 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 wish you can provide your own password.
  4. The main password is the most important as 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 gives you read/write access only. This is mostly used by CMS (Content Management Systems) to add or change information in the database.
  6. The R/O (Read Only) password allows the user to read information from the database only; information cannot be changed with this password.
  7. Click on 'Save' to create the database.
  8. A success message will appear. Click on 'Back' to return to the database list.

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

Manage your database(s).

When 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 require confirmation before finally deleting it. Be careful when you confirm the instruction, as this cannot be reversed.

What is phpMyAdmin?

phpMyAdmin is a graphic database administrations tool for MySQL.

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

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

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. If you wish, these can be changed.
  3. Click on 'Save' to create your database.
  4. A success message will appear. Click on 'Back' to return to the database list.

Manage your database(s).

When 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 require confirmation before finally deleting it. Be careful when you confirm the instruction, as this cannot be reversed.

Is there also phpMyAdmin for PostgreSQL?

phpMyAdmin is written for MySQL and does not support PostgreSQL. There is a web-based application for PostgreSQL, however, which is very similar to phpMyAdmin. This can be downloaded at http://phppgadmin.sourceforge.net/. Install the tool on your account and follow the operating instructions to manage your PostgreSQL databases.



© 2018. Hetzner Online GmbH. Alle Rechte vorbehalten.