title: Mysql (MariaDB 10.0.29): Set root password, but still can login without asking password?
body: <p>I want to secure mysql by setting root password.
  I reset root password successfully:</p>
  
  <pre><code>MariaDB [(none)]&gt; select Host, User, Password from mysql.user;
  +-----------+------+-------------------------------------------+
  | Host      | User | Password                                  |
  +-----------+------+-------------------------------------------+
  | localhost | root | *58319282EAB9E38D49CA25844B73DA62C80C2ABC |
  +-----------+------+-------------------------------------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>But, after flush privileges, restart Mysql, I can still login mysql (on local host) without typing password. </p>
  
  <pre><code>root@myhost:/# mysql
  Welcome to the MariaDB monitor.  Commands end with ; or \g.
  Your MariaDB connection id is 10
  Server version: 10.0.29-MariaDB SLE 12 SP1 package
  
  Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
  
  Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  
  MariaDB [(none)]&gt; 
  </code></pre>
  
  <p>How can I force mysql asking password when connect ? Thanks !</p>