MySQL-databases en gebruikers beheren 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, beveiliging, en prestaties.

These features are available on standard cPanel-hosting omgevingen.

Managing database users

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

Creating a database user

1. Log in op cPanel.
2. Open de Hulpmiddelen pagina.
3. In de Databases sectie, klikken Manage My Databases.
4. Onder Nieuwe gebruiker toevoegen, enter a username.
5. Set and confirm a strong password or use the password generator.
6. Klikken Gebruiker aanmaken.

[Tijdelijke aanduiding voor screenshot: Add New MySQL User]

Changing a user password

1. Open Manage My Databases.
2. Onder Current Users, locate the user.
3. Klikken Wachtwoord wijzigen.
4. Set and confirm the new password.
5. Sla de wijzigingen op.

Update application configuration files to match the new credentials.

Renaming a user

1. Open Manage My Databases.
2. Onder Current Users, klikken 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. Open Manage My Databases.
2. Onder Current Users, klikken Verwijderen.
3. Confirm the deletion.

Ensure no applications rely on the user before removal.

Managing databases

After creating users, create databases and assign appropriate privileges.

Creating a database

1. Open Manage My Databases.
2. Onder Maak een nieuwe database, enter a database name.
3. Klikken Database maken.

Database names are automatically prefixed with your account username.

Adding a user to a database

1. Onder Add User to Database, select a user.
2. Select the target database.
3. Klikken Add.
4. Assign specific privileges or select ALL PRIVILEGES.
5. Klikken Make Changes.

[Tijdelijke aanduiding voor screenshot: Assign User Privileges]

Checking and repairing a database

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

Revoking user privileges

1. Onder 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. Open Manage My Databases.
2. Onder Current Databases, klikken Verwijderen next to the database.
3. Confirm the deletion.

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, omgevingen zoals cloud-servers of een speciale server provide greater control over database performance, toegang, and recovery options.