MariaDB Change User Root Pass

更改普通用户密码：

```sh $ mysql -u root -p MariaDB [(none)]> ALTER USER 'user'@'localhost' IDENTIFIED BY 'new<sub>password</sub>'; MariaDB [(none)]> FLUSH PRIVILEGES; ```

更改 root 密码：

```sh $ sudo systemctl stop mariadb $ sudo mysqld<sub>safe</sub> –skip-grant-tables –skip-networking & $ mariadb -u root MariaDB [(none)]> FLUSH PRIVILEGES; MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new<sub>passwordhere</sub>'; MariaDB [(none)]> exit $ sudo pkill mysqld $ sudo systemctl start mariadb $ mariadb -u root -p ```