Since version 5.2.6 MySQL Workbench has included functionality for managing server instances. The functionality is similar to that formerly provided by MySQL Administrator. The Administrator functionality is group into several areas:

The Administrator also displays system and server status. System status displayed includes:

For server health the following are displayed:

Server Instances can be created and managed from the Home page. Under the Server Instances panel double-click the Manage icon to create a new Server Instance. Server Instances that have already been created can also be managed from the Server Instances panel on the Home page.

Figure 8.1. MySQL Workbench - Home page

Double-clicking the Manage icon launches the Manage Server Instances wizard. This wizard allows you to create, delete and manage server instances. The Connections tab of the wizard allows you to select a predefined connection to connect with a server to be managed. In addition, it is also possible to connect to a remote server using an SSH connection.

Figure 8.2. Server Instances Wizard

The System Profile tab of the wizard allows you to specify server specific information. This is primarily achieved through selecting a Profile Template. A Profile Template contains standard information used in managing the server instance. The following Profile Templates are available:

Once a profile is selected a number of default parameters will be set including commands used to start and stop MySQL, commands to check server status and location of the my.ini configuration file.

Figure 8.3. Server Instances Wizard

After an instance has been created it can be launched by double-clicking its icon in the Server Instances panel of the Home page. This creates an Administrator page. The Administrator page has two main panels, the Server Status panel, and the Configuration panel. The Configuration panel features multiple tabs: Startup, Configuration, Accounts, Connections, Variables, Data Dump, and Logs.

Startup Tab

The Startup tab has several purposes:

Figure 8.4. Administrator - Startup tab

Configuration tab

The configuration tab allows you to edit the my.ini configuration file through selecting checkboxes and other GUI controls. This tab also features a number of sub-tabs, which provide access to various sub-sections within the configuration file. The sub-tabs are:

Figure 8.5. Administrator - Configuration tab

Accounts tab

The Accounts tab has two sub-tabs:

Server Access Management allows you to list existing user accounts. You can also add and delete accounts. You can allocate administrative roles and also set account limits.

Schema Privileges allows you to set specific privileges on a user basis.

Figure 8.6. Administrator - Accounts tab

Connections tab

This tab lists all current connections to the monitored server.

Figure 8.7. Administrator - Connections tab

Variables tab

The Variables tab displays a list of all server and status variables.

Figure 8.8. Administrator - Variables tab

Data Dump tab

TBD - currently doesn't seem to do anything

Figure 8.9. Administrator - Data Dump tab

Logs tab

The Logs tab features two sub-tabs:

The General tab shows entries from the server's General log file.

The Slow Query Log tab displays entries from the Slow Query Log file.

Figure 8.10. Administrator - Logs tab