L) How to install phpMyAdmin on JungleWP
This tutorial assumes you have already a Pod (server) and that you have at least your SFTP access (Pod user credentials).
Follow these steps to install phpMyAdmin:
- Upload and extract the phpMyAdmin archive.
- Rename and edit the configuration file.
- Log in to phpMyAdmin.
Upload phpMyAdmin
First, visit www.phpmyadmin.net/home_page/downloads.php in your browser and download the most recent .tar.gz archive. The file will be named something like phpMyAdmin-4.X.Y-all-languages.tar.gz, where X and Y are version numbers.
Then, upload the phpMyAdmin archive to your server using SFTP.
In Cyberduck (or your prefered SFTP client), log in to your server with the system user the app belongs to and navigate to public, your app's web root folder.
Select and drag the archive file into your app's public folder in Cyberduck.
Next, click once on the phpMyAdmin archive and select Expand Archive from the Cyberduck File menu.
When the file has decompressed, delete the archive and rename the new phpMyAdmin folder to something hard to guess. In this example, we used the random string "F24PG9C3", but you should make up your own.
Rename and Edit the Configuration File
Open your new phpMyAdmin folder on your server and rename config.sample.inc.php to config.inc.php.
Now, open config.inc.php and set a random string of at least 32 characters for the value of $cfg['blowfish_secret'] near the top of the file.
For example:
$cfg['blowfish_secret'] = 'f7q230984(*^3q42bd^$4353yow*q5Trs^1'
Logging In to phpMyAdmin
You should now be able to bring up phpMyAdmin through this subdirectory of your domain (e.g., http://example.com/phpMyAdmin-F24PG9C3/) in your browser. If you have more than one app on your server, you will access all of your databases by signing in with their correct credentials through this phpMyAdmin installation and domain.
You can log in to phpMyAdmin using any database name, username, and password that you've created through JungleWP for any website on this Pod (server).