AWS Documentation

  1. Home
  2. Docs
  3. AWS Documentation
  4. AWS LAMP and phpMyAdmin on Ubuntu 18

AWS LAMP and phpMyAdmin on Ubuntu 18

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.

This AMI supports following versions.

  • PHP 7.4
  • Apache 2.4
  • MySQL 5.7
  • phpMyAdmin

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

Tags ,

How can we help?