Minimal illustration with a stylized sailboat (phpMyAdmin logo) on a soft yellow background and the text ‘Manually Upgrade phpMyAdmin.

How to Manually Upgrade phpMyAdmin on Linux

Last updated on | 566 replies

Introduction

This guide shows you how to manually upgrade phpMyAdmin on most major Linux distributions (e.g., Ubuntu, Debian, CentOS, Fedora). While tested on Ubuntu 24.04 running PHP 8, the steps are similar on other distros—just be sure to adjust file paths and package-manager commands if needed. If you have any issues, let me know in the comments.

Alternative Upgrade Methods (Package Managers, Control Panels, Docker)

While this guide focuses on manually upgrading phpMyAdmin by downloading the source files, you may not need these steps if:

  • Package Managers (e.g., apt, yum, dnf, brew): If you installed phpMyAdmin with apt-get (Debian/Ubuntu) or yum/dnf (CentOS/Fedora), simply run:
    sudo apt-get update && sudo apt-get upgrade phpmyadmin
    or
    sudo yum update phpMyAdmin (CentOS/Fedora).
    Note that some distributions may lag behind the latest release.
  • Hosting Control Panels (e.g., cPanel, Plesk): In many shared hosting environments, phpMyAdmin is updated automatically through the control panel, so manual upgrades might break existing integrations.
  • Docker/Container Environments: If you are running phpMyAdmin as a container, you can pull the latest Docker image (docker pull phpmyadmin) and recreate your container instead of manually downloading tarballs.

If you still prefer or need the latest release straight from source (for instance, your package repositories are outdated), then the steps below are the correct way to manually upgrade your phpMyAdmin installation.

1. Back Up phpMyAdmin

If you followed this guide before, make sure to delete any previous backup directory you created.

sudo rm -rf /usr/share/phpmyadmin.bak

Next, back up your current phpMyAdmin folder by renaming it:

sudo mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bak

Create a new phpMyAdmin folder (adjust this path if your distro or setup uses a different location, such as /var/www/html/phpmyadmin):

sudo mkdir /usr/share/phpmyadmin/

Then change directory:

cd /usr/share/phpmyadmin/

2. Download and Extract phpMyAdmin

phpMyAdmin 5.2.2 (released Jan 2025) requires PHP 7.2 or newer and MySQL/MariaDB 5.5 or newer. To find your PHP version via the command line, run php -v. If you need to upgrade PHP, check out this guide: How to Upgrade from PHP 7.x to PHP 8 on Ubuntu.

  • For PHP 7.2 or newer, download phpMyAdmin 5.2.2.
  • For PHP 7.1, download phpMyAdmin 5.1.4.
  • For PHP 5.5 to PHP 7.4, download phpMyAdmin-4.9.11.

Visit the phpMyAdmin download page and locate the .tar.gz URL. In this guide, we’re using version 5.2.2 (released Jan 2025). If a later version is available, be sure to change the commands accordingly (and let me know in the comments so I can update the guide!).

Download phpMyAdmin (Note: you can also verify checksums from the official site or use GPG signatures to ensure file integrity):

sudo wget https://files.phpmyadmin.net/phpMyAdmin/5.2.2/phpMyAdmin-5.2.2-all-languages.tar.gz

Extract the archive:

sudo tar xzf phpMyAdmin-5.2.2-all-languages.tar.gz

Once extracted, list the folder contents:

ls

You should see a folder named phpMyAdmin-5.2.2-all-languages. Move its contents to /usr/share/phpmyadmin (or /var/www/html/phpmyadmin, if that’s where your existing install is):

sudo mv phpMyAdmin-5.2.2-all-languages/* /usr/share/phpmyadmin

Log into phpMyAdmin to confirm the upgrade. You may see two errors:

3. Fixing Common phpMyAdmin Errors

You may see the error The configuration file needs a valid key for cookie encryption. A temporary key was automatically generated for you. Please refer to the documentation.

This means you should create a unique key for your phpMyAdmin install. phpMyAdmin first loads /usr/share/phpmyadmin/libraries/config.default.php and then overrides those values with anything found in /usr/share/phpmyadmin/config.inc.php. If you had custom settings before, make sure to merge them into your new config file instead of starting completely over.

Create config.inc.php (again, adjust directory paths if you placed phpMyAdmin elsewhere):

sudo nano /usr/share/phpmyadmin/config.inc.php

Generate your own 32-character blowfish secret (e.g., using this generator) and paste it into config.inc.php:

/usr/share/phpmyadmin/config.inc.php 
<?php
// Use here a value of your choice 32 chars long
$cfg['blowfish_secret'] = 'PASTE__32__CHAR__BLOWFISH_SECRET';

$i=0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'cookie';

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

Log out and back in to phpMyAdmin to confirm the error is gone.

3.2. “$cfg[‘TempDir’] (/usr/share/phpmyadmin/tmp/) is not accessible” error

If you see The $cfg[‘TempDir’] (/usr/share/phpmyadmin/tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.

You need to create this directory and make it writable:

sudo mkdir /usr/share/phpmyadmin/tmp
sudo chown -R www-data:www-data /usr/share/phpmyadmin/tmp
sudo chmod 750 /usr/share/phpmyadmin/tmp

Again, log out and log back in to confirm the error is resolved.

4. Clean Up

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

sudo rm /usr/share/phpmyadmin/phpMyAdmin-5.2.2-all-languages.tar.gz
sudo rm -rf /usr/share/phpmyadmin/phpMyAdmin-5.2.2-all-languages

If you’re certain your new phpMyAdmin install is working correctly, you can delete the backup folder as well:

sudo rm -rf /usr/share/phpmyadmin.bak

That’s all! Enjoy your updated phpMyAdmin installation.

Let me know if this helped. Follow me on Twitter, Facebook and YouTube, or 🍊 buy me a smoothie.

566 replies

Leave a reply

Your email address will not be published. Required fields are marked *

  5. This was excellent – clearly written and bang up to date and all worked smoothly and well. Thank you so much!

    Reply

  10. THANK YOU!! I have seen and tried to follow so many TUT’s, and too often they’re missing some final step, or outdated, or just not helpful. Within minutes my annoying MYSQL server has morphed into an error free and comfortable environment in which we can work.

    Really, excellent job!

    Reply

  13. I encountered multiple errors after installing the default PhpMyAdmin version 4.6.6.deb5 that came with my Ubuntu 18.04 distribution. Your guide solved them all in one fell swoop. Excellent instructions and many thanks!

    Reply

  14. It would have been absolutely possible to figure that out, but this fine turn-by-turn manual sped up the whole operation in the most pleasant way.

    T H A N K _ Y O U very much

    Reply

  16. How to automate this on a simple script:

    $ nano phpmyadmin_update.sh 

    echo "Backing up"
mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bak

echo "Getting lastest PHPMyAdmin version..."
mkdir /usr/share/phpmyadmin/
cd /usr/share/phpmyadmin/
wget https://files.phpmyadmin.net/phpMyAdmin/4.9.0.1/phpMyAdmin-4.9.0.1-all-languages.tar.gz
tar xzf phpMyAdmin-4.9.0.1-all-languages.tar.gz
mv phpMyAdmin-4.9.0.1-all-languages/* /usr/share/phpmyadmin

echo "Updating vendor_config"
sed -i -r "s/('TEMP_DIR'\s*,)[^\)]*/\1 '\/var\/lib\/phpmyadmin\/tmp\/'/" /usr/share/phpmyadmin/libraries/vendor_config.php
sed -i -r "s/('CONFIG_DIR'\s*,)[^\)]*/\1 '\/etc\/phpmyadmin\/'/" /usr/share/phpmyadmin/libraries/vendor_config.php

echo "Cleaning up..."
rm /usr/share/phpmyadmin/phpMyAdmin-4.9.0.1-all-languages.tar.gz
rm -rf /usr/share/phpmyadmin/phpMyAdmin-4.9.0.1-all-languages
rm -rf /usr/share/phpmyadmin.bak

echo "Done!"
echo
    Reply

    1. For future reference, this is the updated script to download the last stable version of PHPMyAdmin:

      `echo
      echo “Backing up”
      mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bak

      echo “Getting lastest PHPMyAdmin version…”
      mkdir -p /usr/share/phpmyadmin/
      cd /usr/share/phpmyadmin/
      wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz
      tar xzf phpMyAdmin-latest-all-languages.tar.gz
      mv phpMyAdmin-/ /usr/share/phpmyadmin

      echo “Updating vendor_config”
      sed -i -r “s/(‘TEMP_DIR’\s,)[^)]/\1 ‘\/var\/lib\/phpmyadmin\/tmp\/’/” /usr/share/phpmyadmin/libraries/vendor_config.php
      sed -i -r “s/(‘CONFIG_DIR’\s,)[^)]/\1 ‘\/etc\/phpmyadmin\/’/” /usr/share/phpmyadmin/libraries/vendor_config.php

      echo “Cleaning up…”
      rm /usr/share/phpmyadmin/phpMyAdmin-latest-all-languages.tar.gz
      rm -rf /usr/share/phpmyadmin/phpMyAdmin-*
      rm -rf /usr/share/phpmyadmin.bak

      echo “Done!”
      echo
      `

      Reply