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.

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 *

  1. Worked 100% with no fuss and no re-trying. Thank you a million times for this clear and concise contribution.

  2. FOR THEOSE WHO has the error “The phpMyAdmin configuration storage is not completely configured” and NOBODY here helped:

    ubuntu – log in console server root
    and type these comands one by one:

    mysql
    GRANT ALL PRIVILEGES ON *.* TO ‘you.user.witch.you.use.in.phpmyadmin.log.in.page’@’localhost’ WITH GRANT OPTION;
    FLUSH PRIVILEGES;

    DONE – it will give permission to user to create the missing tables for the user in cause!

  3. Good stuff!
    Instead of 777 for the tmp directory, I’d suggest:
    sudo chown root:www-data /usr/share/phpmyadmin/tmp
    sudo chmod g+rwxs /usr/share/phpmyadmin/tmp

    Assuming www-data is the apache system user, and root is the current owner, this adds apache as a the group and gives it permission to create and manage its own files there without giving access to everyone on the system.

  4. Hi,

    Upgrading worked, thanks for the nice how-to.

    Perhaps any idea how I can change my Server charset from cp1252 West European (latin1) to UTF-8 Unicode (utf8mb4)?

    Cheers!

    1. Try:

      sudo nano /etc/mysql/my.cnf

      Paste in

      [client]
      default-character-set=utf8mb4
      
      [mysql]
      default-character-set=utf8mb4
      
      [mysqld]
      collation-server = utf8mb4_unicode_520_ci

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

      Restart MySQL

      sudo service mysql restart