Install PhpMyAdmin on Amazon EC2 AMI

Most Linux distributions come with PhpMyAdmin preinstalled and ready to configure. However, this is not true of Red Hat distributions such as CentOS, Fedora, or Amazon AMI among others. For these distributions, phpMyAdmin is located in the Extra Packages for Enterprise Linux (or EPEL) repository. EPEL is a Fedora Special Interest Group that creates, maintains, and manages a high quality set of additional packages for Enterprise Linux, including, but not limited to, Red Hat Enterprise Linux (RHEL), CentOS, Scientific Linux (SL), and Oracle Linux (OL).

Installing PhpMyAdmin is not difficult and requires just a few minutes. These instructions apply to performing the installation from an OSX Yosemite machine.

1. Open Terminal from the Applications/Utilities folder
2. Open a New Remote Connection (⇧⌘K) and log into your AWS AMI instance and execute the following commands:
   
   Execute commands on remote server

   Shell

   sudo yum update sudo yum --enablerepo=epel install phpmyadmin sudo vi /etc/httpd/conf.d/phpMyAdmin.conf

   1 2 3

   sudo yum update sudo yum --enablerepo=epel install phpmyadmin sudo vi /etc/httpd/conf.d/phpMyAdmin.conf

3. Edit /etc/httpd/conf.d/phpMyAdmin.conf to look like this:
   /etc/httpd/conf.d/phpMyAdmin.conf

   # phpMyAdmin - Web based MySQL browser written in php # # Allows only localhost by default # # But allowing phpMyAdmin to anyone other than localhost should be considered # dangerous unless properly secured by SSL Alias /phpMyAdmin /usr/share/phpMyAdmin Alias /phpmyadmin /usr/share/phpMyAdmin Alias /mysqladmin /usr/share/phpmyadmin <Directory /usr/share/phpMyAdmin/> AddDefaultCharset UTF-8 Options All AllowOverride All Require all granted <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> Require ip 127.0.0.1 Require ip ::1 </RequireAny> </IfModule> <IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow Deny from All Allow from 127.0.0.1 Allow from ::1 </IfModule> </Directory> <Directory /usr/share/phpMyAdmin/setup/> Options All AllowOverride All Require all granted <IfModule mod_authz_core.c>

   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

   # phpMyAdmin - Web based MySQL browser written in php # # Allows only localhost by default # # But allowing phpMyAdmin to anyone other than localhost should be considered # dangerous unless properly secured by SSL   Alias /phpMyAdmin /usr/share/phpMyAdmin Alias /phpmyadmin /usr/share/phpMyAdmin Alias /mysqladmin /usr/share/phpmyadmin   <Directory /usr/share/phpMyAdmin/>    AddDefaultCharset UTF-8     Options All     AllowOverride All     Require all granted    <IfModule mod_authz_core.c>      # Apache 2.4      <RequireAny>        Require ip 127.0.0.1        Require ip ::1      </RequireAny>    </IfModule>    <IfModule !mod_authz_core.c>      # Apache 2.2      Order Deny,Allow      Deny from All      Allow from 127.0.0.1      Allow from ::1    </IfModule> </Directory>   <Directory /usr/share/phpMyAdmin/setup/>     Options All     AllowOverride All     Require all granted    <IfModule mod_authz_core.c>

4. Edit the “blowfish secret" in /etc/phpMyAdmin/config.inc.php. Change string from default:
   
   /etc/phpMyAdmin/config.inc.php

   PHP

   /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = '4875149021800013670'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

   1 2 3 4 5

   /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = '4875149021800013670'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

5. Log into phpMyAdmin and test your installation