How to Create a New Database User

Database users control who can access your MySQL databases and what they can do. The Nobregas MySQL Panel lets you create dedicated database users with custom usernames, secure passwords, and specific privilege sets — giving each application or person only the access they need.

Why Create Separate Database Users?

Instead of using one user for everything, creating separate users lets you:

• Limit access — Give each application only the permissions it needs.
• Improve security — If one user's password is compromised, other databases remain safe.
• Track activity — Know which user performed which actions.
• Follow best practices — Production, staging, and development should use different credentials.

Step-by-Step: Creating a User

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. A modal dialog opens with the following fields.

Filling In the User Details

Username

Enter a username for the new MySQL user. It will be automatically prefixed with your account prefix (e.g., u24a5d4_). Keep it descriptive:

• app_readonly for a read-only application user
• admin for a full-access user
• staging for a staging environment

Only alphanumeric characters and underscores are allowed. The total length (prefix + name) cannot exceed 32 characters.

Password

Enter a strong password (minimum 8 characters). Click the shuffle button next to the field to generate a cryptographically secure 16-character password automatically.

Tips for a strong password:

• Mix uppercase and lowercase letters.
• Include numbers and special characters.
• Do not reuse passwords from other services.

Host

The host determines where the user can connect from:

• localhost — Only from the same server (most common and most secure).
• % — From any IP address (use with caution).
• Specific IP — Only from a particular IP address.

Leave this as localhost unless you need remote access.

Grant to Database

Select a database from the dropdown to grant this user access immediately. If you skip this step, the user will be created without any database access — you can add grants later via the Manage button.

Privileges

When you select a database, a Privileges section appears with categorized checkboxes:

• ALL PRIVILEGES (checked by default) — Full access to the selected database.
• Data: SELECT, INSERT, UPDATE, DELETE
• Structure: CREATE, ALTER, DROP, INDEX, REFERENCES
• Administration: CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE, EVENT, TRIGGER

Uncheck "ALL PRIVILEGES" to reveal individual checkboxes and select only the permissions you need.

Creating the User

Click Create User. The panel will:

1. Validate your input.
2. Create the MySQL user on your server node.
3. Grant the selected privileges on the chosen database (if any).
4. Display a success notification.

The new user immediately appears in your Database Users list.

After Creation

• The user can now connect to the granted database with the credentials you set.
• Use the Manage button on the users list to add more database grants or change privileges later.
• The password cannot be retrieved after creation — if forgotten, delete the user and create a new one.