# MySQL5.7中如何修改密码

- Link: https://www.xuepaijie.com/html/skill/devops/1020.html
- Published: 2017-10-20T13:15:31+08:00
- Author: Admin

**1.使用特定的命令**

    ```html;
    命令：SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');

    例子：SET PASSWORD FOR 'test'@'localhost' = PASSWORD("test");
    ```

**2.使用常规的更新SQL语句**

    ```html;
    update mysql.user set authentication_string=password("newpassword") where User="test" and Host="localhost"; 

    flush privileges;
    ```