- 5.3.1 Standard TCP/IP Connection Method
- 5.3.2 Local Socket/Pipe Connection Method
- 5.3.3 Standard TCP/IP over SSH Connection Method
- 5.3.4 SSL Wizard (Certificates)
- 5.3.5 System Profile
- 5.3.6 Configure Server Management Wizard
- 5.3.7 The Password Storage Vault
- 5.3.8 Updating Old Authentication Protocol Passwords
The Manage Server Connections dialog is another way to manage MySQL connections. This dialog is invoked by either selecting Edit Connection or selecting , from the main menu. It can also be invoked from any of the wizards requiring access to a live database.
After the MySQL connection manager is launched, you are presented with the following dialog, with the Connection tab open:
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: Method used to connect to the RDBMS.
After you select a connection method, the fields available in the Parameters, SSL, and Advanced tabs change accordingly. More details about these options and parameters are available below.
Thebutton will test the selected MySQL connection and report its connection status. It also reports whether or not SSL is enabled.
For testing remote connections, you might also use
ping to check the hostname, or
telnet to also check the port. If these fail,
then also check the firewall settings on each host, and also that
MySQL server is running on the remote host.
Simultaneous client connections: Opening a MySQL connection from the MySQL Workbench home page opens a new connection tab in MySQL Workbench for that connection. Each of these tabs requires two MySQL connections to perform basic tasks, such schema discovery and SQL execution. Additionally, performing management related tasks, such as Server Status, requires two additional MySQL connections. Essentially, this means that each MySQL connection tab in MySQL Workbench requires four available connections to MySQL. For additional information about "Too many connection" related errors, see Too many connections.
This connection requirement doubles with each connection tab opened in MySQL Workbench, even if the two connection tabs point to the same MySQL server. SQL editor tabs share their connections, so having multiple SQL editor and SQL results tabs does not affect the number of required connections.