Installing phpMyAdmin

Last Updated October 2014

At some point, you will need to edit the data in your database. Installing phpMyAdmin is one way to gain access to your database and change what you need to change. After reading this doc, you should be able to:

  • Install phpMyAdmin

Download and Install phpMyAdmin Locally

Download phpMyAdmin, uncompress it and place it in the root of your application. Rename the directory something more friendly like phpmyadmin instead of phpMyAdmin-x.x.x.x-language.

Rename & Edit config.inc.php

Rename config.sample.inc.php to config.inc.php and for a single database, make the following changes:

Edit config.inc.php PHP

  $cfg['Servers'][$i]['host'] = 'localhost';
  $cfg['Servers'][$i]['host'] = $_SERVER['DATABASE1_HOST'];
/phpMyAdmin/config.inc.php

Add PHP Extensions to Your Boxfile

Add the following php extensions needed to run phpMyAdmin into your app's Boxfile. If you have questions about the Boxfile, check out the Boxfile documentation.

Boxfile PHP Extensions YAML

  web1:
    php_extensions:
      - mcrypt
      - mysqli
      - mysql
      - mbstring
/Boxfile

Deploy & Enjoy

Commit the changes to your repo and push the new commit up to Pagoda Box. Once the the deploy is finished, you'll be able to use phpMyAdmin in your app.

You can find your database connection credentials in your app dashboard by clicking on your database service and going to the credentials tab.

If you have any questions, suggestions, or corrections, let us know.