project-commands

#1: Update the Ubuntu Machine:

sudo apt update

#2: Install the Apache2 server

sudo apt install apache2 -y

#3: Go to the html directory:

cd /var/www/html

#4: Check the files in the directory:

ls 

#5: Remove the index.html file:

sudo rm index.html

#6: Check the files in the directory:

ls 

#7: Create an index.php file:

sudo nano index.php

#8: Install the MySQL Server:

sudo apt install mysql-server -y

#9: Go to the html directory:

cd /var/www/html

#10: Connect to the MySQL Database through EC2 Server:

sudo mysql -h application-database.calupg2c7sxe.ap-south-1.rds.amazonaws.com -u admin -pintel123 (Replace with your database endpoints, username and password)

#11: Show the databases:

show databases

#12: Go inside the intel database;

use intel;

#13: Create a table:

create table data (firstname varchar(20), email varchar(20));

#14: Insert the data into the table:

insert into data values ('AWS', 'support@aws.com');

#15: Check the data is successfully inserted or not:

select * from data;

#16: Exit from the database:

exit

#17: Open the index.php file

sudo nano index.php

#18: Change the servername and username in these lines:

servername = “Real Database Endpoint (application-database.calupg2c7sxe.ap-south-1.rds.amazonaws.com)”

username = “admin” instead of “intel”.

#19: Add the php repository:

sudo add-apt-repository -y ppa:ondrej/php

#20: Install the PHP And MySQL Client:

sudo apt install php5.6 mysql-client php5.6-mysqli

#21: Connect with the Database:

sudo mysql -h application-database.calupg2c7sxe.ap-south-1.rds.amazonaws.com -u admin -pintel123 (Replace with your database endpoints, username and password)

#22: Go inside the intel database;

use intel;

#23: Check the data is successfully inserted or not:

select * from data;