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

 

posted @ 2017-10-25 18:19  geek_ace  阅读(877)  评论(0编辑  收藏  举报