Connecting to MySQL

Edit online

MySQL is an open source relational database management system that is based on structured query language (SQL). MySQL is a fast, reliable, scalable, and easy-to-use database system with querying and connectivity capabilities that offers robust data structure and platform integration

To integrate MySQL with IBM watsonx Orchestrate, you need to establish a secure connection that enables both systems to communicate seamlessly.

Note:

The Single sign-on (SSO) toggle is enabled only for supported OAuth 2.0 authentication types and applications. If the application does not support an SSO-enabled authentication type, the toggle remains disabled. For supported configurations, see Configuring single sign-on for applications.

Steps to connect

Use the following steps to connect MySQL to watsonx Orchestrate:

From the main menu, go to Manage > Security.

Important:
In the on-premises environment, use the Manage > Connections navigation path to access connections.
Click the Connections tab and search for the corresponding app name or the MySQL Connection ID.
Click edit next to the matching connection ID.
Select Key Value Pair as the authentication type.
Enter the MySQL‑specific connection details described in the corresponding connection details section below.
Complete the Draft and Live setup steps.
Save and test the connection to confirm successful connection.

Authentication methods

MySQL supports the following authentication type in watsonx Orchestrate:

Key Value Pair (KVP): Required for API‑key or token‑based configurations

Connection ID

Use the following Connection ID when locating your MySQL connection in the Connections settings page.


Authentication type	Connection ID
Key Value Pair	`mysql_ibm_184bdbd3`

Key Value Pair connection details

If your organization uses API keys, set Authentication type to Key Value Pair and add each of the following fields using Add new field:


Key	Description
Port	Port for authentication
Database	Database for authentication
Username	Username for authentication
Password	Password for authentication

Note: When using Key Value Pair, only Team credentials are supported.

Your MySQL administrator can help you get the details.

What to do next

Now that your app connection is live, you can start using it in watsonx Orchestrate.

Run an agent in Orchestrate Chat to complete tasks using natural language. See Using Orchestrate Chat for more details.
Use relevant agents and tools to perform app-specific actions. See Prebuilt agents and Prebuilt tools for more details.