You must reset your password using ALTER USER statement before executing this statement. 按照字面意思修改密码:
alter user user() identified by 'aaaaaa';
注意这里不能使用root要用user()