Jack Wallen walks you through the process of connecting the DBeaver GUI tool to a remote MySQL server.

Type the MySQL server name or IP address and the username and password with rights to the MySQL database you need. Click "Test Connection" and select the database from the list box.

Once you have established that you can connect to the database successfully in your script, you can build on the basic code to present your data to site users.