You will first need code for the forms, then code to make the connection to the database and write the data to MySQL and code for the reports to display static or dynamic information to site visitors.

Not only have you configured MySQL 8 for remote connections, you’ve also created a user with access to all databases and connected to the remote server with both the command line and a GUI.

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.