# mariadb修改密码

> 方法一：（有时失败） MariaDB [(none)]> USE mysql; MariaDB [(mysql)]> UPDATE user SET password=PASSWORD('YourPasswordHere') WHERE U…

- 原文：https://www.l2qq.com/article/123
- 发布：2020-08-11T13:44:36Z
- 更新：2020-08-11T13:45:22Z
- 作者：l2qq

---

方法一：（有时失败）
```
MariaDB [(none)]> USE mysql;
MariaDB [(mysql)]> UPDATE user SET password=PASSWORD('YourPasswordHere') WHERE User='root' AND Host = 'localhost';
MariaDB [(mysql)]> FLUSH PRIVILEGES;
```

解决mariadb 修改密码失败：ERROR 1348 (HY000): Column 'Password' is not updatable
方法二（推荐）：
```
MariaDB [(none)]> USE mysql;
MariaDB [(mysql)]> set password for 'root'@'localhost'=password('123456');
MariaDB [(mysql)]>flush privileges;
```
