This AMI is a LEPP Web Server with phpMyAdmin installed on Amazon Linux 2.
This AMI supports following versions.
- PHP 8.1
- Nginx 1.22
- PostgreSQL 14
Web Server
We prepared SSL/TLS so you can access to top page using http:// or https://.
DB Server
You can find the password from EC2 management console System Log.
- Go to Amazon EC2 console at https://console.aws.amazon.com/ec2/.
- Chose your Instance and Click Actions → Instance Settings → Get System log
Get System log
You can also SSH into your instance and find the login credential using the following command.
[ec2-user@ip-172-31-77-125 ~]$ cat credentials
////////////////////credentials info////////////////////
--- PostgreSQL
----- User : postgres
----- Password : aVpwwo9pdiK1lewp
////////////////////////////////////////////////////////
Login PostgreSQL SHELL
$ sudo -i -u postgres psql -U postgres
psql (14.3)
Type "help" for help.
postgres=#
postgres=# SHOW data_directory;
data_directory
---------------------
/var/lib/pgsql/data
(1 row)
or
$ psql -h localhost -U postgres
Password for user postgres:
psql (14.3)
Type "help" for help.
postgres=# SELECT version();
version
-----------------------------------------------------------------------------------------------------------
PostgreSQL 14.3 on x86_64-koji-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-15), 64-bit
(1 row)
Option pgAdmin 4
You can access to PostgreSQL using pgAdmin 4 with ssh tunnel.
Dashboard
Click Add New Server
General
Type Your DB Server Name
SSH Tunnel
Click SSH Tunnel Tab
- Use SSH tunneling: On
- Tunnel host: your server ip address
- Tunnel port: 22
- Authentication: Identity file
- Identity file: *****.pem
Connection
Click Connection Tab
- Host name/address: localhost
- Port: 5432
- Maintenance database: postgres
- Username: postgres
- Password: *******
Click Save
Let’s use pgAdmin
