JMeter MySQL Connection Requirement

Q

How to prepare for JMeter connection to MySQL database server?

✍: FYIcenter.com

A

You can prepare for JMeter connection to MySQL database server by following this tutorial.

1. Download the JDBC Driver for MySQL - Go to https://dev.mysql.com/downloads/connector/j/ and download the latest version, for example, mysql-connector-java-5.1.40.zip

Open the ZIP file and copy mysql-connector-java-5.1.40-bin.jar to \fyicenter\jmeter\lib folder.

2. Get the MySQL database server information from your DBA. For example:

Host name: localhost
Port number: 3306
Database name: fyicenter

3. Get a database username and password with permission to create table and insert records from your DBA For example:

Username: john
Password: NoOneKnows 

 

Create MySQL Table for Test Result

Saving Test Results to MySQL Database

Saving Test Results to MySQL Database

⇑⇑ Apache JMeter Tutorials

2017-11-18, 333👍, 0💬