Launch MySQL Workbench. You will be presented with the Home window.

Figure 4.1. Getting Started Tutorial - Home Window

To administer your MySQL Server, you must first create a Server Instance. The instance contains information about the target server, including how to connect to it. From the MySQL Workbench Home window, click New Server Instance. The Create New Server Instance Profile wizard will be displayed.

In this tutorial, you will connect to a locally installed server, so click Next.

Figure 4.2. Getting Started Tutorial - Specify Host Machine

Next you will set up a connection, or select an existing connection to use to connect to the server. Assuming that you have not already created a connection, you can use the default values here, although if your MySQL Server has a password set for the root account, you can enter it here by clicking Store in Vault. This enables you to connect to the server without needing to enter a password each time. It is also possible to use a different account to connect to the server by setting the user name and password here, if required.

Figure 4.3. Getting Started Tutorial - Database Connection

You can now click Next.

The connection will now be tested. You should see that the connection was successful. If not click Back and check that you have entered the information required.

Figure 4.4. Getting Started Tutorial - Connection Test

If the connection test was successful, click Next.

Optionally, you may configure a method for remote management if a Remote Host was specified. Setting these options enables MySQL Workbench to determine the location of configuration files, and the correct start and stop commands to use for the server.

SSH login based management and Native Windows remote management types are available. The Operating System and MySQL Installation Type are configured for the SSH login variant.

Figure 4.5. Getting Started Tutorial - Management and OS

Set the configuration method, then click Next.

If the SSH login based management was chosen, then you will configure its parameters which includes the User Name, Host Name, and optionally the SSH key for authentication.

Figure 4.6. Getting Started Tutorial - SSH Configuration

Check that everything is in order, then click Next.

If a Windows server is used, then the Windows configuration parameters must be set.

Figure 4.7. Getting Started Tutorial - Windows Management

Check that everything is in order, then click Next.

The wizard will now check that it is able to access the MySQL Server configuration file, and access the start and stop commands.

Figure 4.8. Getting Started Tutorial - Test Host Settings

Check that everything is in order, then click Next.

You now have a chance to review the configuration settings so far. The information displayed varies slightly depending on platform, connection method and installation type.

Figure 4.9. Getting Started Tutorial - Review Settings

Review the information, then click Next.

Finally you can give the server instance a suitable name. This will be used to select this particular instance from a list of available instances.

Figure 4.10. Getting Started Tutorial - Instance Name

Set the desired name, then click Finish to complete the server instance creation process.

You will now be returned to the Home window. You will see the new server instance you created, along with the new connection you created as part of the preceding procedure.

Figure 4.11. Getting Started Tutorial - Home Window Instance

You are now ready to test your new server instance.

From the Home window, double-click the Server Instance you created. The Administrator will open on the Startup configuration page.

Figure 4.12. Getting Started Tutorial - Admin Startup

Click the Stop Server button. The message window will show that the server has stopped.

Click the Start Server button to resume the server. The message window will confirm that the server is running.