💫 Integrating Amazon RDS with WordPress 💫

⭐Amazon Relational Database Service (RDS) ⭐

⭐WordPress ⭐

Let’s Begin…

🔅 Create an AWS EC2 instance

To create an EC2 instance I’m using Amazon Linux 2 image

🔅 Configure the instance mysql database and apache webserver.

  1. Install mysql
yum install mysql -y
amazon-linux-extras install php7.2 -y
yum install httpd -y
wget https://wordpress.org/latest.tar.gz
tar -xzf latest.tar.gz
mv wordpress /var/www/html
vim /etc/httpd/conf/httpd.confAllowOverride All

🔅 As wordpress stores data at the backend in MySQL Database server. Therefore, you need to setup a MySQL server using AWS RDS service using Free Tier.

👉🏻 DataBase created :

👉🏻 Creating mysql database :

CREATE DATABASE <database_name>;

👉🏻 Here we can see database mywp1 is empty

use <database_name>;show tables;

👉🏻 Now on browser:

http://<public_ip>/wordpress

👉🏻 In my case it is not able to create wp-config.php file. Let me create it manually;

cat > wordpress/wp-config.php
# and save the file....

⭐ And here you can see task completed and now you can write blogs !! ⭐

👉🏻 And now you can see wordpress stores information in mywp1 database :

use <database_name>;show tables;

Finally our Task is completed successfully !!!!😄✌🏻

Thanks for Reading !! 🙌🏻😁📃

🔰 Keep Learning !! Keep Sharing !! 🔰

--

--

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
Vrukshali Torawane

DevOps Engineer • Terraform Certified • 2x RedHat Certified • DevOps Technical Writer✍🏻 • she/her • Learner Forever