Setting up your MySQL database on Amazon RDS
Use the free MySQL WorkBench to create your database, create database user, password and assign rights on Amazon RDS.
Alternatively use Sequel Pro or use Navicat to set up your database on the Amazon RDS database server. It dos not matter which of the 3 tools you are using.
Install Apache2, PHP7, Curl and MySQL connector on Ubuntu
This will install:
- Apache
- PHP7
- MySQL database connector to access Amazon RDS. You will need this connector use the remote Amazon AWS RDS server.
sudo apt-get install apache2 php7.0 php7.0-mysql libapache2-mod-php
Install curl, gd and zip
- Curl is widly used and needed by WordShell.
- GD is needed by WordPress to change the size of uploaded images.
- Zip is a easy way to compress directories and files when backing up or moving files and directories.
sudo apt-get install curl php7.0-curl php7.0-gd zip
Apache modules to activate
sudo a2enmod rewrite
Then restart Apache to activate the change:
sudo service apache2 restart