¿Cómo actualizar hash/contraseña de MySQL a la versión segura 4.1?

How to update MySQL hash/password to secure version 4.1?

For MySQL users

(with cPanel prefix cpanel_user format)

  1. Enter cPanel and look for the section Database / Databases
  2. Use the option MySQL Database / MySQL Databases
  3. Within this option in the final section you will find Current Users and two columns one call Actions Below this find the option Change password / Change password
  4. By clicking on Change password / Change password The new password or current password must be entered so that it can be updated with the new one. hash from MySQL


For cPanel user

(without prefix or _ character)

  1. Enter cPanel and look for the section Preferences / Preferences
  2. Use the option Password & security
  3. Within this option the section of Password to change the password with a new data which will be the new login password to cPanel, FTP and main MySQL

Errors that can be generated with an outdated hash

  • Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)

Leave a Reply