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.

Why cant we do the upgrades

Discussion in 'Database Discussions' started by k8jsl, Jul 23, 2012.

  1. k8jsl

    k8jsl Member

    Joined:
    Sep 25, 2005
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Why is it cPanel forces us to use the libmysqlclient, phpmyAdmin, and the actual MySql version that they see fit,
    even if it is buggy !!??

    I have identical SQL database's on 2 separate servers, one cPanel/WHM based, the other I install what I see fit
    cPanel/WHM
    MYSQL: 5.5.24-cll
    MYSQL Library: 4.1.22
    php extension: mysql
    phpmyadmin: 3.4.10.1

    Dedicated:
    5.5.25 Community Server
    Database client version: libmysql - 5.0.77
    PHP extension: mysqli
    phpmyadmin: 3.5.2

    I round robin the mysql databases for my websites, and I can certainly tell when the cPanel/WHM server is being used..

    this little code snippet
    PHP:
    $now time();
    $now -= 3660
    $sql "SELECT a.ICAO,a.tempF,a.epoch,b.name,b.state FROM mimetar a INNER JOIN icaos2 b ON a.ICAO=b.icao WHERE b.country ='us' AND a.ICAO LIKE 'K%'  AND a.epoch >= '$now' AND a.tempF < '9999' ORDER BY a.tempF ASC LIMIT 0,10";

    Does exactly as intended on the 5.5.25 server, returns the lowest 10 temperatures in the US,
    but on the cPanel/WHM, returns the lowest temps starting AT 100º !!

    so how about it guy's 5.5.25 has been stable for a while now
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    If you'd like to make a request to update the MySQL version, please post this in the feature request forum at Feature Requests for cPanel & WHM

    Otherwise, please note you can use any server for MySQL that you would prefer with cPanel. We have an option in WHM > SQL Services > Setup Remote MySQL server area where you can setup connecting to a remote MySQL machine.

    Thanks!
     
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
Loading...

Share This Page