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

MySQL is an open source relational database management system. MariaDB is a fork of MySQL.

In MySQL / MariaDB you can create a user and he will be authenticated by password. But sometimes we all make mistakes…

Error:

mysql> GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD 's3cr3t';
ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number 

Solution:

mysql> GRANT USAGE ON *.* TO 'moon'@'localhost' IDENTIFIED BY 's3cr3t';
Query OK, 0 rows affected (0.00 sec) 

– just remove “PASSWORD” keyword. Yes, that’s easy.