MySQL
MySQL
Follow these steps to connect MySQL to your CData Connect Cloud account:
-
Open the Connections page of the CData Connect Cloud dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type MySQL into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Enter the following information:
-
Server—the host name or IP address of the MySQL server. Cluster servers are supported (for example,
192.168.0.1,192.168.0.2
). -
Port—the port for connecting to the MySQL server.
-
-
Select the Authentication method, then proceed to the relevant section and follow those instructions.
Password
-
Enter the following information:
-
User—the MySQL username for authentication.
-
Password—the user password.
-
Database—(Optional) the name of the MySQL database.
-
-
At the top of the CData Connect Cloud Add MySQL Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AzureAD
-
Enter the following information:
-
User—the MySQL username for authentication.
-
Azure Tenant—the MySQL tenant that you want to use to access data.
-
Database—(Optional) the name of the MySQL database.
-
-
Click Sign in to connect securely through OAuth. This action opens the MySQL sign-in page in a new tab.
-
Log into your MySQL account and provide the requested permissions (if applicable).
-
At the top of the CData Connect Cloud Add MySQL Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
Azure Password
-
Enter the following information:
-
User—the MySQL username for authentication.
-
Password—the user password.
-
Azure Tenant—the MySQL tenant that you want to use to access data.
-
Database—(Optional) the name of the MySQL database.
-
-
At the top of the CData Connect Cloud Add MySQL Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect Cloud and MySQL, see this information page.