MySQL root @localhost, root@127.0.0.1 and root @ :: 1 have different passwords - is this normal?

After setting the password with this command:

mysqladmin.exe --user=root password <my_password>

I see 3 rows in the user table for the root user: http://i.stack.imgur.com/Y4Rkd.jpg and root @localhost has a password, and root @ 12.0.0.1 and root @ :: 1 do not have a password.enter image description here

Does this mean that I need to set a password 3 times for each of these lines? i.e:.

mysqladmin.exe --user=root host=localhost password <my_password>
mysqladmin.exe --user=root host=127.0.0.1 password <my_password>
mysqladmin.exe --user=root host=::1 password <my_password>

This is normal?

+4
source share
2 answers

, . , . .
mysql (, mysqladmin), localhost. , root@localhost . root .

+3

:: 1 - IP- IPV6 127.0.0.1 ( IPV4), .

+2

All Articles