mysql改密码

update user set authentication_string = password('new password'),password_expired = 'N', password_last_changed = now() where user = 'root';