Full project with an EC2 instance, Apache2 server, and MySQL database involves setting up a web server, a database, and a web application that interacts with the database.
-
Log in to AWS Console
- Go to the AWS Management Console.
- Navigate to the EC2 service.
-
Launch an EC2 Instance
- Click Launch Instance.
- Choose an Amazon Machine Image (AMI), such as Ubuntu.
- Select an instance type (e.g.,
t2.microfor free tier). - Configure instance details (default settings are fine).
- Add storage (default 8GB is sufficient).
- Add tags (optional).
- Configure the security group:
- Allow HTTP (80), HTTPS (443), SSH (22), and MySQL (3306).
- Review and launch the instance.
- Create and download a key pair (
webserver.pem) for SSH access.
-
Connect to the EC2 Instance
cd Downloads chmod 400 webserver.pem ssh -i "webserver.pem" ubuntu@<your-ec2-public-ip>
-
Update the System
sudo apt update && sudo apt upgrade -y sudo -i passwd -
Install PHP
sudo apt install php libapache2-mod-php php-mysql -y
-
Install Apache2
sudo apt install apache2 -y
-
Install MySQL
sudo apt install mysql-server -y mysql --version
-
Start and Enable Services
sudo systemctl start apache2 sudo systemctl enable apache2 sudo systemctl status apache2 sudo systemctl start mysql sudo systemctl enable mysql sudo systemctl status mysql
-
Secure MySQL Installation
sudo mysql_secure_installation
-
Verify Apache Installation
- Open browser:
http://<your-ec2-public-ip> - You should see Apache's default landing page.
- Open browser:
-
Log in to MySQL
sudo mysql -u root -p
-
Create a Database and User
CREATE DATABASE myproject; CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword'; GRANT ALL PRIVILEGES ON myproject.* TO 'myuser'@'localhost'; FLUSH PRIVILEGES;
-
Create a Table
USE myproject; CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, email VARCHAR(100) NOT NULL ); EXIT;
-
Create Project Directory
sudo mkdir /var/www/html/myproject sudo chown -R $USER:$USER /var/www/html/myproject sudo chmod 755 /var/www/html/ cd /var/www/html sudo rm index.html sudo touch index.php sudo nano index.php
-
Add PHP Code
Paste the following code into
index.php:<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>My EC2 Project</title> </head> <body> <h1>Welcome to My EC2 Web Server!</h1> <p>This is a simple PHP application connected to MySQL.</p> <h2>Add User</h2> <form method="POST" action=""> Name: <input type="text" name="name" required><br> Email: <input type="email" name="email" required><br> <input type="submit" name="submit" value="Add User"> </form> <h2>User List</h2> <?php $servername = "localhost"; $username = "myuser"; $password = "mypassword"; $dbname = "myproject"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } if (isset($_POST['submit'])) { $name = $_POST['name']; $email = $_POST['email']; $sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')"; if ($conn->query($sql) === TRUE) { echo "<p>User added successfully!</p>"; } else { echo "<p>Error: " . $sql . "<br>" . $conn->error . "</p>"; } } $sql = "SELECT id, name, email FROM users"; $result = $conn->query($sql); if ($result->num_rows > 0) { echo "<ul>"; while ($row = $result->fetch_assoc()) { echo "<li>" . $row["name"] . " - " . $row["email"] . "</li>"; } echo "</ul>"; } else { echo "<p>No users found.</p>"; } $conn->close(); ?> </body> </html>
-
Restart Apache
sudo systemctl restart apache2
-
Test Application
- Visit
http://<your-ec2-public-ip>in a browser. - Use the form to add users and view the user list.
- Visit
- Stop/Terminate EC2 Instance when the project is complete to avoid charges.
This project demonstrates how to set up an EC2 instance, install Apache2 and MySQL, and deploy a PHP web application connected to a database.