The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpMyAdmin wrong MySQL version

Discussion in 'Database Discussions' started by Mysteerie, Aug 22, 2013.

  1. Mysteerie

    Mysteerie Well-Known Member

    Joined:
    Dec 29, 2003
    Messages:
    129
    Likes Received:
    0
    Trophy Points:
    16
    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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. Mysteerie

    Mysteerie Well-Known Member

    Joined:
    Dec 29, 2003
    Messages:
    129
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  4. rogerw

    rogerw Member

    Joined:
    Feb 21, 2012
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    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!
     
  5. rogerw

    rogerw Member

    Joined:
    Feb 21, 2012
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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!
     
  6. MikeDVB

    MikeDVB Well-Known Member
    PartnerNOC

    Joined:
    Jun 4, 2008
    Messages:
    212
    Likes Received:
    3
    Trophy Points:
    18
    Location:
    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.
     
Loading...

Share This Page