This tutorial will explain to you how to create an ODBC connection with the MySQL database.
- download and install MYSQL from the https://dev.mysql.com/downloads/windows/installer/8.0.html
- download ODBC connector for MYSQL https://dev.mysql.com/downloads/connector/odbc/
install MySql server and ODBC connector 32bit or 64bit version.
click windows key in and type ODBC Data Source and select ODBC Datasource Administrator 32bit
Click on add and select the MySql ODBC ANCI Driver.
finally DB connection details will appear and provide ODBC name the server as localhost, port 3306, root as user and password.
then the system will create an ODBC connection that can be used to connect to the database from various applications.
this ODBC connection will be used to create jasper report with Jasper Report Designer