Mysql错误1827(HY000)

1、设置参数old_passwords的值

mysql> set old_passwords=0;

Query OK, 0 rows affected (0.26 sec)

2、再次运行OK

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

Query OK, 0 rows affected (0.30 sec)