1. Home
  2. WordPress VPS
  3. How to install phpMyAdmin on WPjane

How to install phpMyAdmin on WPjane

phpMyAdmin is a free database management tool that enables you to access and make changes to your WordPress MySQL database on your WPjane server.

In WPjane, WordPress runs directly on the server. For security reasons, there isn’t a simple backend administrative interface where you can access phpMyAdmin as found in other software running WordPress (like cPanel).

Instead, phpMyAdmin on WPjane must first be installed and then accessed via a standard browser window in Chrome or Firefox.

You can either install phpMyAdmin yourself on the command line using this tutorial if you feel comfortable working in an OpenSSH client, or request HostJane support to install it for you for a one-off $15 admin fee.

1. Download the latest version of phpMyAdmin

The first step is to get hold of the latest version of phpMyAdmin, which can be downloaded as a zip file to your local computer.

phpmyadmin-download

Click the green download button or the .zip file on the top line of the phpMyAdmin latest releases.

2. Login to your server with FileZilla

How to I connect with FTP? – Use HostJane’s FTP tutorial to connect to your VPS.

Where’s my WPjane server’s IP and root password? Locate your server’s credentials in the Statistics dashboard of your server in My HostJane.

Learn more in this WordPress Set Up tutorial.

Open FileZilla and connect with FTP to your WPjane server.

Host: sftp://[Your_Server’s_IP]
Username: root
Password: [Your_Server’s_Password] as found in Statistics of My HostJane
Port: 22

Navigate to this directory using FileZilla:

/var/www/html

In FileZilla, after you open the directory, the open /html folder will look as follows:

ftp-var-www-html

3. Upload phpMyAdmin’s latest release to the /html folder

In the filezilla left-hand window showing your desktop contents, navigate to the phpMyAdmin zip file you downloaded in Step 1.

Double-click it to upload it to your WPjane server’s /html folder.

upload-phpmyadmin

You should be able to see the uploaded document in the right-hand server window when the 10MB file upload completes:

server-window-FTP

4. Unzip the uploaded phpMyAdmin zip file on the server

You cannot unzip files remotely using FTP. You need to login to your server on the command line to unzip the phpMyAdmin folder.

On Windows machines, login your server using PuTTY

In linux and MacOS, login to your server with HostJane’s OpenSSH guide.

After logging in, type this command to change directory to /html:

cd /var/www/html

Then unzip the file:

unzip phpMyAdmin-4.8.2-all-languages.zip

Replace phpMyAdmin-4.8.2-all-languages.zip with the latest version phpMyAdmin of the one you downloaded.

Press Enter

You will see the phpMyAdmin zip being inflated into a directory folder on your WPjane server, and stopping with a lint-query

inflating-phpmyadmin

5. Change the phpMyAdmin directory to janeadmin for security

To protect phpMyAdmin, change the directory name to janeadmin

mv phpMyAdmin-4.8.2-all-languages janeadmin

Press Enter. The cursor will move to the next line, and nothing will have appeared to have happened.

However, if you refresh your FileZilla window, you’ll see a new folder at the top of the tree, janeadmin. You can now visually confirm that the phpMyAdmin folder has been successfully changed.

janeadmin-folder-appears

6. Create a configuration file for phpMyAdmin

Change the directory of your prompt user to janeadmin

cd janeadmin

Copy config.sample.inc.php and rename the copy to config.inc.php

cp config.sample.inc.php config.inc.php

Now open config.inc.php with nano, the command-line text editor.

nano config.inc.php

You will open the file with nano:

blowfish-secret

Move the cursor to $cfg['blowfish_secret'] = '';

Enter a secret in the ” for blowfish_secret, for example:

$cfg['blowfish_secret'] = 'janedoerocks-2837*2022o6)477sgrg';

You should use a random string of numbers, symbols, and letters of at least 32 characters and no more than 46 characters long for your blowfish secret

Write the changes with ctrl + O and press Enter to save the changes

Now exit back to the command line, with ctrl + x

6. Visit phpMyAdmin in the browser

Pull up a fresh browser window like Chrome, and enter into the address bar:

https://[Your_Server’s_IP]/janeadmin

phpmyadmin-browser

7. Find out your phpMyAdmin root password

You will sign in to phpMyAdmin with the root user.

To find out the root password to login to the phpMyAdmin management tool, enter on the command line of your WPjane server:

cat /root/.my.cnf

Make sure you are logged into the server (via OpenSSH or PuTTY) as the root user

phpMyAdmin’s root‘s password will then be published on the command line for you to view.

phpMyAdmin-password-mysql

Enter these details into your phpMyAdmin running in the Chrome browser:

Username: root
Password: [As shown in the terminal shell]

You can then login to your browser:

phpMyAdmin-logged-in

Before you enjoy your phpMyAdmin tool, it’s important to keep it safe.

8. How to secure your phpMyAdmin installation

As you can imagine, you wouldn’t want the wrong person to obtain access to your WordPress databases.

To ensure only authorized users can edit and make changes to your phpMyAdmin on the WordPress server, we highly recommend you put the login portal behind a password-secured screen that only you have access to.

security-phpmyadmin-shield

First, create an encrypted password by typing:

openssl passwd

Set and verify a unique password

Use HostJane’s strong password generator to choose a secure, random password for your site.

In the example below, we used: 123456

The terminal returned an encrypted pass for 123456 of: Gc0VLaNLNhXoY

security-phpmyadmin-passwd

Next, go to the htpasswd directory:

cd /etc/nginx/htpasswd/

Your prompt should change to:

root@host:/etc/nginx/htpasswd/$

Using the nano command-line text editor to create a new file in the directory, such as sizzler

You can replace sizzler with any username

nano sizzler

The new file will open:

security-phpmyadmin-newfile

Enter your credentials in the format: Username : Encrypted password

In the above example, we input:

sizzler : Gc0VLaNLNhXoY

security-phpmyadmin-sizzler

Write changes to the file with: ctrl + O and press Enter to save

Now exit with ctrl + x

Change directory again to:

cd /etc/nginx/conf.d

You need to nano edit 2 different (but very similar looking) files in this directory:

wordpress_http.conf

wordpress_https.conf

After changing to the /conf.d directory, first edit wordpress_http.conf

nano wordpress_http.conf

Find the line starting: location ^~ /wp-admin/ {

wordpress_http.conf

Change /wp-admin/ to /janeadmin/

Next, move the cursor 2 lines down to find :

auth_basic_user_file /etc/nginx/htpasswd/wp-admin;

Change /wp-admin/ to sizzler or the username you selected.

Write changes to the file with: ctrl + O and press Enter to save

Now exit with ctrl + x

The final result should look like:

changed-conf

Now make the same edits to the second file: wordpress_https.conf

Finally, restart Nginx to apply changes:

systemctl restart nginx

Congratulations! You have now successfully set up a password screen to login to phpMyAdmin on your WPjane server.

When logging into phpMyAdmin, at the security prompt, you would enter:

Username: sizzler (or your chosen username)
Password: 123456 (or your chosen password)

phpMyAdmin is now safely behind locked doors for your use only.

Updated on October 24, 2018

Was this article helpful?