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 shows wrong mysql version

Discussion in 'Database Discussions' started by vashrf, Aug 27, 2010.

  1. vashrf

    vashrf Member

    Joined:
    Jan 20, 2010
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    hi,

    I just upgraded to mysql 5.1, but phpmyadmin still shows 5.0. Cpanel shows 5.1 though. So, what is wrong with phpmyadmin?

    Thanks
     
  2. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    What you are seeing is normal; this is not caused by any problem. The MySQL client support compiled into the internal cPanel PHP installation is compatible with MySQL 5.1 despite phpMyAdmin reporting MySQL 5.0.

    If you would like to have the numbers match I would run the following script via root SSH access:
    Code:
    /scripts/makecpphp
     
  3. vashrf

    vashrf Member

    Joined:
    Jan 20, 2010
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Server version: 5.0.91-community-log
    MySQL client version: 5.1.48

    is that correct?

    thanks for the help though.
     
  4. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    The reported MySQL client version (5.1.x) should be compatible with the MySQL server version (5.0.x); however, I see there may be a discrepancy as described.

    Please provide the following details:
    1. Are you using a remote MySQL server?
    2. Is there a specific issue or problem that you are experiencing (perhaps with specific errors being logged)?
     
  5. chr1831

    chr1831 Registered

    Joined:
    Sep 27, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Sorry to bring up an older topic but I am also having this issue. I have recompiled php/apache already, and you can check the build report id 4263613. I installed mysql 5.1.48 but phpmyadmin still reports 5.0.91-community. I am not using a remote mysql server so that should help narrow it down.

    mysqld --version
    mysqld Ver 5.1.48 for pc-linux-gnu on i686 (MySQL Community Server (GPL))

    Server: VPS (openvz)
    Ram: 512mb
    WHM version: 11.26.14

    Thanks in advance for your help.

    Edit: I am not experiencing any other issues.
     
  6. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    To clarify and ensure I'm checking the correct detail, which version information are you referring to in phpMyAdmin? For example, are you referring to what phpMyAdmin displays as the MySQL "Server version" or the "MySQL client version"?

    Please provide the output from the following command, entered via root SSH access:
    Code:
    # rpm -qa --qf "%{name}-%{version}-%{release}.%{arch}\n" | grep -i mysql | sort
     
Loading...

Share This Page