title: Enable password and unix_socket authentication for MariaDB root user?
body: <p>I've a root User on the MariaDB on Ubuntu 16.04.</p>
  
  <p>As default the root user is authenticated by the <code>unix_socket</code> authentication plugin. </p>
  
  <p>I can switch the authentication method to password method by setting</p>
  
  <pre><code>update mysql.user set plugin='' where user='root';
  </code></pre>
  
  <p>This works fine. But  ...</p>
  
  <p>Is there a possibility to authenticate the root user by unix_socket (by root shell) or by password (when it is connected by localhost:3306)?</p>