Integrating Amazon RDS with WordPress

AWS RDS

WordPress

Prerequisites

  1. Amazon EC2 instance acting as the endpoint for the database
  2. Amazon RDS as the MySQL database
  3. WordPress is the frontend used

Steps for the Setup

dnf install httpd -y
dnf install wget vim -y
dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
dnf install https://rpms.remirepo.net/enterprise/remi-release-8.rpmdnf module install php:remi-7.4
dnf install php-mysqlnd -y
systemctl enable httpd --now
systemctl status httpd
wget https://wordpress.org/latest.tar.gz
tar -xvzf latest.tar.gz -C /var/www/html
  • Open Amazon RDS and click on Create Database
  • Select MySQL as the database type
  • In the Templates section, choose the Free tier.
  • DB instance identifierdefault
  • Master usernamedefault
  • Master password — Choose a password.
  • Confirm password — Retype the password
  • Availability Zone — us-east-1
  • Initial Database Name — mydb
<public_ip_ec2>/wordpress

Conclusion

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store