• Sonntag, Septembre 21, 2025

Managing databases and their associated users is a fundamental aspect of maintaining any web application or service. This guide provides a clear, step-by-step approach to performing these crucial tasks efficiently within your control panel, ensuring both functionality and security.

Managing Databases

Efficient database management involves both the creation of new databases and the secure deletion of existing ones. These processes are essential for organizing your data and maintaining a clean server environment.

Creating a Database

Creating a new database is a straightforward process within the control panel. Follow these steps to set up your database:

  1. Log in to your control panel interface.
  2. Navigate to the left sidebar and click on Databases. This action will display the Databases management page.
  3. On the Databases page, click the Add Database button. A new page, "Add a Database," will then be presented.
  4. Enter your desired database name into the Database name text box. Choose a descriptive name that reflects its purpose.
  5. From the Database server dropdown list, select the specific type of database you intend to create (e.g., MySQL, PostgreSQL).
  6. In the Related site dropdown list, choose the website you wish to associate with this new database. You may also accept the default selection if it's appropriate.
  7. To establish a dedicated user for this database, locate the Users section and mark the Create a database user checkbox. This is a recommended security practice.
  8. Provide a unique username for the database in the Database user name field.
  9. Input a strong password for this database user in both the New password and Confirm password text boxes. Ensure the passwords match for confirmation.
  10. Finalize the process by clicking OK. Your new database and its associated user (if created) will now be set up.

Deleting a Database

When a database is no longer needed, you can remove it using the following procedure. Exercise caution, as this action is irreversible and will delete all associated data.

  1. Access your control panel.
  2. In the left sidebar, click on Databases to view your existing databases.
  3. Locate the database you wish to remove. Within its designated section, click the Remove Database option.
  4. A confirmation prompt will appear. Click Yes to proceed with the permanent deletion of the database.

Managing Database Users

Controlling who can access your databases and what permissions they have is vital for security. This section details how to add new users and manage their privileges effectively.

Adding a User to a Database

Assigning specific users to databases is essential for managing access and permissions. Here’s how to add a new database user:

  1. Log in to your control panel.
  2. From the left sidebar, click Databases.
  3. Proceed to click User Management. This action will take you to the Database Users page, where you can oversee all database user accounts.
  4. On the Database Users page, select Add Database User. This will open the "Adding Database User" interface.
  5. In the Database server dropdown list, specify the type of database server (e.g., MySQL, PostgreSQL) to which this new user will be assigned.
  6. Enter the desired username for the new database user in the Database user name text box.
  7. Create a secure password for the database user by typing it into both the New password and Confirm password fields.
  8. Use the Database dropdown list to select the specific database this user will be assigned to. You can also accept the default selection.
  9. Complete the process by clicking OK. The platform will then successfully add the new user to the designated database.

Managing Database User Privileges

Effectively managing database user privileges is crucial for security and data integrity. The control panel allows you to modify user passwords, reassign databases, and adjust access levels. Here’s how to manage these settings:

  1. Log in to your control panel.
  2. Navigate to the left sidebar and click on Databases. The Databases page will be displayed.
  3. Click on User Management to access the list of database users.
  4. Click on the specific database user's name whose privileges or settings you wish to modify.
  5. If you need to update the database user’s password, enter a new, strong password in both the New password and Confirm password text boxes.
  6. To change the database associated with this user, select a different database from the Database dropdown list.
  7. To modify the user's access level for the selected database, choose the appropriate role (e.g., Read Only, Read/Write, Admin) from the Role dropdown list.
  8. After making all necessary changes, click OK to save your updates. The control panel will apply the revised privileges and settings to the database user.
Zurück