How to update phpMyAdmin to the latest version in cyberpanel

Blog Posts
,
#1

How to update phpMyAdmin to the latest version in cyberpanel

In this tutorial, you’ll learn how to update your PhpMyAdmin in CyberPanel to the latest version.

NOTICE: Current version compatible with PHP 7.1 and newer and MySQL/MariaDB 5.5 and newer.

  1. log in to your server as the root user
    ssh root@YOUR_IP_ADDRESS.

  2. Go to
    cd /usr/local/CyberCP/public/

  3. Back up your phpmyadmin folder.
    cp -r /usr/local/CyberCP/public/phpmyadmin /usr/local/CyberCP/public/phpmyadmin.old

  4. Remove current phpmyadmin folder
    rm -rf phpmyadmin

  5. Install wget
    sudo yum install wget

  6. Download the new version from the PHPMyAdmin website, and 5.2.0 is the latest at this moment, so use wget command.
    Go to this website in order to find the link to the latest download later on.
    phpMyAdmin - Downloads

wget https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-all-languages.zip

  1. Unzip it
    unzip phpMyAdmin-5.2.0-all-languages.zip

  2. Rename the folder so cyberpanel can recognize it
    mv phpMyAdmin-5.2.0-all-languages phpmyadmin

  3. Copy config files from phpmyadmin.old into the new folder. (Config and Auto Login using CyberPanel)

cp -r /usr/local/CyberCP/public/phpmyadmin.old/config.inc.php /usr/local/CyberCP/public/phpmyadmin
cp -r /usr/local/CyberCP/public/phpmyadmin.old/phpmyadminsignin.php /usr/local/CyberCP/public/phpmyadmin
cp -r /usr/local/CyberCP/public/phpmyadmin.old/tmp /usr/local/CyberCP/public/phpmyadmin
  1. Remove temp files in the twig folder.
cd /usr/local/CyberCP/public/phpmyadmin/tmp/twig
rm -rf *

(If your PHPMyAdmin says it cannot be accessed, you may give the folder 777 permission)

chmod -R 777 /usr/local/CyberCP/public/phpmyadmin/tmp/twig

cd /usr/local/CyberCP/public/phpmyadmin/tmp/twig

Delete the old phpmyadmin folder:
rm -rf /usr/local/CyberCP/public/phpmyadmin.old

  1. Now access your PHPMyAdmin to check out the link below change your port if you use another one.
    https://:8090/dataBases/phpmyadmin
1 Like
Include latest version of mariadb 10.6 in default build
Auto Update phpMyAdmin
#2

Better to use the official version with cyberpanel. And yes you gave the right things to update

#3

True, just giving a tutorial for people who might benefit from using an up to date PHPMyAdmin before CyberPanel gets the latest version :slight_smile:

#4

@usmannasir Do you think there is a way to integrate the commands I got over or a similar setup when upgrading CyberPanel?

You can even clone the GitHub page Master to the folder and use that?
That way it’s more automated and people won’t complain of outdated phpMyAdmin anymore, they would then just upgrade CyberPanel.

git clone https://github.com/phpmyadmin/phpmyadmin.git

2 Likes