Using WinMySQL Professional

Manage hosts privileges

Only accessible when connected to the database «mysql», this «Server administration>Manage hosts privileges» submenu allows a MySQL® DBA to apply default privileges on hosts when connecting to specific databases.

This feature, not really useful permits, for example to revoke by default all privileges from all hosts to all databases. This secures your network and it actually works because all this directives are overridden by users privileges management directives. Then, the managed users can work with their privileges and the unmanaged users are automatically rejected.

If the current MySQL® server uses the old privileges system, you will be notified. So, if you don't want to be notified, then uncheck the submenu «Server management>Old privileges system warning».

How apply hosts privileges ?

To do that, invoke the «Server management>Manage hosts privileges» submenu. It opens the «Default access privileges form» screen. This form is composed by a combo box which list suggests the hosts already having default privileges directives, and a combo box which list suggests the database already concerned by default privileges directives.

Select the wanted host and database, check or uncheck the wanted privileges and click on the «Update privileges» button. WinMySQL Professional will try to update privileges and refresh the server to obtain an immediate effect.

If a wanted database or host isn't suggested by the combo box list, just enter it in the combo box field and strike the «Tab» key (or exit from the field). At the opposite, if you want to erase a host name or a database name, then click on the actived «Del» button located on the right side. If an unexisting combination between host and database is selected, WinMySQL Professional will ask a confirmation to create it.

Note the «%» replaces any characters string for hostnames or databasenames. For instance, «%» means any host (or any database) or «%.winmysql.com» means any host in the domain «winmysql.com».