Tips for installing Ghost on an EC2 instance.

Follow the official instructions, but after installing MySQL run the following, replacing exampleuser and examplepassword with your own values:

sudo mysql

Once MySQL is open:

CREATE USER 'exampleuser' IDENTIFIED BY 'examplepassword';
GRANT ALL PRIVILEGES ON *.* TO 'exampleuser'@'localhost' WITH GRANT OPTION;
GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'exampleuser'@'localhost' WITH GRANT OPTION;

You may also need to install some other dependencies:

sudo apt install gcc g++ make