Launch MySQL Workbench to open the home screen. Existing connections
are shown when you click the MySQL
Connections view from the sidebar. No connections
exist for first-time users.
Figure 5.2 Getting Started Tutorial - Home Screen
From the MySQL Workbench home screen shown in the previous figure,
click the [+] icon near the MySQL
Connections label to open the Setup New
Connection wizard.
Define the Connection Name value, such asMyFirstConnection
as the next figure shows.
Figure 5.3 Getting Started Tutorial - Setup New Connection: MyFirstConnection
The default connection values are for a typical local setup, so
check them and enter the appropriate values. If you are unsure,
click the Test Connection button to check
the connection parameters. Do not press
OK.
Next, optionally click Configure Server
Management..., which opens up the
Configure Local Management wizard:
Read the Configure Local Management
introduction (shown in the next figure), and press
Next to begin defining the new connection
parameters.
Figure 5.4 Getting Started Tutorial - Configure Local Management Introduction
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 correctly. The following figure shows a database
connection that tested successfully.
Figure 5.5 Getting Started Tutorial - Test Database Connection
Toggle the Show Logs to view additional
details about the tested connection, then 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
connection.
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.
This step creates a local MySQL connection, so you can skip the
Management and OS and SSH
Configuration options, which are used for configuring
a remote MySQL connection.
On Microsoft Windows, select the appropriate MySQL service for
the MySQL connection, as shown in the figure that follows.
Figure 5.6 Getting Started Tutorial - Windows Management
The wizard will now check its ability to access the start and
stop commands and then check access to the MySQL Server
configuration file as the next figure shows.
Figure 5.7 Getting Started Tutorial - Test Settings
You now have a chance to review the configuration settings. The
information displayed varies slightly depending on platform,
connection method, and installation type.
At the Review Settings prompt, choose I'd like to
review the settings again
to review the settings as
shown in the next figure. Choosing
Continue closes the Configure Server
Management dialog.
Figure 5.8 Getting Started Tutorial - Review Settings
Check the Change Parameters if you want to
check or edit information about the MySQL configuration file.
For this example, select the check box and click
Next to continue.
Review the MySQL configuration file information shown in the
next figure. Click Check Path and
Check Name to perform the described
checks, or optionally change the configuration file path.
Figure 5.9 Getting Started Tutorial - MySQL Configuration File
Optionally, enter your own commands for starting, stopping, and
checking the MySQL connection. To apply the default values,
leave these optional values blank as the following figure shows.
Figure 5.10 Getting Started Tutorial - Specify Commands
Click Finish to close the Configure
Server Management dialog, which returns to the original Setup
New Connection step.
After reviewing the Setup New Connection
information (see the figure that follows), click Test
Connection again to make sure it still functions and
then click OK to create the new MySQL
connection.
Figure 5.11 Getting Started Tutorial - Setup New Connection
Your new MyFirstConnection MySQL connection
is now listed on the home screen.
From the home screen, click the new MySQL connection to open the
SQL editor for this connection. The SQL editor is the default
page. Click Server Status from the
Navigator area of the sidebar to display the current status of
the connected MySQL server instance (see the figure that
follows).
Figure 5.12 Getting Started Tutorial - Server Status
Test the other Navigator area options that relate to your new
MySQL connection. Check its status, MySQL logs, and measure its
performance statistics from the Dashboard.
Notice the Administration and
Schemas tabs in the Navigator area. The
Schemas view displays the schemas that are
associated with your new MySQL connection. Alternatively, you
can merge the content of the tabs by either clicking merge
() or by enabling the Show
Management Tools and Schema Tree in a single tab SQL
editor preference.