How to update phpMyAdmin to the latest version in cyberpanel

Master3395 · January 27, 2022, 8:20pm

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 the wget command.
Go to this website in order to find the link to the latest download later on.

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

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

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

9.
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

10.
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 755 permission as show below)’

11.
Run the command below

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

12.
If changing it to 755 does not work you can continue to change folder permissions to 777.

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

13.

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

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

15.
Delete the zip folder:
rm -rf /usr/local/CyberCP/public/phpMyAdmin-5.2.0-all-languages.zip

16.
Now access your PHPMyAdmin to check out the link below and change your port if you use another one.
https://:8090/dataBases/phpmyadmin

shoaibkk · January 28, 2022, 6:30am

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

Master3395 · January 28, 2022, 7:21am

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

Master3395 · May 20, 2022, 8:58pm

@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

tmoore · August 14, 2022, 6:05pm

Just stole this into mine, very good idea

tmoore · August 14, 2022, 6:42pm

I was reviewing it to finish the implementation here.
Noticed the 777 permissions.
Here I manually created the folder so the behavior may be different but, you don’t need to change its permissions but rather the owner, as it’s not the root but lscpd whos using the folder:

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

Master3395 · August 14, 2022, 6:54pm

Default permission for that folder is 755 also, but I figured 777 didn’t change much anyways

Master3395 · August 14, 2022, 7:19pm

I added it to the original post, and changed it a little on part 11 and up.

Ernest · January 15, 2023, 12:47am

@usmannasir can u make a video tutorial How to update phpMyAdmin to the latest version in cyberpanel

Master3395 · January 15, 2023, 12:51am

Try this method for now

tbaldur/cyberpanel-mods: Small changes to cyberpanel core installation (github.com)

manualsnow · February 26, 2023, 11:15pm

Why not simply update phpMyAdmin to latest stable v5.2.1 (released 2023-02-08) in the next build / commit of CyberPanel?

phpMyAdmin v5.2.x came out almost a year ago

Syams · April 28, 2023, 3:13pm

Hi @Master3395 Please help me. I can’t access my Phpmyadmin after use this step

Please, how to restore?

4.
Remove current phpmyadmin folder
rm -rf phpmyadmin

Capture phpmyadmin

Master3395 · April 28, 2023, 3:22pm

Try this one, and choose 5.2.1.

sh <(curl https://raw.githubusercontent.com/tbaldur/cyberpanel-mods/main/phpmyadmin_v_changer.sh || wget -O - https://raw.githubusercontent.com/tbaldur/cyberpanel-mods/main/phpmyadmin_v_changer.sh)

Syams · April 28, 2023, 3:33pm

Ok, what next? I still can’t access my Phpmyadmin

Syams · April 28, 2023, 4:15pm

Help. I can’t access my PHPMYadmin

flextypesite · April 28, 2023, 4:59pm

@Syams you need first upgrade cyberpanel to orgin with
sh <(curl https://raw.githubusercontent.com/usmannasir/cyberpanel/stable/preUpgrade.sh || wget -O - https://raw.githubusercontent.com/usmannasir/cyberpanel/stable/preUpgrade.sh)

after you reboot then see what happend if all normal can use the link they give

sh <(curl https://raw.githubusercontent.com/tbaldur/cyberpanel-mods/main/phpmyadmin_v_changer.sh || wget -O - https://raw.githubusercontent.com/tbaldur/cyberpanel-mods/main/phpmyadmin_v_changer.sh)

choose 5.2.1

reboot again then update os and looks if works

Syams · April 28, 2023, 5:20pm

@flextypesite
It seems stuck on upgrade cyberpanel to origin proccess

flextypesite · April 28, 2023, 5:34pm

more details need for this theres some missing you removed some more then whas need what linux os you use and version

Syams · April 28, 2023, 5:42pm

@flextypesite Ubuntu 20.04.6

Syams · April 28, 2023, 5:59pm

Ok, now I can access Phpmyadmin, but version of MariaDB & Phpmyadmin still old
How to update properly?