Connecting Frontend(apache web)& Backend(MYSQL) on Cloud(Aws)

Shubham kumar
3 min readOct 17, 2022

🔅 Create an AWS EC2 instance
🔅 Configure the instance with Apache Webserver.
🔅 Download PHP application name “WordPress”.
🔅 As WordPress stores data at the backend in MySQL
Database server. Therefore, you need to set up a
MySQL server using AWS RDS service using Free Tier.
🔅 Provide the endpoint/connection string to the
WordPress application to make it work.

STEP 1: Creating Ec2 instance
Go to :: EC2-> instances ->launch instances,

After clicking on Create instances, choose os image, type, and other things as per need.
Now after instances show running status, connect it.

Ec2-launched

STEP 2 & 3: Configure the instance with Apache Webserver. & Download PHP application name “WordPress”
First Install Httpd php & mysql

Now get WordPress using:

unzip WordPress file by:

Copy WordPress file to httpd’s HTML path

STEP 4: As WordPress stores data at the backend in MySQL Database Server. Therefore, you need to set up a MySQL server using AWS RDS service using Free Tier.

AWS dashborad >> RDS >> Creste Databases
Choose : Standard create, MySQL

Choose version my MySQL: In my case, I select 5.7.21

Select free tier and give username & password :

And allow public access and set other settings as per need :
And Now create Databases

STEP 5: Provide the endpoint/connection string to the WordPress application to make it work.

After Creating select database-1 & click on action and select Set up ec2 connection, then select your instance

Now let connect with the database . So for this, we will log-in inside to database through ec2-instance using below command:-

mysql -h Endpoint -u user_name -p
#my example
#mysql -h database-1.clkhqprf6roh.ap-south-1.rds.amazonaws.com -u admin -p

Now let configure the wordpress. Before that create a database in mysql by:

create database WordPress;

Now follow the steps for installation of WordPress, its just simple as a cup of tea😊
DONE🤑

Hurray we have completed the task✨🌟.

#vimaldaga #righteducation #educationredefine
#rightmentor #worldrecordholder #linuxworld
#makingindiafutureready #righeducation #arthbylw
#php #apache #wordpress #aws #rds #mysql #rdbms

--

--