How to Assign a Database to a User During Creation

When you create a new database user in the Nobregas MySQL Panel, you can immediately assign it to a database — so the user is ready to connect as soon as it is created. This saves you the extra step of adding grants afterward.

Step-by-Step Guide

1. Log in at mysql.nobregas.org.
2. Click Database Users in the top navigation bar.
3. Click the Create User button at the top right.
4. Fill in the Username, Password, and Host fields.
5. In the Grant to Database dropdown, select the database you want this user to access.
6. Configure the desired privileges (see below).
7. Click Create User.

The user is created and immediately granted access to the selected database.

Selecting a Database from the Dropdown

The Grant to Database dropdown lists all databases linked to your account. Each database appears with its full name including your prefix (e.g., u24a5d4_mysite).

If the dropdown is empty, it means you have not created any databases yet. Go to the Databases page first and create one.

What Happens When You Select a Database

When you select a database from the dropdown, two things happen:

1. The Privileges section appears below the dropdown, letting you choose exactly what the user can do.
2. Upon creation, the panel automatically runs the MySQL GRANT command on your server to give the user access.

Skipping Database Assignment

If you leave the dropdown on "Select database..." (no selection), the user will be created without any database access. You can add grants later using the Manage button on the Database Users page.

This is useful when:

• You want to create the user now but assign databases later.
• You plan to grant access to multiple databases individually.
• You are creating the user for a database that does not exist yet.

Assigning Multiple Databases

The creation modal only allows selecting one database at a time. To grant access to additional databases:

1. Create the user with the first database selected.
2. Go back to the Database Users list.
3. Click the Manage button on the newly created user.
4. In the Manage modal, use the Add Database Access section to grant additional databases with their own privilege sets.

Verifying the Assignment

After creation, the user appears in the Database Users list. The Databases column shows which databases the user has been granted access to, along with privilege badges:

• ALL (green badge) — Full access.
• N privs (blue badge) — Specific number of individual privileges.