The MySQL JDBC driver provides connections for MySQL databases.
To install the driver, do the following:
-
Download the mysql-connector archive.
-
Extract the archive file.
-
Copy the mysql-connector-java-5.x.xx\mysql-connector-java-5.x.xx-bin.jar file to the <ReadyAPI installation>/bin/ext.
-
Restart ReadyAPI to load the driver.
Connection String Template
ReadyAPI has preconfigured connection string for MySQL. If you need a custom one, add it by using the ReadyAPI Preferences menu.
-
Click Preferences on the toolbar.
-
Open the JDBC Drivers settings.
-
Click .
-
Enter a descriptive name, for example:
MySql/com.mysql.jdbc.Driver
.The new connection will appear at the end of the list.
-
Add a connection string template, for example:
jdbc:mysql://<HOST:127.0.0.1>:<PORT:3306>/<DB>?user=<USER>&password=<PASSWORD>