Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL upgrade to v.5.6+ old style passwords cPanel - explanation

Discussion in 'Database Discussion' started by postcd, Mar 24, 2019.

  1. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    704
    Likes Received:
    16
    Trophy Points:
    68
    This forum closed my topic for replies so i am starting this new one where i would like to ask users for help.

    Is there any user who can comment on Michael's linked migration document MySQL :: MySQL 5.6 Reference Manual :: 6.5.1.3 Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin ? Regarding it, am wondering if any part of that guide can be used to remove or partialy fix the issue of different password requirements among MySQL <5.5 and 5.6+ (as described in my topic)

    Which parts of the document are important in context of the cPanel server and what it can actually do with the server?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,486
    Likes Received:
    188
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Do you have an excessive number of users with old passwords? Normally we just advise people to reset the passwords cia cPanel (can even use the same passwords)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    cPanelLauren likes this.
  3. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,502
    Likes Received:
    509
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    The user will need to know their password in order to utilize MySQL databases so the suggestion by @GOT is actually the most common method of changing these.

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    704
    Likes Received:
    16
    Trophy Points:
    68
    Being on old MySQL 5.5 server, how can i:
    1) list mysql users with legacy old style passwords
    2) how to change the mysql user password (Change MySQL User Password - Version 80 Documentation - cPanel Documentation) so it is strong enough to meets the MySQL 5.6 password requirement (can the password Strength indicator say it to me or which kind of characters to enter in the password generator). My aim is to prevent site problems caused by resetted mysql user passwords after migration from mysql v5.5 to v5.6 server.
    ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 postcd, Jun 7, 2019
    Last edited: Jun 7, 2019
  5. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,486
    Likes Received:
    188
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    If you go into whm and start the upgrade process, in the second step after you pick a version it will list all the users that have old style passwords. This is safe the upgrade doesn't start for two more steps.

    The storage format doesn't have anything to do with password complexity. Mysql does not care about that what this is referencing is how mysql encrypts the database when it stores it. All you need to do is set the password again for the user. It doesn't have to change and it doesn't have to be complex. Just re saved to the mysql user table.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    cPanelLauren likes this.
  6. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    704
    Likes Received:
    16
    Trophy Points:
    68
    Thanks alot for the comment. You mean to change (reset) it (Change MySQL User Password - Version 80 Documentation - cPanel Documentation) on the OLD server MySQL 5.5.60 or on the NEW server? I hope it can be on the old server because i think new server automatically resets the passwords causing broken connection to mysql from files.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,486
    Likes Received:
    188
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    You would need to do this on the source server, BEFORE the transfer. If you have already transferred you either need to reset the password on the new server and update the config files, or, ideally, update the password on the source server and transfer the domain again.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice