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 #
- Faça login no cPanel.
- No Bancos de dados seção, abrir Bancos de dados MySQL.
- 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.
Escolha de privilégios #
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.
Solução de problemas #
- O aplicativo não consegue se conectar: confirm the user is assigned with the right privileges.
- Access denied errors: re-check the username, password, and host.
Precisa de ajuda? #
If a database user will not work, our support team can help over live chat.
