This AMI is a LAMP Web Server with phpMyAdmin installed on Ubuntu 22.04. Package include Linux, Apache2, MySQL, and phpMyAdmin.

This AMI supports following versions.

PHP 8.1
Apache 2.4
MySQL 8.0
phpMyAdmin 8.1

Web Server

We prepared SSL/TLS so you can access to top page using http:// or https://.

Create VM instance

We recommend using minimum machine type e2-standard-8 for this LAMP server. For more machine types please refer to GCP General purpose machines documentation.

DB Server Password

You can find the password from VM management console System Log

1. Go to GCP VM2 console at https://console.cloud.google.com/logs/.
2. Chose your Instance and click on the three-dot menu → View logs

Get MySQL root password

External IP address

Note the external IP from VM instance console

You can access to Apache Ubuntu by accessing http://{externalIP}/phpMyAdmin.

When you access Google Chrome with warning.

Click anywhere on the browser and type thisisunsafe to bypass when there is no danger to your connection.

Then this default welcome page will show ups

phpMyAdmin

You can access to phpMyAdmin after creating ssh tunnel.

How to Set up SSH Tunneling (Port Forwarding)

ex.) create ssh tunnel

$ ssh ubuntu@{ipaddress} -i {ssh-key-file.pem} -N -L 8080:localhost:80
http://localhost:8080/phpMyAdmin

For phpMyAdmin please refer to phpMyAdmin User Guide

Disable Unattended Upgrades

Unattended Upgrades Are Turned On by default. If you want to turn unattended upgrades off please following this instruction:

1. Run sudo dpkg-reconfigure -plow unattended-upgrades and select “No” when Configuring unattended-upgrades prompted, OR
2. sudo apt remove unattended-upgrades to remove

Reference

• Ubuntu
• phpMyAdmin User Guide
• How to Set up SSH Tunneling (Port Forwarding)
• GCP General purpose machines
• How to Ensure Ubuntu’s Unattended Upgrades Are Turned On
• How To Disable Unattended Upgrades On Ubuntu
• How do I stop/disable unattended upgrades from being launched automatically? [duplicate]

Tags GCP, LAMP