As a customer to our serviced web hosting service, you have the option to receive a MySQL database for use with your website.

If you need a database for other purposes than the serviced web hosting, you will have to set it up yourself. Please refer to the information for the managed server service on how to do this.

How to receive a database

There are two options for receiving a MySQL database:

  1. Apply for a database directly along with your request for a new website.
  2. If you need a database, but forgot to ask for it when you initially applied for your website, you may send us a message via the LRZ servicedesk. Please make sure to adhere to our regulations concerning changes to a website before opening an incident with the servicedesk.

The database name will consist of the name of the functional account and the suffix db1. Example: xy99xyzdb1. (Databases created prior to March 2020 may following different naming conventions.)

When configuring your web application, you will need the following information:

  • server name and server port of the MySQL database server
  • functional account
  • database password

You will receive all relevant information for accessing your database by email.

Technical specification

Our databases are optimised for use with web applications. This means:

  • Your database should not exceed 100-200 MB in size. Our database infrastructure is not built to handle amounts of data bigger than that.
  • For security reasons, your database will only be available from within our web hosting infrastructure. This includes the phpMyAdmin server and the access servers (see the section "Managing your database").

Managing your database

You can manage your database via phpMyAdmin, which offers a web-based graphical interface to edit MySQL databases that you can access with your web browser. After clicking the link, choose the MySQL database server from the drop-down menu (you will have received the database server's name in the initial email sent to you). Log in with your functional account and the database password. (Our initial email will contain instructions on how to find your database password.)

Attention

The database password is not connected to your functional account and does not share the same password! See below for more information on this.

After successful login, you may change the database password, import and export data etc.

You may also access your database via the command-line as an alternative to phpMyAdmin (see Access options for more information on this).

Changing your database password

While the password to your functional account is managed via the LRZ IDM portal, your database password is not: Instead, the password to your database is handled locally by the respective database server. This also means that your database password is not the same as your functional account's password, and we ask you to use different passwords for the two use cases.

If you would like to change your database password, you can do so with phpMyAdmin. Log in to phpMyAdmin as described under "Managing your database" and find the area "General settings" where you should be able to click on a link called "Change password".

Unfortunately, it is currently not possible to change the database password in the way described above. Until we can resolve the problem, you can change your password as follows:

In the "SQL" tab, enter the following in the "SQL command(s) ..." field (replace the word "secret" with your desired new password):

SET password='secret'

  • No labels