Upgrade PhpMyAdmin

The tutorial below will help you to upgrade PhpMyAdmin
https://blog.bullten.com/upgrading-phpmyadmin-in-centos-web-panel-cwp/

You may want to mention that this requires mysql 5.5+ otherwise you will break phpmyadmin if you try this on the default mysql which ships with CWP

in /scripts folder on every server you have script which will upgrade MySQL and phpMyAdmin.

Even mysql upgrade article is available so one can do that too.

in /scripts folder on every server you have script which will upgrade MySQL and phpMyAdmin.

At this moment "upgrade_mysql" script is too old and outdated because it checks for MYSQL 5.5 instead of MariaDB and phpMyAdmin 4.x

=======================================================
So, here is a manual command for upgrade to the latest phpMyAdmin:

Go to directory

Code: [Select]

cd /usr/local/cwpsrv/var/services
Make a backup of the old phpMyAdmin into the root directory and pma folder

Code: [Select]

mv pma /root/
Download the latest phpMyAdmin

Code: [Select]

wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip
Unzip the downloaded archive

Code: [Select]

unzip phpMyAdmin-latest-all-languages.zip
Remove the downloaded archive, it's important to remove it now!

Code: [Select]

rm -rf phpMyAdmin-latest-all-languages.zip
Rename the "phpMyAdmin" folder to "pma"

Code: [Select]

mv phpMyAdmin-* pma
Delete the included stock config file, it's important!

Code: [Select]

rm -rf pma/config.sample.inc.php
Copy the old CWP config file from the backup to the new phpMyAdmin

Code: [Select]

cp /root/pma/config.inc.php /usr/local/cwpsrv/var/services/pma/
Fix permissions on the files and folders

Code: [Select]

chown -R cwpsvc:cwpsvc pma
Tested and works fine.

Thanks,
I have managed to upgrade to the new version of phpmyadmin
but after 24 hours the script reverts back to the old one again.

What am I doing wrong?
Thanks for the reply

^^^^  BUMP PLEASE  ^^^^

Things I don't want tidied up/reverted behind my back simply get a

Code: [Select]

chattr +i <file>or

Code: [Select]

chattr +i <directory>So in this case:

Code: [Select]

chattr +i /usr/local/cwpsrv/var/services/pma/

Good morning
after I followed the phpmyadmin migration steps without any problem, except that when I access phpmyadmin it asks me to enter the credentials, the interface does not automatically display as before.
Is there a solution or is there a missing step?
THANKS

Is the MySQL root password the same as your system root password?

thank you for your reply
I did not change my password, I followed exactly the steps quoted by "Aalesund" even if I introduced user root and the password does not work

So the latest version of phpmyadmin not compatible with cwp ?

No, that's not true at all. I deployed the latest phpMyAdmin 5.2.1 yesterday on all my servers. Follow Sandeep's directions here, replacing any instance of "4.9.2" with "5.2.1":
https://www.uxlinux.com/how-to-update-phpmyadmin-latest-version-on-cwp-centos-webpanel/

Also, the link to the Blowfish hash generator is no longer working, so Google a different one.

i will try it and i will give you the answer
THANKS

I just followed the steps one by one I still have the same problem it asks me to introduce user and password.