phpMyAdmin wrong MySQL version

Mysteerie

Well-Known Member
Dec 29, 2003
129
0
166
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

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
Hello :)

Try forcing an update of phpMyAdmin via:

Code:
/usr/local/cpanel/bin/updatephpmyadmin --force
Thank you.
 

Mysteerie

Well-Known Member
Dec 29, 2003
129
0
166
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

Member
Feb 21, 2012
23
4
53
cPanel Access Level
Website Owner
Hello :)

Try forcing an update of phpMyAdmin via:

Code:
/usr/local/cpanel/bin/updatephpmyadmin --force
Thank you.
I have the same issue:

Code:
/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:

Code:
/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

Member
Feb 21, 2012
23
4
53
cPanel Access Level
Website Owner
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!! :)

o_O

Thanks all!
 

MikeDVB

Well-Known Member
PartnerNOC
Jun 4, 2008
218
3
68
Indiana, USA
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.