Improved root password setting

Set a password for root@127.0.0.1 and root@::1 accounts as well, as
explained at
http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html