MySQL Workbench provides a Manage DB Connections dialog for creating and managing connections to servers. The connections created can then be used from the wizards that must connect to a server, such as the wizard used to reverse engineer a live database. However, it is still possible to set connection parameters from these wizards if required, without invoking the Manage DB Connections dialog directly.
The Manage DB Connections dialog is invoked by selecting Database, Manage Connections from the main menu. It can also be invoked from any of the wizards requiring access to a live database. This is achieved by using the Manage Stored Connections item, found in the wizard's Stored Connection list.
After the Manage DB Connections dialog is launched, you are presented with the following dialog, which enables you to create or delete connections.
Click New to create a new connection. Once created, the connection can be selected from the Stored Connections list. You can then set various parameters for the connection, including the following:
Connection Name: The name used to refer to this connection. This connection can then be selected from a list in other wizards requiring a connection.
Connection Method: The methods available are Standard TCP/IP, Local Socket/Pipe, and Standard TCP/IP over SSH.
After you select a connection method, the fields available in the Parameters tab and the Advanced tab of the dialog changes accordingly. More details about these options and parameters are available in the following sections.
After all parameters have been set as required, you can click the Test Connection button to test the connection to the live server. After you are satisfied that the connection works as expected, you can close the wizard by clicking the Close button. The stored connection then is available for use from any of the wizards requiring a connection to a live server.
You can duplicate an existing connection using the Duplicate button. This is an easy way to begin setting up a new connection that differs only slightly from an existing one.