Skip to main content

Create User

After the database is created, the next step is to create a user that will be used to access that database. Here is how:

BEFORE YOU START

Make sure you have opened the Database GUI menu. If not, read Hosting Database first.

Step 1: Open the Users Tab​

  1. Enter the Database GUI menu.
  2. Click the Users tab at the top of the page.
  3. You will see a list of existing users, plus the Create User and Delete User boxes.

Users Tab

Step 2: Fill In the User Data​

In the Create User box, fill in the following fields:

  • Username: the user name. Only letters, numbers, and underscores (_) are allowed. Example: user_toko.
  • Host: the address allowed to connect. Leave the default % so the user can log in from anywhere.
  • Password: the password for this user, at least 8 characters. Use a combination of letters and numbers to keep it safe.

Step 3: Create the User​

  1. Click the Create User button.
  2. If successful, a success notification will appear and the new user will immediately show in the list in the format username@host (example: user_toko@%).

User Successfully Created

note

Every user you create is automatically granted ALL PRIVILEGES by the panel. You can still configure it more specifically through the Grant All Access menu.

Managing Existing Users​

On each user row, three buttons are available:

  • Grant All — grant full access rights to a specific database. See more at Grant All Access.
  • Password — change the user's password. Enter the new password, then click Update Password.
  • Drop — delete the user. This action cannot be undone.
tip

Store the username, host, and password in a safe place, because this is the data you will later enter into the application or plugin that uses the database.

Next Steps​