How do I install phpMyAdmin on Amazon EC2?

To install phpMyAdmin on Amazon EC2: connect via SSH, install Apache and PHP (sudo yum install httpd php), install MySQL, then download phpMyAdmin from its official site and extract to /var/www/html/phpmyadmin. Configure config.inc.php, set a blowfish_secret, and restart Apache. Access via http://ec2-ip/phpmyadmin.

How do I secure phpMyAdmin on AWS EC2?

Secure phpMyAdmin on AWS EC2 by: restricting access to specific IP addresses in Apache configuration, using HTTPS with an SSL certificate, adding HTTP authentication as a second layer, changing the default phpMyAdmin URL path, and restricting EC2 security group port 80/443 access to trusted IP addresses only.

Can I use phpMyAdmin with AWS RDS?

Yes, phpMyAdmin on EC2 can connect to AWS RDS. Configure phpMyAdmin's config.inc.php with your RDS endpoint as the server host. Ensure the EC2 security group is added to the RDS security group's inbound rules for MySQL port 3306. Use your RDS master username and password to log in.

What PHP version does phpMyAdmin require?

phpMyAdmin requires PHP 7.2 or higher (PHP 8.0+ recommended for newer versions). You also need the mysqli or PDO_MySQL PHP extension, the session PHP extension, and optionally mbstring, zip, and gd extensions for full functionality. Check the phpMyAdmin documentation for specific version compatibility.

How to Install phpMyAdmin on Amazon EC2 Ubuntu

June 19, 2020 / Nirav Shah

How to Install and Access phpMyAdmin on Amazon EC2 Ubuntu Server

Prerequisites & Requirements for Installing phpMyAdmin on Ubuntu

Before installing phpMyAdmin, we need to meet some basic requirements
A LAMP stack (Linux, Apache, MySQL, and PHP) installed How to Install Apache, MySQL, PHP on AWS EC2
php version

	PHP 7.2.24-0ubuntu0.18.04.4 (cli) (built: Apr  8 2020 15:45:57) ( NTS )
	Copyright (c) 1997-2018 The PHP Group
	Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
	with Zend OPcache v7.2.24-0ubuntu0.18.04.4, Copyright (c) 1999-2018, by Zend Technologies

How to Install phpMyAdmin from Ubuntu Package Manager

Step 1: Update Package Index

First, we need to make sure our local server is pulling the latest updates.

$ sudo apt-get update

Step 2: Install phpMyAdmin Package

Now we can install the latest version of phpMyAdmin.

$ sudo apt-get install -y phpmyadmin

Step 3: Configure phpMyAdmin Package

After installing phpMyAdmin, you will be presented with the package configuration screen.
Press the SPACEbar to place an “*” beside “apache2.”
Press TAB to highlight “OK,” then hit ENTER.
The installation process will continue until you’re back at another package configuration screen.
Select “Yes” and then hit ENTER at the dbconfig-common screen.
Select “Yes” and hit ENTER.
You will be prompted for your database administrator’s password.
Type it in, hit TAB to highlight “OK,” and then press ENTER.
Enter your DB administrator’s password.
Next, enter a password for the phpMyAdmin application itself.
Enter the password you’d like to use to access the phpMyAdmin interface.
Confirm the phpMyAdmin application password.
Confirm your phpMyAdmin password.
After the installation process completes, it adds the phpMyAdmin configuration file here.
/etc/apache2/conf-enabled/phpmyadmin.conf

Restart Apache

Now we should restart the Apache web server for changes to take affect

$ sudo service apache2 restart

How to Access phpMyAdmin for the First Time on AWS EC2

Now you can log in to phpMyAdmin by going to your server followed by /phpmyadmin.
You can just use http://YOUR_SERVER_IP/phpmyadmin if you don’t have domains set up yet.
Log in with the root user and the password you set for the phpMyAdmin application.

Spread Love By Sharing:

Nirav Shah

Nirav Shah is the Director of Eternal Web Pvt Ltd, an AWS Advanced Consulting Partner and certified Odoo Partner based in the UK. With over a decade of experience in cloud computing, digital transformation, and ERP implementation, Nirav helps enterprises adopt the right technology to solve complex business challenges. He specialises in AWS infrastructure, Odoo ERP, and web development solutions for businesses across the UK and beyond.