Transfer from cPanel MySQL 5.0 to cPanel with MariaDB 10 - old passwords

hicom

• January 03, 2016 22:39

We want to transfer hosting accounts from cPanel server running MySQL 5.1.72 with Old-Password-MySQL4.1 option turned on to a new server running MariaDB10. We noticed if we do a transfer of a site, the passwords no longer work and need to be manually reset which will cause huge delays and alot of support requests. What is the best way to upgrade the passwords? Should we upgrade to MySQL 5.5 or 5.6 on the old server and deactivate 4.1-passwords ? Then transfer to MariaDB 10 ? or are there other options? Thanks

• 

  cPanelMichael

  • January 04, 2016 18:39

  Hello :) Yes, I suggest upgrading MySQL 5.0 on the source machine first (version 5.5 is suitable), and ensuring passwords work as expected. Then, transfer the accounts to the destination server after that's completed. Thank you.

  0
• 

  hicom

  • January 04, 2016 19:55

  So if we keep the option Pre-Password 4.1, and upgrade to MySQL 5.5, this will automatically convert it to the new password hash? Afterwards, we can do transfer from MySQL 5.5 pre-4.1 Passwords to MariaDB server and the passwords will convert? Thanks

  0
• 

  cPanelMichael

  • January 04, 2016 20:50

  You will need to follow the following guide if you plan to update the passwords: 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
• 

  hicom

  • March 07, 2016 15:31

  Hi, thanks for the info. I've examined the documentation but unsure if the process is applying properly. Here is the environment we have: cPanel 11.52.4 MySQL 5.1.73-cll In my.cnf we have: old-passwords = 1 In the mysql DB, we have many passwords using 16-characters, and some using 41-characters with * at both ends. ((We prefer to update all these passwords to the new format, without having to upgrade MySQL itself, or ask the user to give us the passwords.)) In the mysql DB, the table "Plugin" is empty, but there are no columns called "Plugin" under the users table. This is where I'm primarily lost because there is no Plugin column under mysql.user . Any opinion on this is appreciated

  0
• 

  hicom

  • March 07, 2016 16:08

  Just an after thought. Regardless of the above, there seems to be no way to re-hash the passwords or upgrade the hash without knowing the password.

  0
• 

  hicom

  • March 07, 2016 23:15

  We have tested changing the password through cPanel, but it is always the same password type 16-characters. Do we need to remove old-password from my.cnf so cPanel hash the password using 41-characters?

  0
• 

  cPanelMichael

  • March 08, 2016 17:01

  Just an after thought. Regardless of the above, there seems to be no way to re-hash the passwords or upgrade the hash without knowing the password.

  
  Yes, this is correct. There's an older thread that you may find helpful: MySQL 5.0 / 5.1 and doing away with "old style passwords" Thank you.

  0

Please sign in to leave a comment.