New in CWP Edge-LatestFree with every CWPpro licenceWebsites up to 300x faster

CWP now includes LSPHP, LSAPI-Cache and CWP Cage at no extra cost with all CWPpro licences. The LSAPI-Cache plugin is integrated into our WordPress and other script installers, and CWP Cage gives every user complete isolation. Available now in the CWP Edge-Latest version.

Get CWPpro ›

How to update phpMyAdmin to latest version without breaking CWP?

Started by its_me_rbk, August 15, 2025, 06:56:59 AM

Previous topic - Next topic

its_me_rbk

phpMyAdmin is in version 5.1.1 now, and the latest stable version is 5.2.2, as it says the same in it.

Version information: 5.1.1, latest stable version: 5.2.2

Is there any update script for this, or any KB article regarding this?
I'm currently using AlmaLinux 9.6 & CWP Free with version 0.9.8.1210.

overseer

I've manually updated on one server in the past and it didn't seem to break anything. But one thing that gives me pause is Sandeep's advice to let it update with CWP because it's customized:
https://www.alphagnu.com/topic/525-update-phpmyadmin-to-latest-currently-521/#comment-1235

cyberspace

According to:

https://docs.phpmyadmin.net/en/latest/setup.html#upgrading-from-an-older-version


cd /usr/local/cwpsrv/var/services
mv pma pma_old
wget https://files.phpmyadmin.net/phpMyAdmin/5.2.2/phpMyAdmin-5.2.2-all-languages.zip
unzip phpMyAdmin-5.2.2-all-languages.zip
rm -rf phpMyAdmin-5.2.2-all-languages.zip
mv phpMyAdmin-5.2.2-all-languages pma
cp pma_old/config.inc.php pma
chown -R cwpsvc:cwpsvc pma


if phpMyAdmin doesn't work after upgrade then:

cd /usr/local/cwpsrv/var/services
rm -rf pma
mv pma_old pma

its_me_rbk


Starburst

@cyberspace

Looks like it worked on AL 9.6 with CWP 0.9.81210

Had to login with the MySQL password CWP displays at the end of installation:

But at the bottom it has:
QuoteThe phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

its_me_rbk

@starburst

QuoteThe phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

I saw this before upgrading, in version 5.1.1 also.

Starburst

Never noticed it there before.

But you are correct, it is there with 5.1.1

its_me_rbk

@Starburst

Did you face any issues after updating phpMyAdmin? I've planned to update it on my production server, that's why I asked about it.

overseer

I never noticed any issues on the updated version (apart from autologin having issues). 5.2 drops support for versions of php older than 7.2, so that won't matter if you are running AlmaLinux 9. It would only matter if you are running AL8 with older PHP versions.

Differences between 5.1.1 and 5.2.2:

  • Import/Export Screen Redesign:
    phpMyAdmin 5.2.2 features a redesigned import and export interface, making it more modern and organized.

  • "DELETE FROM" Feature:
    A new "DELETE FROM" feature is added to the table operations page, allowing users to empty tables using a DELETE query.

  • Minimum PHP Version:
    phpMyAdmin 5.2.2 requires PHP 7.2 or newer, whereas 5.1.1 may have supported older PHP versions.

  • Internet Explorer Support Removed:
    phpMyAdmin 5.2.2 no longer supports Microsoft Internet Explorer.

  • New Features and Bug Fixes:
    Version 5.2.2 includes a range of new features and bug fixes, including resolution of networking errors when exporting files and improved handling of PHP 8.1.

Starburst

Quote from: overseer on August 16, 2025, 06:22:59 PM
I never noticed any issues on the updated version (apart from autologin having issues). 5.2 drops support for versions of php older than 7.2, so that won't matter if you are running AlmaLinux 9. It would only matter if you are running AL8 with older PHP versions.

Differences between 5.1.1 and 5.2.2:

  • Import/Export Screen Redesign:
    phpMyAdmin 5.2.2 features a redesigned import and export interface, making it more modern and organized.

  • "DELETE FROM" Feature:
    A new "DELETE FROM" feature is added to the table operations page, allowing users to empty tables using a DELETE query.

  • Minimum PHP Version:
    phpMyAdmin 5.2.2 requires PHP 7.2 or newer, whereas 5.1.1 may have supported older PHP versions.

  • Internet Explorer Support Removed:
    phpMyAdmin 5.2.2 no longer supports Microsoft Internet Explorer.

  • New Features and Bug Fixes:
    Version 5.2.2 includes a range of new features and bug fixes, including resolution of networking errors when exporting files and improved handling of PHP 8.1.

Sounds like why CWP continues to use 5.1.1

CWP seems to focus more on older compatibility than newer compatibility.

Starburst

Quote from: its_me_rbk on August 16, 2025, 04:37:15 PM
@Starburst

Did you face any issues after updating phpMyAdmin? I've planned to update it on my production server, that's why I asked about it.

@its_me_rbk

No issues updating, it's on my list of things to do.

BUT...
ALL of our servers are AL9, not sure if/how this would work on AL8.

its_me_rbk

My production server is based on AL9. That's why I asked.

Starburst

Quote from: its_me_rbk on August 18, 2025, 03:58:05 AM
My production server is based on AL9. That's why I asked.

So are ours. In facts all productions servers we have are AL9 now.
Completed the phpMyAdmin updated to 5.2.2 yesterday along with some other updates.