Kundencenter Datenbank mySQL/en

Aus EUserv Wiki

Version vom 10:20, 4. Okt. 2012

Languages:

Deutsch  • English

Creating my SQL databases

General

If you have an EUserv webspace, you have the option of using databases for your Homepage.

A database stores large amounts of data efficiently, consistent and durable. In addition, a database of the required subsets prepared in different, demand representation forms for each user and their applications programs.

Creating Database

In EUserv customer center, you have the option to create mySQL databases.

Select first from your webspace contract for which you want to create the mySQL databases.

Once you have selected your webspace contract, now click on the menu item "mySQL" under database.

Here you can set up your webspace mySQL databases. The overview "DB-Accounts" to itemize you on how many available tariff you have in your database, such as the quota is set and what your usage of these options ("Maximale Datenbankanzahl im Tarif, Maximale Datenbankgröße im Tarif, Datenbank-Quota max /set/used") By clicking on "Anlegen" under "Neue Datenbank" to open the corresponding menu.

Set up mySQL database

In this part of the EUserv customer center you can create the required MySQL database. Each MySQL database automatically gets a fixed, sequentially numbered "Datenbank-Namen" (e.g., db111111_11). Equivalent to the "Datenbank-Name", the "Admin-User" is generated by the system automatically. Again, this is consecutively numbered and can not be changed.

Under "Quota in MB" to set the size of your mySQL database. Pay attention with the fact that your MySQL database must possess a minimum size of 1 MB, and may not be exceed the Maximalquota.

In the two input fields below ("Passwort setzen:" und "Passwort erneut eingeben: ") you set your password and need to repeat this for your safety again. It is important to note that your password is at least 8, more than 16 characters long and must be provided with at least two uppercase letters, lowercase letters and numbers.

Clicking on "Speichern" to confirm your settings.

Editing/Deleting mySQL database

To change the options, click on the overview page "DB-Accounts" right next to the desired MySQL database on "Ändern". Now if you want to edit, save or manage your databases, you will use the feature "Datenbank-Webfrontend" under https://support.euserv.de/dbadmin. If do you want to delete a mySQL database again, just click "Löschen".