How to Manually Upgrade phpMyAdmin on Ubuntu

    RahulBy 2 Mins ReadUpdated:

    I have running Ubuntu 18.04 on my workstation. I have the phpMyAdmin older version installed on it. Initially, the phpMyAdmin was installed through the apt package manager.

    phpMyAdmin installation via Apt package manager create multiple directories:

    • /etc/phpmyadmin – Configuration files
    • /var/lib/phpmyadmin – Library and tmp directries
    • /usr/share/phpmyadmin – Main phpMyAdmin installation

    Step 1 – Backup phpMyAdmin

    You should take a back up of your current phpMyAdmin directory. However, I have just renamed it to phpmyadmin.bak at the same location.

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

    Step 2 – Download Latest phpMyAdmin

    Now, download the latest phpMyAdmin archive file from its official download page. During last update of this article phpMyAdmin 4.8.5 is latest version available for download.

    wget www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip
unzip phpMyAdmin-latest-all-languages.zip

    You will see a directory phpMyAdmin-[VERSION]-all-languages in the current location. Move this latest directory to the appropriate location.

    sudo mkdir /usr/share/phpmyadmin
sudo mv phpMyAdmin-*/* /usr/share/phpmyadmin/

    Step 3 – Update Configuration

    As I told the existing phpMyAdmin was installed with Apt package manager. Therefore you need to specify the TEMP_DIR and CONFIG_DIR location under the vendor_config.php file.

    Edit vendor_config.php file in your favorite text editor

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

    and update the following values.

    define('TEMP_DIR', '/var/lib/phpmyadmin/tmp/');
define('CONFIG_DIR', '/etc/phpmyadmin/');

    Save the file and access the phpMyAdmin in a web browser.

    Manually Upgrade phpMyAdmin

    All done. In conclusion, you have the latest phpMyAdmin running on your Ubuntu system.

    Share.

    Related Posts

    22 Comments

    1. João on

      Thank you, but I’m having error

      PHP 7.1.3+ is required.
      Currently installed version is: 7.0.33-57+ubuntu18.04.1+deb.sury.org+1

      when I run php –version I have 7.4

      Which php version does phpmyadmin uses?

      Reply
    3. sathiyaraj on

      Nice article. But some code errors occurred. (Ex) – sudo mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bak its worng (sudo mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.pak)

      Reply
    14. Arturo on

      Excellent article, impeccable, clear and perfect! It helped me and it was very simple following your instructions. Greetings from Peru!

      Reply
    16. garsax on

      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

    Leave A Reply