Verwalten von MySQL-Datenbanken und -Benutzern in cPanel

cPanel provides a centralized interface for creating and maintaining MySQL databases, database users, and access permissions. Proper database management is essential for application stability, Sicherheit, und Leistung.

These features are available on standard cPanel-Hosting Umgebungen.

Managing database users

Database users authenticate applications and control access to data. Create users before assigning them to databases.

Creating a database user

1. Melden Sie sich bei CPanel an.
2. Öffnen Sie die Tools page.
3. Im Datenbanken Abschnitt, klicken Manage My Databases.
4. Unter Add New User, enter a username.
5. Set and confirm a strong password or use the password generator.
6. Klicken Create User.

[Screenshot placeholder: Add New MySQL User]

Changing a user password

1. Offen Manage My Databases.
2. Unter Current Users, locate the user.
3. Klicken Change Password.
4. Set and confirm the new password.
5. Save the changes.

Update application configuration files to match the new credentials.

Renaming a user

1. Offen Manage My Databases.
2. Unter Current Users, klicken Rename next to the user.
3. Enter the new name and proceed.

Deleting a user

Deleting a user removes all database privileges for that user.

1. Offen Manage My Databases.
2. Unter Current Users, klicken Löschen.
3. Bestätigen Sie den Löschvorgang.

Ensure no applications rely on the user before removal.

Managing databases

After creating users, create databases and assign appropriate privileges.

Creating a database

1. Offen Manage My Databases.
2. Unter Create New Database, enter a database name.
3. Klicken Create Database.

Database names are automatically prefixed with your account username.

Adding a user to a database

1. Unter Add User to Database, select a user.
2. Select the target database.
3. Klicken Hinzufügen.
4. Assign specific privileges or select ALL PRIVILEGES.
5. Klicken Make Changes.

[Screenshot placeholder: Assign User Privileges]

Checking and repairing a database

1. Unter Modify Databases, select a database in Check Database.
2. Klicken Check Database.
3. If issues are found, select the database under Repair Database.
4. Klicken Repair Database.

Revoking user privileges

1. Unter Current Databases, locate the database.
2. Click the remove icon next to the user.
3. Confirm Revoke User Privileges from Database.

Deleting a database

Deleting a database permanently removes its data.

1. Offen Manage My Databases.
2. Unter Current Databases, klicken Löschen next to the database.
3. Bestätigen Sie den Löschvorgang.

Create a backup before deletion if data retention is required.

Scaling and operational considerations

For applications with higher load, larger datasets, or custom backup strategies, environments such as Cloud-Server or a Dedizierter Server provide greater control over database performance, Zugang, and recovery options.