ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number: 에러 해결

Problem:

mysql> GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '1234';

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

 

Solution:

Option:1

mysql> GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY '1234';

Query OK, 0 rows affected (0.00 sec)

 

Option:2

mysql> SELECT PASSWORD('1234');

+-------------------------------------------+

| PASSWORD('1234')                       |

+-------------------------------------------+

| *CDE65254CC57BC0C3D0A85509B5CEA654126BF56 |

+-------------------------------------------+

1 row in set (0.00 sec)

 

mysql> GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*CDE65254CC57BC0C3D0A85509B5CEA654126BF56 ';

Query OK, 0 rows affected (0.00 sec)