In this tutorial, we’ll show you how to install phpMyAdmin.
This tutorial assumes you have already connected your server to ServerPilot and that you have created at least one app on the server.
Follow these steps to install phpMyAdmin:
- Upload and extract the phpMyAdmin archive.
- Rename and edit the configuration file.
- Log in to 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 (e.g., serverpilot) 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 newphpMyAdmin 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 renameconfig.sample.inc.php to config.inc.php.
Now, open config.inc.php and set a random string of characters for the value of
$cfg['blowfish_secret'] near the top of the file.
$cfg['blowfish_secret'] = 'asdof7q230984(*^3q4'
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 ServerPilot for any app on this server.