title: Resetting root password for mariadb does not work
body: <p>I am trying to reset the root password for a mariadb database, followed every variation of tutorial to do so I've found so far, and every time I try to log in with the new password, it does not accept it.</p>
  
  <p>Mainly, this is what I've been doing:</p>
  
  <pre><code>mysqld_safe --skip-grant-tables --skip-networking &amp;
  mysql -u root -e 'use mysql; update user SET PASSWORD=PASSWORD("jkjkjkjjk"); flush privileges;'
  </code></pre>
  
  <p>I also tried adding an additional <code>flush privileges;</code> before the <code>udpate</code> command, removing it from the end as well, different variations for reset password, such as <code>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');</code></p>
  
  <p>I am using mariadb with galera, running on kubernetes statefulset, if relevant.
  version of mariadb is <code>mysqld 10.3.21-MariaDB-1:10.3.21+maria~bionic</code></p>
  
  <p>I am incredibly frustrated about this.</p>