How to update phpMyAdmin to latest version without breaking CWP?

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

Code: [Select]

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.

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

According to:

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

Code: [Select]

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:

Code: [Select]

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


Thanks for the help buddies.

@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:

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

@starburst

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

Never noticed it there before.

But you are correct, it is there with 5.1.1

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

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.

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

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.

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

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.

Just updated my AL9 went smooth.