This gist records some steps I took to set up a LAMP server on Ubuntu, and how I configured MySQL to allow remote access with MySQL workbench.
Please note that this is not meant to be an exhaustive guide, and absolutely no security measures are in place.
I used a Google Cloud VM, but I'm pretty sure this could be applied to a home server as well. Just remember to open to required ports on your router and forward them appropriately.
Where possible, I will credit the original source of information, and paste code snippets to facilitate replication of this. I have left out most of the text from the guides I referenced. If you'd like to understand in depth what each line of code does, please refer to the original links.