Toad Data Point 6.1.2

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

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 or MariaDB connection

Click on the toolbar (ALT+F+N).
Select either MySQL or MariaDB 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: 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.). See Set Connection Categories for more information. Click here to view a video of this feature.
Advanced Tab	Description
ODBC driver	Select an ODBC driver to use when executing cross-connection queries using this connection. Tip: You can specify the ODBC driver to use for all connections for this database provider in Tools \| Options \| Database \| MySQL.

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.

Click here to view a video about creating connections in Toad Data Point

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Point 6.1.2 - User Guide

Create MySQL Connections