Skip navigation links
MySQL Workbench :: 8 Server Administration :: 8.1 Server Instances
8.1.1 Creating and Managing Server Instances »
Section Navigation      [Toggle]

8.1. Server Instances

[+/-]

8.1.1. Creating and Managing Server Instances

In the Workspace section of the Home screen is an area for Server Administration tasks. This section of the Workspace has the following action items:

  1. Server Administration

  2. Server Administration (icon)

  3. New Server Instance

  4. Manage Data Import/Export

  5. Manage Security

  6. Manage Server Instances

Server Administration

The purpose of this action item is to allow you to quickly connect to a predefined server instance, and carry out administration functions on the associated server. Clicking this item launches the Security Manager dialog, from which you can select the server instance you wish to connect to. A new Admin tab will be launched, which displays the Server Status and Configuration.

Server Administration (icon)

If you have already created server instances, then you can most quickly launch these by clicking on the icon for the Server Instance you wish to access. A new Admin tab will be launched, which displays Server Status and Configuration.

New Server Instance

This action item allows you to create a new server instance. A server instance is primarily a combination of connection and configuration details for a specific server that you wish to manage. When you click this item a wizard is launched that allows you to specify the connection and various other configuration parameters. After completion of the wizard, a new Admin tab is launched, which displays Server Status and Configuration.

Manage Data Import/Export

The purpose of this action item is to allow you to create a dump file from a database, or restore data from a file to a live database. Clicking this item launches the Import/Export MySQL Data wizard. This allows you to select a server instance to connect to.

Manage Security

The purpose of this action item is to take you quickly to the screen that allows you to manage user accounts. It simply launches an Admin page and locates you on the Accounts tab.

Manage Server Instances

Clicking this action item launches the Manage Server Instances dialog. Within this dialog you can change the configuration of existing server instances, or create a new server instance.

This topic is discussed in more depth in the section Section 8.1.1, “Creating and Managing Server Instances”.