Saturday, October 28, 2017

MySQL on Ubuntu on AWS Lightsail

Some quick documentation on how I created an AWS Lightsail Ubuntu instance:

First create the instance:

Create instance --> Linux/Unix --> OS Only --> Ubuntu 16.04 LTS

Wait a few minutes, then open a shell prompt.

sudo apt-get update
sudo apt-get upgrade
sudo reboot
sudo apt-get update
sudo apt-get upgrade
sudo apt autoremove
sudo apt-get dist-upgrade
sudo reboot
sudo apt-get update
sudo apt-get upgrade

Nicely patched now.
To install mysql:

sudo apt-get install mysql-server
mysql_secure_installation

Now to test it:

mysql -u root -p
show databases;