title: MariaDB password reset not working
body: <p>I am running <code>MariaDB</code> and i am trying to reset password but its not working.</p>
  
  <pre><code>[root@osdial-99a8c941 ~]# mysqld_safe --skip-grant-tables --skip-networking &amp;
  [1] 11125
  </code></pre>
  
  <p>Next set password:</p>
  
  <pre><code>[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)]&gt; use mysql;
  MariaDB [mysql]&gt; 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]&gt; select * from user;
  Empty set (0.00 sec)
  </code></pre>
  
  <p>If you look <code>user</code> table is still empty :( </p>
  
  <p>Even i tried to create account but got following error:</p>
  
  <pre><code>MariaDB [mysql]&gt; 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
  </code></pre>
  
  <p>What i am doing wrong?? </p>