Create the PHP file to display the report on screen. You will need to connect to the database, then retrieve, format and display the fields if you use dynamic data in your report.

Select the mysql-connector-java-XXX-bin.jar file (where XXX is the release number) and click OK. Click OK to exit out of the Options window and you’re ready to connect to your remote database.

Grafana is one of the most widely-used data visualization tools on the market. Learn how to connect Grafana to a remote MySQL database with this tutorial.