Mysql错误1827(HY000)

Mysql错误1827(HY000)

参照网上资料给mysql用户赋权发生如下错误

mysql> grant all privileges on *.* to root@'%' identified by '123456';

ERROR 1827 (HY000): The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.

设置参数old_passwords的值

mysql> set old_passwords=0;

Query OK, 0 rows affected (0.26 sec)

再次运行OK

mysql> grant all privileges on *.* to root@'%' identified by '123456';

Query OK, 0 rows affected (0.30 sec)