With Beekeeper studio, create a new connection, select MySQL as the connection type and fill out the following details (Figure C): Host: The IP address or domain of your MySQL server. Port: 3306.

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.

The sample script in Listing A checks a MySQL database for user preferences and includes the appropriate page settings, creating database-driven dynamic content.