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

postcd

• March 24, 2019 08:26

This forum closed ? 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

• 

  GOT

  • March 24, 2019 13:40

  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)

  0
• 

  cPanelLauren

  • March 27, 2019 16:47

  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!

  0
• 

  postcd

  • June 07, 2019 08:33

  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 (

  0
• 

  GOT

  • June 07, 2019 11:38

  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.

  0
• 

  postcd

  • June 09, 2019 08:20

  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.

  
  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.

  0
• 

  GOT

  • June 09, 2019 13:21

  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.

  0

Please sign in to leave a comment.