Use a DSN-less connection (i.e. with no data source defined on the server) to connect the program to your database for simplicity. You will need to use HTML to format the data.

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.