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.
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?
source
share