1. On your Launch an instance page, in the Key pair section, either select an existing SSH key pair name or create a new one, such as aws-ec2-instance-key-us-east-1

2. Edit your instance's security group inbound rules. Click on Add Rule, select the type as SSH, and set the source to My IP or manually enter your machine's IP address. This will allow only your machine to connect to the EC2 instance using SSH. To make your website accessible via HTTP/HTTPS: Click on Add Rule, select the type as HTTP, and set the source to Anywhere-IPv4. Repeat the process for the rule type HTTPS

3. Once you have downloaded the SSH key file to your machine, you can use it for secure authentication when connecting to remote instance

[Linux/Mac] Change the permissions using chmod 400 aws-ec2-instance-key-us-east-1.pem. You can find more information click here 

Connect to the instance using SSH: ssh -i aws-ec2-instance-key-us-east-1.pem ec2-user@YOUR-INSTANCE-IP

[Windows] Refer to the following links for instructions on connecting to the instance using SSH: OpenSSH Setup  or Putty Setup 

MariaDB Setup:

Once you have logged in to the instance using SSH, secure and set the root password by running: sudo mysql_secure_installation

• Enter current password for root (enter for none):
• Switch to unix_socket authentication [Y/n] : n
• Change the root password? [Y/n]: Y
• Note down the root user password which you set in the previous step.
• Remove anonymous users? [Y/n]: Y
• Disallow root login remotely? [Y/n]: Y
• Remove test database and access to it? [Y/n]: Y
• Reload privilege tables now? [Y/n]: Y

Your MariaDB installation is successfully running

Here are a few additional steps you may find helpful:

• When launching an instance, consider attaching an Elastic IP to ensure that it remains unchanged when you stop and start your instance
• To connect to your remote database server, you can use a SQL client such as DBeaver  for Windows or Sequel Ace  for Mac. These clients provide a graphical interface for managing and interacting with your database

PHP App Setup:

• Visit: http://YOUR-INSTANCE-IP/phpinfo.php  (delete phpinfo.php once you confirm everything is okay)
• Your document directory is: /var/www/html You can put your PHP projects in this directory

Connecting to MariaDB:

Please replace the following credentials in bold with your own in the application

• DB_CONNECTION=mysql
• DB_HOST=127.0.0.1
• DB_PORT=3306
• DB_DATABASE=my_database
• DB_USERNAME=db_user
• DB_PASSWORD=my_db_password

SSL Certificate Setup:

1. Change to the config directory: cd /etc/httpd/conf.d You will see a YOUR-DOMAIN-com.conf config file in this directory

2. Open the config file using the nano editor: sudo nano YOUR-DOMAIN-com.conf Replace the ServerName and ServerAlias with your actual domain name

3. Rename the above config file to your actual domain name. (Replace YOUR-DOMAIN-com with your actual domain)

4. Change your domain's DNS A record to point to the IP address of this EC2 instance

5. Install Let's Encrypt free SSL certificate by running: sudo certbot --apache Follow the prompts to complete the installation

6. Edit the crontab file: sudo nano /etc/crontab Uncomment the SSL renewal cron job to enable automatic renewal of your SSL certificate

Advanced-level support and optimization will be promptly provided upon request. For further assistance, please refer to the support section