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.

Question About MySQL Version Installed

Discussion in 'Database Discussions' started by miramarfun, Aug 17, 2015.

  1. miramarfun

    miramarfun Member

    Joined:
    Aug 17, 2015
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    france
    cPanel Access Level:
    Website Owner
    Hello everyone on the Forum,

    Here is my problem. Having installed and whm cpanel which originally had Mysql 5.0.10.
    I wanted to change for version 5.6.
    Everything is good but there lies a mistake I do not understand and I would like to rectify.

    My WHM shows: MySQL 5.6
    papMyAdmin displayed: MySQL 5.6

    Out on the page of my Web site root (public_html / www) with a php info.
    This brings me Mysql 5.0.10

    How to fix this problem so that at www, Mysql is the same (5.6)

    Pending answers

    Best regards
    Patrick

    ps: sorry for my bad English because I am not master French and English
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. miramarfun

    miramarfun Member

    Joined:
    Aug 17, 2015
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    france
    cPanel Access Level:
    Website Owner
    Good evening,

    Here is the answer:


    MySQL56-client-5.6.23-3.cp1148.x86_64
    cpanel-perl-514-MySQL-Diff-0.43-4.cp1146.x86_64
    MySQL56-server-5.6.23-3.cp1148.x86_64
    compat-MySQL50-shared-5.0.96-4.cp1136.x86_64
    MySQL56-shared-5.6.23-3.cp1148.x86_64
    MySQL56-test-5.6.23-3.cp1148.x86_64
    compat-MySQL51-shared-5.1.73-1.cp1150.x86_64
    MySQL56-devel-5.6.23-3.cp1148.x86_64

    [Removed URL]

    Mysql 5.0.10
     
    #3 miramarfun, Aug 17, 2015
    Last edited by a moderator: Aug 17, 2015
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  5. miramarfun

    miramarfun Member

    Joined:
    Aug 17, 2015
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    france
    cPanel Access Level:
    Website Owner
    This is what I have done already!

    Thank you.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Try moving the custom php.ini file from the account's public_html out of the way to see if the issue persists when using /usr/local/lib/php.ini. It's possible the local php.ini file is outdated.

    Thank you.
     
  7. miramarfun

    miramarfun Member

    Joined:
    Aug 17, 2015
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    france
    cPanel Access Level:
    Website Owner
    I went on /usr/local/lib/php.ini

    I have 2 files

    php.ini
    and
    php.ini, v
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I'm not sure I understand your previous response. The initial URL you posted with your PHPINFO page showed the php.ini utilized was stored in the account's public_html directory. I'm suggesting that you move it out of the way so that /usr/local/lib/php.ini is used instead.

    Thank you.
     
  9. miramarfun

    miramarfun Member

    Joined:
    Aug 17, 2015
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    france
    cPanel Access Level:
    Website Owner
    Hello,

    If I understood correctly:

    I just move /usr/local/lib/php.ini (php.ini) and I placed it on my test url http: ftp domain.com/test.php in the public_html folder / www.

    And always the same. Mysql 5.0.10 is not the 5.6

    Best regards

    And I thank you for being there to help me and give advice
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    No, I am stating that you should temporarily move /home/$username/public_html/php.ini out of the way and see if you still receive the same result.

    Thank you.
     
  11. miramarfun

    miramarfun Member

    Joined:
    Aug 17, 2015
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    france
    cPanel Access Level:
    Website Owner
    By cons I also wanted to add, since it can be to the importance to use MySql 5.6.
    I have PHP version Version 5.4.44

    Maybe it is inconsistent to run MySQL 5.6
     
  12. miramarfun

    miramarfun Member

    Joined:
    Aug 17, 2015
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    france
    cPanel Access Level:
    Website Owner
    So I removed the php.ini file (/home/$username/public_html/php.ini) ... I redid the test with phpinfo ... And always the same MySQL 5.0.10
     
  13. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
  14. miramarfun

    miramarfun Member

    Joined:
    Aug 17, 2015
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    france
    cPanel Access Level:
    Website Owner
    I just created a support ticket.

    By cons I do not know what I should do on WHM, ras ip ssh key and complex ... It is for me.

    There would not it another way and give you direct access identifier with my MP?

    Also I do not really master English, which makes things even more difficult
     
  15. miramarfun

    miramarfun Member

    Joined:
    Aug 17, 2015
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    france
    cPanel Access Level:
    Website Owner
    SSH test statuses
    This interface displays the following status information:

    Erreur : The SSH test failed with the following error: “NOAUTHDATA” For more information, read our Grant cPanel Support Accessdocumentation.
     
  16. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  17. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    To update, the issue was not reproducible on the user's system (the phpinfo file was not accessible). The user was advised to run EasyApache to see if the issue continued.

    Thank you.
     
  18. feldon27

    feldon27 Well-Known Member

    Joined:
    Mar 12, 2003
    Messages:
    111
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Houston, TX
    I thought phpinfo() always displayed a much older version of MySQL than is actually running.

    Under the MySQL block under phpinfo, mine says:
    Client API version 5.5.42

    However under other sections, it says:
    PDO Driver for MySQL
    Client API version mysqlnd 5.0.10
    mysqlnd
    Version mysqlnd 5.0.10 - 20111026​

    Never had a problem.
     
  19. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    653
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    This is the MySQL native driver:

    http://php.net/manual/en/mysqlnd.overview.php

    Thank you.
     
  20. feldon27

    feldon27 Well-Known Member

    Joined:
    Mar 12, 2003
    Messages:
    111
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Houston, TX
Loading...

Share This Page