You need to make sure you have MySQL set up for remote connections (See: How to set up MySQL for remote access on Ubuntu Server 16.04 (This also works for Ubuntu 18.04). I will assume you already ...

How to Create Excel Spreadsheets With MySQL. When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file.