Toad for MySQL 7.7 - Installation Guide

Create MySQL Connections

You can create a new connection, or connect to an existing connection from the Create New Connection window. See Troubleshoot MySQL Issues for more information about troubleshooting MySQL connection issues.

To create a MySQL connection

1. Click on the toolbar (ALT+F+N).

2. Select MySQL from the Group list box.

3. Review the following for additional information:

   Login Tab	Description
   Connection type	Select the protocol to use when connecting.
   Host	Enter the name of the host computer where the database is installed.
   Password	Enter the password to use when connecting. Tip: After connecting, you can set a master password to further secure your connection in Tools | Options| Environment | Security.
   Connection timeout	Enter the number of seconds to wait when connecting before the application times out. The default is 15 seconds.
   SSL	If you selected SSL as the connection type, review the following for additional information:  Private key—browse to the location of the SSL key file to use when connecting. CA cert—browse to the location of the trusted certificate authority to use when connecting. Cert—browse to the location of the SSL certificate file to use when connecting.
   Compress	Select this checkbox to compress the value of any strings and return binary values.
   Use MySQL libraries	Select this checkbox to use an embedded MySQL library instead of the MySQL .NET provider. Note: If you select this option, you must specify libMySQL.dll in the path.
   Category	Select or create a category if you want to color code Editor tabs for a specific connection. This can help differentiate between development and production databases. You can also set an option to color code the Object Explorer pane and object editor windows (Create, Alter, Drop, etc.).   Click here to view a video of this feature.

4. Click Connect to save the connection and immediately connect to the database.

   or

   Click Save to save the connection without connecting to the database.

Tip: Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.

Troubleshoot MySQL Issues

Review the following solutions to help troubleshoot MySQL connection issues pertaining to database connections in Toad.

Configure Version Control

About Version Control

Toad integrates with your existing version control system so you can maintain multiple revisions of objects. See Configure Version Control for Objects for more information on configuring version control in Toad.

Important: See Troubleshoot Version Control for more information about issues when upgrading version control from a previous version.

Notes: 

• If you want to place database objects under version control, you must configure version control for objects using the Object Explorer. See Manage Objects under Version Control for more information.
• If you rename a version controlled object, Toad drops the original object and its history from version control and prompts you to add the renamed object to version control. This newly renamed object does not have any history associated with it.

Prerequisites

You must install a supported version control client on the computer where Toad is installed. The following table lists the supported version control providers and the versions tested with Toad.