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

[postcd]

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]

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)

 

[cPanelLauren]

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!

 

[postcd]

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.
?

 

[GOT]

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.

 

[postcd]

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]

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.