How to install phpmyadmin in Amazon EC2?

June 19, 2020 / Nirav Shah

Install and Access PHPMyAdmin on an Amazon EC2 Ubuntu Server

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

Steps to Install phpMyAdmin from Ubuntu Packages

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

Access phpMyAdmin for the First Time

• 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.