MySQL-Datenbank für Ihre Website

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

The database is meant to be used in conjunction with a site in our serviced web hosting. Access is limited to the webserver, our phpMyAdmin site, and the access servers. If you need a database for other purposes 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 specifications

Our databases are adjusted 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 the database password

Unlike the password to your functional account, your database password is not managed via the LRZ IDM portal, but handled at the respective database server. The database password is not the same as your functional account's password, and should be be different for security reasons.

If you want to change your database password, you can do so with phpMyAdmin. Log in to phpMyAdmin as described under "Managing your database". Select the “SQL” tab and run the following query, of course with your new, very good password instead of secret inside the quotes.

SET password='secret'