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.

Problem reporting mySQL version in Cpanel 11

Discussion in 'General Discussion' started by netmation, Aug 24, 2007.

  1. netmation

    netmation Member

    Joined:
    Sep 23, 2004
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    My hosted VPS has mySQL 4.1.22 installed on it which I can see at the root, but Cpanel 11 is showing 5.0.27 installed? My hosting company stated that Cpanel has had issues like this before, is this true. Is this a bug, is it fixable.

    Thanks.
     
  2. ToddShipway

    ToddShipway Well-Known Member

    Joined:
    Nov 13, 2006
    Messages:
    300
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Houston, TX
    Run the command below to reset the version shown by the cPanel interface.

    Code:
    find /home/*/.cpanel-datastore/ | grep _usr_sbin_mysqld_--version | awk '{system ("rm " $1)}'
    
     
  3. trevHCS

    trevHCS Well-Known Member

    Joined:
    Nov 1, 2003
    Messages:
    69
    Likes Received:
    1
    Trophy Points:
    8
    Should this still work in the latest Cpanel as I just did the same upgrade and found Cpanel was still showing "4.0.27-standard", so ran the above code from root SSH and still showing as that.


    Edit - found the answer in this thread posted around the same time.

    Seems that running this from root, then relogging into to Cpanel works:
    rm -f /home/*/.cpanel/datastore/_usr_sbin_mysqld_--version

    Slightly different directories, although I do also have a /.cpanel-datastore as well which confused things a bit.

    Trev
     
    #3 trevHCS, Sep 7, 2007
    Last edited: Sep 7, 2007
Loading...

Share This Page