mysql> GRANT RELOAD, SUPER, REPLICATION SLAVE ON *.* TO 'repl'@'192.168.3.%' IDENTIFIED BY PASSWORD 'mysql'; ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number

 

解决方法：

mysql> select password('mysql'); +-------------------------------------------+ | password('mysql')             | +-------------------------------------------+ | *D417C6FC148AA260A4AA78333E74C35846EFA006 | +-------------------------------------------+

mysql> GRANT RELOAD, SUPER, REPLICATION SLAVE ON *.* TO 'repl'@'192.168.3.%' IDENTIFIED BY PASSWORD '*D417C6FC148AA260A4AA78333E74C35846EFA006'; Query OK, 0 rows affected (0.00 sec)