How to Add a New Database Grant to an Existing User

A single database user can have access to multiple databases — each with its own set of privileges. The Nobregas MySQL Panel lets you add new database grants to existing users without creating duplicate accounts.

Why Grant Multiple Databases to One User

• Shared application user — One app that reads from multiple databases.
• Microservices — A service user that needs access to several databases.
• Reporting — A read-only user that pulls data across multiple databases.
• Simplified management — Fewer users to track and maintain.

Step-by-Step: Adding a New Grant

1. Log in at mysql.nobregas.org.
2. Go to Database Users in the top navigation bar.
3. Find the user and click the Manage button.
4. Scroll down to the Add Database Access section.
5. Select a database from the dropdown (only databases not yet granted are shown).
6. Choose the privileges:
   • Leave ALL PRIVILEGES checked for full access, or
   • Uncheck it and select specific privileges.
7. Click Add Grant.

The new grant is immediately created and appears in the Current Grants section above.

Setting Different Privileges Per Database

Each database grant is independent. You can give a user:

• ALL PRIVILEGES on production_db (full control).
• SELECT only on analytics_db (read-only reporting).
• SELECT, INSERT, UPDATE, DELETE on staging_db (data-only for testing).

This flexibility lets you use a single user account with appropriate access levels per database.

What Happens on the Server

When you click Add Grant, the panel runs a MySQL GRANT statement on the server node that hosts the user. The privileges are applied to the specific database immediately — no restart required.

Verifying the New Grant

After adding:

1. The Current Grants section in the Manage modal updates to show the new database.
2. On the main Database Users page, the Databases column shows all granted databases with their privilege badges.

Limits

• You can only grant databases that belong to your account.
• The dropdown excludes databases the user already has access to — no duplicate grants.
• The total number of grants per user depends on your plan limits.

Removing a Grant Later

If you no longer need the user to access a database, open the Manage modal and click Revoke next to that grant. The access is removed immediately.