MySQL root@localhost, root@127.0.0.1 and root@::1 have different passwords - is it normal?
<p>After setting password with this command:</p>

<pre><code>mysqladmin.exe --user=root password &lt;my_password&gt;
</code></pre>

<p>I see 3 rows in user table for "root" user:
<a href="https://i.stack.imgur.com/Y4Rkd.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/Y4Rkd.jpg" alt="enter image description here"></a>
<a href="https://i.stack.imgur.com/Y4Rkd.jpg" rel="noreferrer">http://i.stack.imgur.com/Y4Rkd.jpg</a>
and root@localhost has password, while root@127.0.0.1 and root@::1 do not have password.</p>

<p>Does it mean that I need to set password 3 times for each of these rows? i.e.:</p>

<pre><code>mysqladmin.exe --user=root host=localhost password &lt;my_password&gt;
mysqladmin.exe --user=root host=127.0.0.1 password &lt;my_password&gt;
mysqladmin.exe --user=root host=::1 password &lt;my_password&gt;
</code></pre>

<p>Is this normal?</p>