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

Because the password you enter is clear text, it requires you to enter hexadecimal digits.
Solutions:

#Use select password('password'): to find its corresponding hexadecimal code.
# Use hexadecimal codes instead of plaintext passwords

Example: