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 connection issues.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create a MySQL connection
Click on the toolbar (ALT+F+N).
Select MySQL from the Group list box.
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:
|
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. |
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.
Issue | Cause/Solution |
---|---|
"InvalidCastException" error when connecting to MYSQL 4.1.14-nt database |
This is a known issue in MySQL. Solution: Review the known issue and download a patch from: http://bugs.mysql.com/bug.php?id=12771 |
"System.IO.DirectoryNot |
Solution:
|
Toad integrates with your existing version control system so you can maintain multiple revisions of objects. See Configure Version Control 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:
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.
Supported Provider | Server Version Tested | Client Version Tested |
---|---|---|
Apache Subversion™
|
Subversion 1.7.5 on Windows |
CollabNet Subversion Command-Line Client 1.7.5 Note: Any Subversion client must have svn.exe in its installation directory to use version control in Toad. |
Team Foundation Server (TFS) |
TFS 2008, 2010, 2012 |
Visual Studio® (2008, 2010, 2012) Team Explorer Client
|
File system based | Toad allows to utilize practically any version control system using the external client tool. In this case Toad Version Control tool works with the directories at local HDD while you commit changes to the repository with version control client tool. | |
Note: Toad connects to your version control system based on login information included in the configuration. Your version control client does not need to run for Toad to connect. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center