MySQL Users

The Server Users view provides an interface to create and edit users on the MySQL server, as well as control their privileges.

In MySQL, privileges are always granted to a user name combined with the host name the client is connecting from. In Querious, these user-host combinations are organized by user, with the allowed hosts assigned to that user nested inside of them in the user list.

To create a user:

Click on the Add button below the Users list and select “Add User…” from the menu.
Enter the user’s name into the newly-selected user in the Users list and press Return.

By default, a single wildcard host (%) is added to the user, allowing the user to connect from anywhere.

To change a user’s password:

Click on the user in the Users list and click on the “All Hosts…” button in the Password section on the right side of the window. This will change the password needed to connect from any of the allowed hosts for the selected user.

Select the user and reveal the list of allowed hosts for that user.
Select an allowed host for that user.
Click on a host for a user in the Users list, and click on the button in the Password section with the label matching the selected host. This will change the password the user needs to connect from only that selected host, leaving the passwords for all other hosts unchanged.

To edit a user’s privileges:

Select the user and reveal the list of allowed hosts for that user.
Select an allowed host for that user.
To universally apply a set of privileges to all database, tables, columns, etc, select the “Global Privileges” item from the “Privileges Scope” list. Privileges set when this item is selected apply to all databases and tables where no overrides are selected.
To provide specific privileges limited to a single database or table, click on the checkbox next to that database or table in the Privileges Scope list. With the checkbox selected and the database/table selected, the privileges options displayed apply only to the selected database/table.