Articles

How to Install phpMyAdmin

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:

  1. Upload and extract the phpMyAdmin archive.
  2. Rename and edit the configuration file.
  3. Log in to phpMyAdmin.
One installation of phpMyAdmin can be used to log in to any database belonging to any app. You do not need to install phpMyAdmin for each app.

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 (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 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 characters for the value of $cfg['blowfish_secret'] near the top of the file.

For example:

$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.


Last updated: August 07, 2017