MySQL LAMP

Version: 8.0.30 | OS: Ubuntu 20.04

Overview

The MySQL LAMP stack includes the world’s most popular open-source database bundled with Apache, PHP, and phpMyAdmin to provide a full web development environment out-of-the-box.

Included Software

• Apache - 2.4.41
• MySQL - 8.0.30
• PHP - 8.1
• phpMyAdmin - 5.2.0
• Certbot - 0.40.0

Firewall & Access

Port	Service	Purpose
22	SSH (rate limited)	Secure server access
80	HTTP	Web access
443	HTTPS	Secure web access
3306	MySQL	Database access

Initial Deployment

During deployment:

• MySQL is installed and secured with mysql_secure_installation
• MySQL root password is generated
• phpMyAdmin is installed and secured

You will be logged out with the message:

Please wait until the installation is completed....
Connection to $IPADDRESS closed.

Wait at least 2 minutes before logging back in.

Accessing the Instance

1. Login to your instance:

ssh ubuntu@$IPADDRESS

2. Switch to root:

sudo su -

MySQL Access

• The root password is stored in:

/root/.mysql_root_password

• Login using:

mysql -u root -p

phpMyAdmin Access

• Open your browser and go to:

http://$IPADDRESS/phpmyadmin

• Username: admin
• Password: stored in:

/root/.phpmyadmin_password

• Configuration file location:

/etc/phpmyadmin/

Web Root

Your web files are located at:

/var/www/html

Domain & SSL Setup

To secure your connection with HTTPS:

1. Point your domain's A record to your server's IP
2. Use Certbot to generate the SSL certificate:

certbot --apache -d example.com -d www.example.com

For assistance, contact Cloud4India Support.

---