title: ALTER USER root@localhost IDENTIFIED VIA mysql_native_password; -- fails with syntax error
body: <p>Trying to enable regular password-based auth according to the below page:
  <a href="https://mariadb.com/kb/en/library/authentication-plugin-unix-socket/" rel="noreferrer">https://mariadb.com/kb/en/library/authentication-plugin-unix-socket/</a></p>
  
  <p>The page suggests the following code:</p>
  
  <pre><code>ALTER USER root@localhost IDENTIFIED VIA mysql_native_password;
  SET PASSWORD = PASSWORD('foo');
  </code></pre>
  
  <p>but on my machine it fails with a syntax error:</p>
  
  <pre><code>MariaDB [(none)]&gt; ALTER USER root@localhost IDENTIFIED VIA mysql_native_password;
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER root@localhost IDENTIFIED VIA mysql_native_password' at line 1
  MariaDB [(none)]&gt; SET PASSWORD = PASSWORD('foo');
  Query OK, 0 rows affected, 1 warning (0.00 sec)
  </code></pre>