MySQL ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal

If you are getting the following error while creating a user through MySQL Prompt:

[wpfmb type=’error’ theme=2]mysql> create user test identified by password ‘test345’;
ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number[/wpfmb]

This is because MySQL expects you to enter password in an encrypted format.

You can resolve this error by following the steps given below.

That’s it.

Leave a Reply

Your email address will not be published. Required fields are marked *