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.

I upgraded to MYSQL 5.6 and now passwords are broke

Discussion in 'Database Discussions' started by DWHS.net, Jan 18, 2016.

  1. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    DBD::mysql::db do failed: Password hash should be a 16-digit hexadecimal number

    I upgrade to MySQL 5.6 since 5.5 stopped being supported last month. I noticed the password error message during the upgrade but I can't even change the mysql password.

    Every time I tried to change the password I get this error:

    DBD::mysql::db do failed: Password hash should be a 16-digit hexadecimal number

    I even tried to add a 16-digit hexadecimal number and it still gave the same error.
     
  2. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    I see all you have to do is add a new MySQL user and connect it to the script.

    There is a way to upgrade the current password but it is a not needed if you just add a new user.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page