Managing Database Users

Each database can have multiple users with their own credentials. ServerPlane manages user creation, password changes, and deletion directly on the server.

Viewing Users

1. Go to Databases and click on a database to open its detail page.
2. Open the Users tab.
3. Existing users are listed with their username, host, and privileges.

Creating a User

1. In the Users tab, scroll down to the Add User section.
2. Fill in the fields:
   • Username — The login name for the user.
   • Password — Enter a password (minimum 8 characters) or click Gen to generate a random one.
   • Host — The host the user connects from. Defaults to localhost. Use % to allow connections from any host.
3. Click Add User.

The new user is granted ALL privileges on the database. The user appears in the list immediately.

Changing a Password

1. In the Users tab, find the user whose password you want to change.
2. Click Change Password next to the user.
3. An inline form appears with a password field. Enter a new password or click Generate to create one.
4. Click Save to apply the change on the server.
5. Click Cancel to discard.

The password is updated on the database server immediately.

Deleting a User

1. In the Users tab, find the user you want to remove.
2. Click Delete next to the user.
3. Confirm the dialog.

The user is dropped from the database server and removed from ServerPlane's records.

Notes

• All users are created with ALL privileges on their associated database.
• User credentials (passwords) are stored securely in ServerPlane.
• Deleting a database also removes all of its associated users automatically.