Databases are accessed by users, and each user has privileges that control what it can do. Managing these in cPanel lets you give applications and people the right level of access, no more and no less. This guide explains how.
Where to manage users #
- Melden Sie sich bei cPanel an.
- In der Datenbanken Abschnitt, öffnen MySQL Databases.
- Scroll to MySQL Users to add users, and to Add User to Database to assign them.
Adding a user #
- Create a user with a strong password under MySQL Users.
- Assign it to the relevant database.
- Choose the privileges it should have.
Auswahl von Berechtigungen #
Grant only what is needed. A typical application user needs data privileges such as SELECT, INSERT, UPDATE, and DELETE. Reserve administrative privileges for cases that genuinely require them. Minimal privileges are safer.
Removing or changing access #
- Change a user’s privileges by re-opening its assignment to the database.
- Remove a user that is no longer needed.
- Update the password if it may have been exposed.
Fehlerbehebung #
- Die App kann keine Verbindung herstellen: confirm the user is assigned with the right privileges.
- Access denied errors: re-check the username, password, and host.
Brauchen Sie Hilfe? #
If a database user will not work, our support team can help over live chat.
