参照网上资料给mysql用户赋权发生如下错误mysql>gra艘绒庳焰ntallprivilegeson*.*to鸡堕樱陨root@'%'identifiedby'123456';ERROR1827(HY000):Thepasswordhashdoesn'thavetheexpectedformat.CheckifthecorrectpasswordalgorithmisbeingusedwiththePASSWORD()function.
工具/原料
Linux/Mysql5.6
方法/步骤
1、设置参数old_passwords的值mysql>setold_passwords=0;QueryOK,0rowsaffected(0.26sec)
2、再次运行OKmysql>grantallprivilegeson*.*toroot@'%'identifiedby'123456';QueryOK,0rowsaffected(0.30sec)