How to Update phpMyAdmin to the Latest Version in CyberPanel (CentOS 8 & Ubuntu)

Introduction

In this tutorial, you'll learn how to update phpMyAdmin in CyberPanel to the latest version on both CentOS 8 and Ubuntu. This guide ensures compatibility with PHP 7.1+ and MySQL/MariaDB 5.5+.

---

Updating phpMyAdmin on CentOS 8

Step 1: Log in to Your Server as Root

ssh root@YOUR_IP_ADDRESS

Step 2: Navigate to the CyberPanel Public Directory

cd /usr/local/CyberCP/public/

Step 3: Back Up the Current phpMyAdmin Folder

cp -r phpmyadmin phpmyadmin.old

Step 4: Remove the Current phpMyAdmin Folder

rm -rf phpmyadmin

Step 5: Install wget

sudo yum install wget -y

Step 6: Download the Latest phpMyAdmin Version

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

Step 7: Unzip the Downloaded File

unzip phpMyAdmin-5.2.2-all-languages.zip

Step 8: Rename the Folder for CyberPanel Recognition

mv phpMyAdmin-5.2.2-all-languages phpmyadmin

Step 9: Restore Configuration Files

cp -r phpmyadmin.old/config.inc.php phpmyadmin
cp -r phpmyadmin.old/phpmyadminsignin.php phpmyadmin
cp -r phpmyadmin.old/tmp phpmyadmin

Step 10: Remove Temporary Files

cd phpmyadmin/tmp/twig
rm -rf *

Step 11: Set Folder Permissions

chown -R lscpd:lscpd /usr/local/CyberCP/public/phpmyadmin/tmp
chmod -R 755 /usr/local/CyberCP/public/phpmyadmin/tmp/twig

Step 12: Adjust Permissions if Needed

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

Step 13: Remove Old phpMyAdmin Folder

rm -rf /usr/local/CyberCP/public/phpmyadmin.old

Step 14: Remove the Downloaded ZIP File

rm -rf phpMyAdmin-5.2.2-all-languages.zip

Step 15: Access phpMyAdmin

https://YOUR_SERVER_IP:8090/dataBases/phpmyadmin

---

Updating phpMyAdmin on Ubuntu

Step 1: Log in to Your Server as Root

ssh root@YOUR_IP_ADDRESS

Step 2: Navigate to the CyberPanel Public Directory

cd /usr/local/CyberCP/public/

Step 3: Back Up the Current phpMyAdmin Folder

cp -r phpmyadmin phpmyadmin.old

Step 4: Remove the Current phpMyAdmin Folder

rm -rf phpmyadmin

Step 5: Install wget

sudo apt update && sudo apt install wget -y

Step 6: Download the Latest phpMyAdmin Version

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

Step 7: Unzip the Downloaded File

unzip phpMyAdmin-5.2.2-all-languages.zip

Step 8: Rename the Folder for CyberPanel Recognition

mv phpMyAdmin-5.2.2-all-languages phpmyadmin

Step 9: Restore Configuration Files

cp -r phpmyadmin.old/config.inc.php phpmyadmin
cp -r phpmyadmin.old/phpmyadminsignin.php phpmyadmin
cp -r phpmyadmin.old/tmp phpmyadmin

Step 10: Remove Temporary Files

cd phpmyadmin/tmp/twig
rm -rf *

Step 11: Set Folder Permissions

chown -R lscpd:lscpd /usr/local/CyberCP/public/phpmyadmin/tmp
chmod -R 755 /usr/local/CyberCP/public/phpmyadmin/tmp/twig

Step 12: Adjust Permissions if Needed

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

Step 13: Remove Old phpMyAdmin Folder

rm -rf /usr/local/CyberCP/public/phpmyadmin.old

Step 14: Remove the Downloaded ZIP File

rm -rf phpMyAdmin-5.2.2-all-languages.zip

Step 15: Access phpMyAdmin

https://YOUR_SERVER_IP:8090/dataBases/phpmyadmin

---

Conclusion

By following these steps, you can successfully update phpMyAdmin in CyberPanel to the latest version on CentOS 8 and Ubuntu. If you encounter any issues, ensure proper file permissions and configurations are maintained. Happy updating!