Deleting a database user permanently removes the account and all its grants from the MySQL server. The user can no longer connect or access any database. This action cannot be undone — use it only when you are certain the user is no longer needed.
When to Delete a User
- The application or website that used the account has been decommissioned.
- You created a test user that is no longer needed.
- An employee or contractor no longer requires database access.
- You want to replace the user with a new one (e.g., to reset all credentials).
- You have reached your plan's user limit and need to free a slot.
Step-by-Step: Deleting a User
- Log in at mysql.nobregas.org.
- Go to Database Users in the top navigation bar.
- Find the user you want to delete in the user list.
- Click the Delete button on the user's row.
- A confirmation dialog appears warning that this action is permanent.
- Click Confirm to delete the user.
The user and all associated grants are immediately removed from MySQL.
What Gets Deleted
| Removed | Not Removed |
|---|---|
| The MySQL user account | Your databases |
| All grants (every database the user had access to) | Tables and data inside those databases |
| The ability to connect with those credentials | Other users with access to the same databases |
Before You Delete
Before deleting a user, make sure:
- No application is still using the user's credentials. Deleting an active user breaks database connections immediately.
- No scheduled jobs (cron tasks, backups) depend on the user.
- You have the credentials for another user with access to the same databases, or you plan to create a replacement user.
Can You Undo a Deletion?
No. Deleting a database user is permanent. To restore the same access, you must:
- Create a new user with the same (or different) username and password.
- Grant it access to each database that the original user had.
- Update your application's configuration with the new credentials.
Delete vs. Revoke
| Action | Effect |
|---|---|
| Delete | Removes the entire user and all grants permanently. |
| Revoke | Removes access to one specific database; user still exists. |
If you only need to remove access to a specific database, use Revoke from the Manage modal instead.
After Deletion
Your user count decreases by one, freeing quota on your plan. The Database Users list refreshes automatically. Any active connections from the deleted user are terminated by the MySQL server.
