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
Using phpMyAdmin is Not Recommended
We cannot guarantee the security of phpMyAdmin and do not recommend it's use for database management. The recommended method is managing your database securely and remotely using one of the remote connection options and your database management tool of choice.
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'];
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
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.