Creating an RDS and using it in WordPress server
In this article I am going to show how to create a database in Relational Database Service(RDS) of AWS, how to install WordPress server on an EC2-instance, and then how to connect the Database to the WordPress server.
Creating a database in AWS RDS:
Firstly to create the Database we need to go to the RDS dashboard of AWS and then click on create database. Then we need to give the configuration for the RDS. Following is the configuration that I gave while launching the database:
- Selected the database creation method as default
- Selected the database engine as MySQL. WordPress only supports certain versions of MySQL hence choose the 5.7.31 which works with the WordPress.
- Then I have chosen the free tire template
- Then entered the database identifier. AWS provides the endpoint with this database identifier. Then I have given the username and the password for the database. This data will be used for authentication.
- Free tire by default has db.t2.micro as the option selected for the database instance type. I have left that unchanged
- Then I have allocated storage of 10GB to the database. Also there is option for autoscaling which is not necessary for my usecase but left it as default as I am just creating a simple server
- Then I have left the VPC as default as I will be launching the instance in the default VPC. Then I choose an already existing security group which allows all the traffic.
- Keeping the remaining options as is I started creating the database. It took around 5-10 mins to launch the database
Configuring the WordPress server:
In this 5-10mins gap I launched an instance using RedHat AMI. Then I have connected to the instance using ssh from my local machine. And then logged into the root shell by using the command
Then I have ran the
yum update -ycommand which is a better practice. Above is the output I got after doing it
Then I have installed the installed the packages
php-jsonusing the command
yum install php php-mysqlnd php-fpm httpd php-json -y
Then I have dowloaded the wordpress server code using the command
curl -O https://wordpress.ord/latest.tar.gz. Then I have extracted the tarfile using the command
tar xfz latest.tar.gz. Then I have copied the WordPress content to the
/var/www/html/which is the default root document for the HTTPD server.
Then I have set the SELinux to permissive mode using the command
setenforce 0which will disable the SELinux. It will cause some issues during the installation hence disabled it.
- Then I have started and enabled the htttpd service
Configuring WordPress webapplication:
After the WordPress server is installed properly I opened the webapplication which shows the homepage as follows
- If this screen is displayed then it is an acknowledgement that wordpress server is installed properly. Clicking on let's go will take to the next page.
This page is where we need to give the details about the database server. If we see this page it is asking for a database.
As the WordPress server needs a database that is already created in it hence I have installed the mysql client to access the database server from the WordPress server using the command
yum install mysql -y.
After installing the mysql client I have used the command
mysql -h <host_name> -u <username> -p<password> to connect to the database. Here <host_name> is endpoint of the database server, <username> is the name of the user created, <password> is the password for the user. There should be no space after
-p option while giving the password. Then I have created the database named wordpress using the query
create database wordpress;
Now coming back to where I left on the webpage I submitted it after the database is created.
Then it returned a screen as above. Clicking on run the installtion will take to another page as following On this page I gave the details and submited the form
Then it gave a success screen as above
Now we need to provide the login details and login to the wordpress server. Which displayed the screen as follows which implies that wordpress is installed correctly and the database is connected to it.
This is how I launched the database in RDS and used it for the WordPress server running on the EC2 instance.