How to Upgrade phpMyAdmin Manually in Linux

1. Backup phpMyAdmin

You should backup your current phpMyAdmin folder by renaming it.

Create a new phpMyAdmin folder

Change to directory

2. Download and Extract phpMyAdmin

Visit the phpMyAdmin download page and look for the .tar.gz URL and download it using wget. In this guide, we are using version 4.8.3. If you are using a later version, make sure to change the commands below to match.

Now extract

Once extracted, list folder

You should see a new folder phpMyAdmin-4.8.3-all-languages

We want to move the contents of this folder to /usr/share/phpmyadmin

You can now log back into phpMyAdmin and check the current version.

3. Edit vendor_config.php

If you are seeing an error The $cfg[‘TempDir’] (./tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.

Open vendor_config.php

Press CTRL + W and search for TEMP_DIR

Change line  to

/usr/share/phpmyadmin/libraries/vendor_config.php

You may also see an error The configuration file now needs a secret passphrase (blowfish_secret). The blowfish secret is used by phpMyAdmin for cookie authentication.

Press CTRL + W and search for CONFIG_DIR

Change line to

/usr/share/phpmyadmin/libraries/vendor_config.php

phpMyAdmin will now generate its own blowfish secret based on the install directory.

Save file and exit. (Press CTRL + X, press Y and then press ENTER)

Now log back in to phpMyAdmin and ensure the errors are gone.

4. Cleanup

You can now delete the tar.gz file and the empty folder.

And if you’re certain your new phpMyAdmin install is working correctly you can delete the backup folder.

 

 

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.