Chapter 9. Server Administration

Table of Contents

9.1. Server Administration
9.2. New Server Instance
9.3. Manage Data Import/Export
9.4. Manage Security
9.5. Manage Server Instances
9.6. Creating and Managing Server Instances
9.6.1. New Server Instance Wizard
9.6.2. Manage Server Instances Dialog
9.7. Server Administration and Configuration
9.7.1. The Startup Tab
9.7.2. The Configuration Tab
9.7.3. The Accounts Tab
9.7.4. The Connections Tab
9.7.5. The Variables Tab
9.7.6. The Data Dump Tab
9.7.7. The Logs Tab

Since version 5.2.6, MySQL Workbench has included functionality for managing server instances. A server instance is created to provide a way of connecting to a server to be managed. The first step is to create a server instance if none exists, or to work with an existing server instance.

MySQL Workbench also provides functionality to administer and configure a server using these server instances. Thus, the Server Administrator functionality can be broadly grouped into two main areas:

The Workspace section of the Home window has an area for Server Administration tasks. This section of the Workspace has the following action items:

The following sections describe each of these action items.