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 - MySQL client version: 4.1.22

Discussion in 'Database Discussions' started by 4u123, May 25, 2009.

  1. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    765
    Likes Received:
    1
    Trophy Points:
    18
    Hi, I just recently rebuilt apache and PHP with MySQL 5 and PHP 5 but in phpmyadmin it says "MySQL client version: 4.1.22."

    Why didnt easyapache compile wth the latest php mysql libraries and how can I fix this?
     
  2. JawadArshad

    JawadArshad Well-Known Member
    PartnerNOC

    Joined:
    Apr 8, 2008
    Messages:
    447
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    PK
    cPanel Access Level:
    DataCenter Provider
    cat this file and see what version it shows.

    cat /home/username/.cpanel/datastoer/_usr_sbin_mysqld_--version
     
  3. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    765
    Likes Received:
    1
    Trophy Points:
    18
    That file contains..

    /usr/sbin/mysqld Ver 5.0.67-community-log for redhat-linux-gnu on i686 (MySQL Community Edition (GPL))

    mysql from command line returns...

    Server version: 5.0.77-community-log MySQL Community Edition (GPL)
     
  4. JawadArshad

    JawadArshad Well-Known Member
    PartnerNOC

    Joined:
    Apr 8, 2008
    Messages:
    447
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    PK
    cPanel Access Level:
    DataCenter Provider
    Did you run easyapache after MySQL upgrade or before. Easyapache should be run after, and also correct the MySQL version in the MySQL version file for your account. If this does not work, contact cPanel support.
     
  5. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    765
    Likes Received:
    1
    Trophy Points:
    18
    Server has been on mysql 5 and php5 for over 6 months. Easyapache should know to install the correct libraries.
     
  6. 4u123

    4u123 Well-Known Member
    PartnerNOC

    Joined:
    Jan 2, 2006
    Messages:
    765
    Likes Received:
    1
    Trophy Points:
    18
    Now I'm more confused.

    I ran /scripts/mysqlup --force. I've recompiled apache/php just now and phpmyadmin is still showing MySQL client version: 4.1.22

    What do I need to do to ensure that PHP is using the correct libraries? I've searched the forums but found nothing. I'm sure I'm just missing something simple here.

    I ticked both these options...

    Mysql [More Info ↑]
    compile MySQL support using the PHP bundled libraries (if the System MySQL option is checked it takes precedence over this option)

    Mysql of the system [More Info ↑]
    compile mysql (and mysqli if its checked) support against the system libraries

    I presume /scripts/mysqlup --force will install the latest system libraries, so why isnt this working?

    Any advice appreciated!
     
    #6 4u123, May 26, 2009
    Last edited: May 26, 2009
  7. nahubbard

    nahubbard Registered

    Joined:
    May 2, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Michigan
    update cpanel php

    Have you tried running /scripts/makecpphp to resolve this?
     
  8. LampedWeb

    LampedWeb Member

    Joined:
    May 28, 2009
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    England
    cPanel Access Level:
    Root Administrator
    I'm having the same issue, and ran makecpphp. It's just stopped at:

    No package xorg-x11-dev available.

    No following text, no prompt. Nothing.

    Edit:
    It now says:
    Done rebuilding cPanel's internal PHP.
    Failed to build working PHP
     
    #8 LampedWeb, Jun 1, 2009
    Last edited: Jun 1, 2009
  9. NanoAdmin

    NanoAdmin Registered

    Joined:
    Jun 1, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Please try , yum -y install xorg-x11-dev*

    And now run /scripts/makecpph
     
  10. LampedWeb

    LampedWeb Member

    Joined:
    May 28, 2009
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    England
    cPanel Access Level:
    Root Administrator
    So, yum has been frozen after 'Loading "fastestmirror" plugin' for a good hour...
     
  11. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    PHPMyAdmin uses the PHP version in /usr/local/cpanel, which is not built by normal use of EasyApache. /scripts/makecpphp normally resolves this issue. If it does not, please open a support ticket so we can resolve it for you.
     
Loading...

Share This Page