The problem he was trying to solve involved creating APIs to access a MySQL database of U.K. real estate data — something that wasn’t easy to achieve.

Because MySQL is such a popular database, I thought it would be a great data source to use as an illustration. This will also refresh your memory on how to set MySQL up for remote connections.

Now that you’ve learned how to set up remote connections for MySQL 8, here’s how you can connect the MySQL database with LibreOffice, DBeaver and Grafana.