mysql p密码不起作用_mysql – MariaDB密码重置不起作用

我正在运行MariaDB,我正在尝试重置密码,但它无法正常工作.

[root@osdial-99a8c941 ~]# mysqld_safe --skip-grant-tables --skip-networking &

[1] 11125

下一步设置密码：

[root@osdial-99a8c941 ~]# mysql -u root

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 1

Server version: 5.5.37-MariaDB-wsrep-log MariaDB Stylite Build (GPL), wsrep_25.10.r3980

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use mysql;

MariaDB [mysql]> update user set password=PASSWORD("new-password") where User='root';

Query OK, 0 rows affected (0.00 sec)

Rows matched: 0 Changed: 0 Warnings: 0

MariaDB [mysql]> select * from user;

Empty set (0.00 sec)

如果你看起来用户表仍然是空的:(

即使我试图创建帐户,但有以下错误：

MariaDB [mysql]> CREATE USER 'root'@'localhost' IDENTIFIED BY 'new-password';

ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

我做错了什么？