AWS Ubuntu 18 LAMP and phpMyAdmin AMI

This AMI is a LAMP Web Server with phpMyAdmin installed on Ubuntu 18. Also the SSM agent is installed. If you want to use it, please refer to documents.

• SSM Agent

This AMI supports following versions.

• PHP 8.0
• Apache 2.4
• MySQL 5.7
• phpMyAdmin 5.1

Web Server

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

DB Server Password

You can find the password from EC2 management console System Log.

1. Go to Amazon EC2 console at https://console.aws.amazon.com/ec2/.
2. Chose your Instance and Click Actions → Monitor and troubleshoot → Get System log

Get System log

You can also SSH into your instance and find the login credential using the following command.

$ cat /home/ubuntu/credentials
////////////////////credentials info////////////////////
--- phpMyAdmin
----- Setting  : Success
--- MySQL
----- User     : root
----- Password : e1WFUFzvz1NaxiSo
////////////////////////////////////////////////////////

If you want to use a mysql user “debian-sys-maint”, please set up the password with the mysql root user.

mysql> ALTER USER 'debian-sys-maint'@'localhost' IDENTIFIED BY 'YOUR_PASSWORD';
mysql> flush privileges;

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

Reference

• Ubuntu
• phpMyAdmin User Guide
• How to Set up SSH Tunneling (Port Forwarding)