Problem:
<html />
mysql> GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '1234';
<html />
ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
Solution:
Option:1
<html />
mysql> GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY '1234';
Query OK, 0 rows affected (0.00 sec)
Option:2
<html />
mysql> SELECT PASSWORD('1234');
<go />
+-------------------------------------------+
| PASSWORD('1234') |
+-------------------------------------------+
| *CDE65254CC57BC0C3D0A85509B5CEA654126BF56 |
+-------------------------------------------+
1 row in set (0.00 sec)
<go />
mysql> GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*CDE65254CC57BC0C3D0A85509B5CEA654126BF56 ';
Query OK, 0 rows affected (0.00 sec)