How to Manage Privileges for an Existing Database User

After creating a database user, you may need to adjust their access — add new databases, change privilege levels, or revoke access entirely. The Nobregas MySQL Panel provides a dedicated Manage modal for complete privilege management on any existing user.

Opening the Manage Modal

1. Log in at mysql.nobregas.org.
2. Go to Database Users in the top navigation bar.
3. Find the user you want to manage.
4. Click the Manage button on their row.

The Manage Privileges modal opens, showing all current grants and options to modify them.

Understanding the Manage Modal Layout

The modal has two main sections:

Current Grants

A list of every database the user currently has access to, including:

• Database name — The database associated with the grant.
• Privileges — Either "ALL PRIVILEGES" or a list of individual privileges.
• Edit button — Modify the privileges for that specific grant.
• Revoke button — Remove the user's access to that database entirely.

Add Database Access

A form at the bottom to grant the user access to an additional database with a specific set of privileges.

Common Management Tasks

Viewing Current Privileges

Simply open the Manage modal. All databases and their associated privileges are displayed immediately — no additional clicks required.

Adding a New Database Grant

1. In the Add Database Access section, select a database from the dropdown.
2. Configure the desired privileges (ALL PRIVILEGES or specific ones).
3. Click Add Grant.
4. The new grant appears in the Current Grants section above.

Editing Existing Privileges

1. Click Edit on the grant you want to modify.
2. The privilege checkboxes appear inline, pre-filled with the current privileges.
3. Check or uncheck privileges as needed.
4. Click Save Changes.

Revoking Database Access

1. Click Revoke on the grant you want to remove.
2. Confirm the revocation when prompted.
3. The grant is removed and the user can no longer access that database.

Privilege Changes Take Effect Immediately

When you save privilege changes or add/revoke grants, MySQL applies them immediately. The user does not need to reconnect — the new privilege set is enforced on their next query.

Tips for Effective Privilege Management

• Audit regularly — Review user privileges periodically to ensure they still match current needs.
• Start restrictive — Grant minimum privileges first, then expand as needed.
• Use the Manage modal — It is faster and safer than running raw GRANT/REVOKE SQL statements.
• Check badge colors — Green "ALL" means full access, blue badges show limited privileges.