Add an external driver for data driven testing with MySQL
To keep the MySQL database in use, add its driver to the external library to establish the database connection. To see which libraries Katalon Studio supports built-in JDBC drivers for, refer to Configure database connection for data-driven testing in Katalon Studio.
This document shows you how to add a driver for a MySQL database connection.
Data-driven test execution that uses this MySQL connection requires a paid plan. See pricing page.
- You have already set up your MySQL database.
- Your MySQL database is running.
-
Download the MySQL library executable JAR file from the MySQL Connector/J download page.
This example uses
mysql-connector-j-9.3.0.jar. For Katalon Studio 11.7, check the selected Connector/J release's Java compatibility in the MySQL Connector/J version documentation and choose a release compatible with Java 21. -
Go to Project Settings > Library Management. Click Add to add the JAR file to the external library.
-
In Project Settings, switch to Database to configure the database connection.
-
Select Secure User and Password to enable the User and Password fields.
-
Input the User and Password used for authentication.
-
Enter the Connection URL.
-
Add Connection Properties for JDBC Driver.
-
Click Test Connection to verify whether your database is connected successfully.
-
Click Apply and Close to complete the connection process.
-