Mysql (MariaDB 10.0.29): Set root password, but still can login without asking password? : <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>
