How to Grant ALL PRIVILEGES to a Database User

Granting ALL PRIVILEGES gives a database user complete control over a specific database — they can read, write, create tables, drop tables, and perform every other operation. This is the most common setup for application users that need full database access.

When to Use ALL PRIVILEGES

Grant ALL PRIVILEGES when:

• The user is the primary application user connecting your website or app to the database.
• You need full administrative control over the database.
• The user manages the entire lifecycle of the database (creating tables, inserting data, modifying structure).
• You are the only person accessing the database.

Method 1: During User Creation

1. Log in at mysql.nobregas.org.
2. Go to Database Users > click Create User.
3. Enter the username, password, and host.
4. Select a database from the Grant to Database dropdown.
5. The Privileges section appears with ALL PRIVILEGES checked by default.
6. Leave it checked.
7. Click Create User.

The user is created with full access to the selected database.

Method 2: Via the Manage Button (Existing User)

If you already have a user and want to grant ALL PRIVILEGES on a database:

1. Go to the Database Users page.
2. Click the Manage button on the user's row.
3. The Manage Privileges modal opens.
4. In the Add Database Access section at the bottom, select a database.
5. Leave ALL PRIVILEGES checked (it is the default).
6. Click Add Grant.

The user now has full access to the additional database.

Method 3: Updating Existing Privileges

If a user already has limited privileges on a database and you want to upgrade to ALL:

1. Click Manage on the user.
2. Find the database grant in the Current Grants section.
3. Click the Edit button on that grant.
4. Check the ALL PRIVILEGES checkbox.
5. Click Save Changes.

The user's privileges are updated from limited to full access.

What ALL PRIVILEGES Includes

ALL PRIVILEGES grants every database-level permission:

• 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

Verifying the Grant

After granting, check the Database Users list. The database column shows a green ALL badge next to the database name, confirming full privileges.

Security Consideration

ALL PRIVILEGES is powerful. If the user's credentials are compromised, an attacker can delete all data, drop tables, and modify the database structure. Consider using specific privileges for users that do not need full access.