How to add a user to a MySQL database (privileges)

For hosting customers · Updated 2026-10-29

On this page
  1. Add a user to a database
  2. Remove a user from a database
  3. Which privileges the user gets
  4. Good to know
  5. Common questions

A database user can only work with the databases it has been added to. Adding a user gives it all privileges on that one database, which is what websites and applications need.

Add a user to a database

  1. Log in to the control panel (https://<server>:2083).
  2. Open MySQL Databases (section Databases).
  3. Under Add user to database, choose the User and the Database.
  4. Click Grant all privileges.

You see Privileges granted. The user's name appears under Privileged users next to the database.

Remove a user from a database

  1. In the Databases list, find the user's name under Privileged users.
  2. Click the × next to it (Revoke).

You see Privileges revoked. The user still exists but can no longer open that database.

Which privileges the user gets

All privileges on that database only: reading and changing data, creating and changing tables, indexes, views, triggers and stored procedures. The user cannot see or change other databases, and cannot create new databases — create those in MySQL Databases.

Good to know

  • Choosing individual privileges (for example read-only) is not offered: a user added to a database always gets all privileges on it. If someone must only read the data, give them an export or a separate copy of the database.
  • Changes apply within a few seconds.
  • If you allowed addresses in Remote MySQL, the same privileges apply when the user connects from those addresses.
  • Deleting a user (Delete in Database users) removes it from all databases.

Common questions

The button "Grant all privileges" is greyed out. Why?

You need at least one database and one database user first.

Do I need to grant again after changing the password?

No. Privileges stay when you change the user's password.

Was this article helpful?

Still stuck?

Ask the AI about your exact situation — it answers from this knowledge base — or contact us.