Upgrade PhpMyAdmin

[brijendrasial]

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

[handsomechap]

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

[Administrator]

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

[brijendrasial]

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

[Aalesund]

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 Expand

cd /usr/local/cwpsrv/var/services

Make a backup of the old phpMyAdmin into the root directory and pma folder

Code Select Expand

mv pma /root/

Download the latest phpMyAdmin

Code Select Expand

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

Unzip the downloaded archive

Code Select Expand

unzip phpMyAdmin-latest-all-languages.zip

Remove the downloaded archive, it's important to remove it now!

Code Select Expand

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

Rename the "phpMyAdmin" folder to "pma"

Code Select Expand

mv phpMyAdmin-* pma

Delete the included stock config file, it's important!

Code Select Expand

rm -rf pma/config.sample.inc.php

Copy the old CWP config file from the backup to the new phpMyAdmin

Code Select Expand

cp /root/pma/config.inc.php /usr/local/cwpsrv/var/services/pma/

Fix permissions on the files and folders

Code Select Expand

chown -R cwpsvc:cwpsvc pma

Tested and works fine.

[Jack_C]

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

[Jack_C]

^^^^  BUMP PLEASE  ^^^^

[overseer]

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

Code Select Expand

chattr +i <file>
or

Code Select Expand

chattr +i <directory>
So in this case:

Code Select Expand

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

[brahmi]

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

[overseer]

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

[brahmi]

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

[brahmi]

So the latest version of phpmyadmin not compatible with cwp ?

[overseer]

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.

[brahmi]

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

[brahmi]

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