• Skip to main content

Victor Font Consulting Group, LLC

Digital Business Strategists

Call Us Toll Free:

1-844-VIC-FONT (842-3668)

  • Home
  • Care Plans
    • Care Articles
    • Optional Subscriptions
  • Consultations
  • Products
    • Code Snippets
    • Public GitHub Repositories
    • Gist Snippets
    • Pastebin Snippets (Free)
    • Free Plugins
  • FAQs
  • Support
    • Graphic Design
  • Our Team
    • Contact
    • Speakers
    • Portfolio
  • Resources
    • Free WordPress Video Training
    • Tutorials
    • Articles
    • Cybersecurity
    • EU Referral Network
You are here: Home / Computers and Internet / Install PhpMyAdmin on Amazon EC2 AMI

Install PhpMyAdmin on Amazon EC2 AMI

By Victor M. Font Jr.
June 21, 20153 Comments

PhpMyAdmin LogoMost 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:
    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:
    # 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
    
    
       AddDefaultCharset UTF-8
    	Options All
    	AllowOverride All
    	Require all granted
       
         # Apache 2.4
         
           Require ip 127.0.0.1
           Require ip ::1
         
       
       
         # Apache 2.2
         Order Deny,Allow
         Deny from All
         Allow from 127.0.0.1
         Allow from ::1
       
    
    
    
    	Options All
    	AllowOverride All
    	Require all granted
       
    
  4. Edit the “blowfish secret" in /etc/phpMyAdmin/config.inc.php. Change string from default:
    /*
     * 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
  • 2shares
  • Facebook0
  • Twitter0
  • Pinterest0
  • LinkedIn2
  • Print
  • SMS0

About Victor M. Font Jr.

Victor M. Font Jr. is an award winning author, entrepreneur, and Senior IT Executive. A Founding Board Member of the North Carolina Executive Roundtable, he has served on the Board of Advisors, of the North Carolina Technology Association, the International Institute of Business Analysis, Association of Information Technology Professionals, Toastmasters International, and the North Carolina Commission for Mental Health, Developmental Disabilities, and Substance Abuse Services. He is author of several books including The Ultimate Guide to the SDLC and Winning With WordPress Basics, and Cybersecurity.

Reader Interactions

VictorFont.com runs on the Genesis Framework

Genesis FrameworkThe Genesis Framework empowers you to quickly and easily build incredible websites with WordPress. Genesis provides the secure and search-engine-optimized foundation that takes WordPress to places you never thought it could go.

Check out the incredible features and the selection of designs. It's that simple—start using Genesis now!

Click here to download The Genesis Guide for Absolute Beginners (PDF - 1.4 MB)

Leave a Reply Cancel reply

Your email address and website will not be published. Required fields are marked *
Posting a comment means that you agree with and accept our Comment & Product Review Policy

Comments

  1. Skender

    January 19, 2017 at 12:08 pm

    Hi,

    Thanks for this article. I found it very useful.

    Jutst one question: I modified the /usr/share/phpMyAdmin but now get the message when I try to access the Web access (putting the public DNS of my AWS EC2 instance) that do not have the permissions:
    “You don’t have permission to access /phpMyAdmin/ on this server. apache port 80”

    Any suggestions?

    Thanks,
    Skender

    Reply
    • Victor M. Font Jr.

      January 19, 2017 at 12:17 pm

      Hi Skender,

      I’m not sure what you did. There are no instructions in the article for modifying the /usr/share/phpMyAdmin directory. I don’t use AWS any longer, but when I did, these are the instructions that allowed me to run phpMyAdmin. Sorry I can’t be more helpful this time.

      Reply
  2. Marcos

    November 18, 2015 at 7:49 am

    thank you!!!!!!!!!!!!!!!!

    Reply

Toll free: 844-VIC-FONT (844.842.3668)

Send us an E-mail Fax: 919.205.4446

Accessibility Statement | Affiliate Marketing Disclosure | Capability Statement

Cookie Policy | Comment & Product Review Policy | Privacy Policy | Site Map | Terms & Conditions

Copyright © 2003–2021 Victor M. Font Jr.

Return to top of page
Cover image: 5 Things You Can Fix On Your Website In The Next Week To Increase Engagement

Attract New Customers Automatically for Free!

  • Learn how to use the Internet to attract REAL clients
  • Avoid the 3 big mistakes EVERYBODY makes
  • Put this system on AUTOPILOT with the tools the Pros use!

GET YOUR COPY!

This little ebook has helped hundreds of business professionals get real results.
Now it's your turn!

ebook lead capture
Privacy Policy
{"cookieName":"wBounce","isAggressive":false,"isSitewide":true,"hesitation":"","openAnimation":false,"exitAnimation":false,"timer":"","sensitivity":"","cookieExpire":"7","cookieDomain":"","autoFire":"","isAnalyticsEnabled":false}
We only use analytical cookies on our website that allow us to recognize and count the number of visitors, but they do not identify you individually. They help us to improve the way our website works. By clicking Accept you, agree to cookies being used in accordance with our Cookie Policy.OkNoCookie policy