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 ...

You can create and run database queries with a GUI by using database management tools such as MySQL Workbench, DBeaver, or pgAdmin for PostgreSQL. These tools provide a graphical interface where ...