I was looking at the users in my mysql.user table and noticed that there are 3 roots.
root@localhost
root@127.0.0.1
root@example.com
When I first discovered this none of the roots were password protected. I managed to password protect root@localhost but I can't figure out how to password protect the other two. How would I do this via the command line?
Thanks for any help.