5.1.2.1 Creating A New MySQL Connection (Simple)

To add a connection, click the [+] icon to the right of the MySQL Connections title. This opens the Setup New Connection form:

Figure 5.2 Setup New Connection Form

Setup New Connection Form

Important

The Setup New Connection form features a Configure Server Management button (bottom left) that is required for the MySQL connection to perform tasks that requires shell access to the host. For example, starting/stopping the MySQL instance or editing the configuration file. For more information, see Section 5.1.2.3.5, “Configure Server Management Wizard”.

Fill out the connection details and optionally click Configure Server Management to execute the Server Management wizard. Click OK to save the connection.

Important

All connections opened by MySQL Workbench automatically set the client character set to utf8. Manually changing the client character set, such as using SET NAMES ..., may cause MySQL Workbench to not correctly display the characters. For additional information about client character sets, see Connection Character Sets and Collations.

New connections are added to the Home page as a tile, and multiple connections may be opened simultaneously in MySQL Workbench. The Section 7.2.1, “Object Browser and Editor” describes several MySQL Workbench features to monitor and configure each connected MySQL server.

For a more detailed overview of this process, see the tutorial titled Section 5.1.2.2, “Creating A New MySQL Connection (Tutorial)”.