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: This is because MySQL expects you to enter password in an encrypted format. You can resolve this error by following the steps given below. mysql> select password(‘test345’); +———————+ | password(‘test345’) | +———————+ | 2ff898e158cd0311 | +———————+ +————————-+ 1 row in set […]

Continue Reading…