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.