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

postcd

Well-Known Member
Oct 22, 2010
717
19
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?
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,739
301
363
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)
 
  • Like
Reactions: cPanelLauren

postcd

Well-Known Member
Oct 22, 2010
717
19
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.
?
 
Last edited:

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,739
301
363
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.
 
  • Like
Reactions: cPanelLauren

postcd

Well-Known Member
Oct 22, 2010
717
19
68
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.
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,739
301
363
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.