MySQL error 1449: The user specified as a definer does not exist

I was recently working with a sidekick thing where I was using MySQL as my backend database. This was accessed from the application with hostname - localhost and username dev. I had created one view and was using it in the thing I was working on. It was originally scripted…

Installing Ghost on Ubuntu, Nignx and MySQL - Part 3

In continuation of Installing Ghost on Ubuntu, Nignx and MySQL - Part 2 Finally we arrive at the Ghost part mostly... Install Node.js sudo apt-get update curl -sL https://deb.nodesource.com/setup_4.x | sudo -E bash - sudo apt-get install -y nodejs sudo apt-get install -y build-essential…

Installing Ghost on Ubuntu, Nignx and MySQL - Part 2

In continuation of Installing Ghost on Ubuntu, Nignx and MySQL - Part 1 Now that you have secured your SSH connections, it is time to put up a firewall to secure all inbound network traffic. Configuring UFW Step: Install UFW (Uncomplicated firewall - not complicated at all, promise) sudo apt-get…

Installing Ghost on Ubuntu, Nignx and MySQL - Part 1

I am using DigitalOcean for hosting my Ghost blog. Any instance of hosting in DigitalOcean environment are called Droplets (wonder why?). Mostly setting up a Ghost blog in DigitalOcean environment is pretty much easy. But after few days I realized that the setup is good enough for 'getting up and…