old password

GRANT SELECT, INSERT, UPDATE, DELETE, DROP ON `test`.`test` TO 'writeuser'@'%' identified by '111111'
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.

SET old_passwords = 0;

重新执行一遍grant

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/geek-ace/p/7730944.html