Update pre-4.1 passwords in bulk

Varial

• February 19, 2015 15:19

We have a few old servers running MySQL 5.5 with old-passwords set that we'd like to update to 5.6 but need to convert each user's password away from pre-4.1 hashes. Is there any way (ie. a script) to do this in bulk or do we need to manually retrieve and update each database password one by one?

• 

  cPanelMichael

  • February 20, 2015 16:56

  Hello :) The following MySQL document explains how you can update these passwords: [url=http://dev.mysql.com/doc/refman/5.6/en/account-upgrades.html]MySQL :: MySQL 5.6 Reference Manual :: 6.3.8.3 Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin Thank you.

  0

Please sign in to leave a comment.