phpMyAdmin wrong MySQL version

[Mysteerie]

I have an older server that I forgot to upgrade to MySQL 5.5 (which I finally did tonight).

MySQL upgraded fine, EasyApache recompiled fine.

mysql -V show 5.5.32

rpm -qa|grep MySQL shows
MySQL55-server-5.5.32-1.cp1136
MySQL55-devel-5.5.32-1.cp1136
MySQL55-client-5.5.32-1.cp1136
MySQL55-shared-5.5.32-1.cp1136
MySQL55-test-5.5.32-1.cp1136
cpanel-perl-514-MySQL-Diff-0.43-1.cp1136


However, the issue is phpMyAdmin. It still says it is running Server version: 5.1.70-cll - MySQL Community Server (GPL).

From my research, this is because the internal php that cPanel uses need to be recompiled. Which you would do by running the script makecpphp.

cPanel, recently changed to an rpm system for its services and no longer has the script makecpphp. So how would I recompile the internal php now for cPanel?

 

[cPanelMichael]

Hello

Try forcing an update of phpMyAdmin via:

/usr/local/cpanel/bin/updatephpmyadmin --force

Thank you.

 

[Mysteerie]

It is showing the correct version now.

I could of sworn that I ran that last night and it didn't work. Or maybe it was just browser cache; either way, thank you.

 

[rogerw]

Hello

Try forcing an update of phpMyAdmin via:

/usr/local/cpanel/bin/updatephpmyadmin --force

Thank you.

I have the same issue:

/root$ rpm -qa --qf "%{name}-%{version}-%{release}.%{arch}\n" | grep -i mysql | sort
cpanel-mysql-5.0.96-1.cp1136.i386
cpanel-mysql-libs-5.0.96-1.cp1136.i386
cpanel-perl-514-DBD-mysql-4.021-1.cp1136.i386
cpanel-perl-514-MySQL-Diff-0.43-1.cp1136.i386
MySQL55-client-5.5.32-1.cp1136.i386
MySQL55-devel-5.5.32-1.cp1136.i386
MySQL55-server-5.5.32-1.cp1136.i386
MySQL55-shared-5.5.32-1.cp1136.i386
MySQL55-test-5.5.32-1.cp1136.i386

And the output for the command you provided is:

/root$ /usr/local/cpanel/bin/updatephpmyadmin --force
Apply patchset to phpMyAdmin
cPanel authentication library installed.
cPanel API interface library installed.
Removed feature for generating custom PMA config files.
phpMyAdmin updated to 4.0.8-all-languages.cp1

When I restart apache and restart MySQL, I then go to phpMyAdmin (via WHM). Upon review phpMyAdmin still displays:

Server version: 5.1.41 - MySQL Community Server (GPL)

Based on the above output notes, why does the server say MySQL is at 5.5.32, cPanel-mysql says 5.0.96, and phpMyAdmin say 5.1.41?

What else can I do to resolve this issue please?

Thanks!

 

[rogerw]

cPanel looked at this and when they logged in, they received the correct MySQL 5.5.32 version reported in phpMyAdmin.

Maybe there was a delay or something (I know for sure I saw version 5.1.41 reported).

Feels like a noob moment!!



Thanks all!

 

[MikeDVB]

If I had to guess - the version check isn't performed every time and is likely cached for a short time. If not - then maybe it's the browser cache.