Grant All Access

For a user to be able to read and write to a database, that user must be given access rights (privileges). In Database GUI, you can grant full access rights quickly. Here is how:

BEFORE YOU START

Make sure the database and user have already been created:

• Create Database
• Create User

Step 1: Select a User

1. Enter the Database GUI menu, then click the Users tab.
2. Find the user you want to grant access to in the list.
3. Click the Grant All button on that user's row.

Step 2: Set the Target Database

A Grant Privileges window will appear. Configure the following options:

• Target Database: select the database you want to grant access to, or leave * (All Databases) to grant access to all databases.
• Include WITH GRANT OPTION: check this option if you want that user to be able to grant the same access rights to other users.

Step 3: Grant the Access

1. Click the Grant Privileges button.
2. If successful, a success notification will appear.

note

This command will grant ALL PRIVILEGES (read, write, update, delete, and others) on the database you selected. Choose the target database carefully, especially if you are granting access to a user that is shared.

tip

If the new access rights do not seem to take effect, Restart your server so the database configuration is reloaded cleanly.

---

Done!

Now you understand the complete flow:

1. Hosting Database
2. Create Database
3. Create User
4. Grant All Access