This tab allows you to grant privileges on a schema level. In MySQL, a schema is the same as a database. To grant privileges for a specific database, click on the database name in the left box. (You cannot select more than one database at a time.)

You may use wild cards to grant privileges on a number of schemata simultaneously. Use “%” to replace multiple characters and “_” to replace a single character. To use this feature, right click any database name in the schemata list, choose the Add Schema with Wildcards option from the pop-up menu and enter the pattern you wish to match. Entering m% for example, will add the entry, m% to the schemata list. Highlight this entry and any privileges granted will be granted for all schemata starting with the letter “m”.

Privileges not assigned to the user are listed under Available Privileges. You can remove privileges by selecting them in the left box, and then clicking the > button. Removed privileges will appear in the Available Privileges box. You can assign privileges by selecting them in the Available Privileges box, and then clicking the < button.

The Schema Privileges tab only displays privileges that have been granted for a specific schema. No schema privileges will show in the Assigned Privileges column for users with global privileges. For example, the Assigned Privileges column will be blank for a root user with global privileges on all schemata. Likewise, the Assigned Privileges column will be blank for a user with a global SELECT privilege, unless SELECT has also specifically been granted for the currently selected schema.