Improved root password setting

It's necessary to use SET PASSWORD for the root@127.0.0.1 and root@::1
accounts, the command issued via mysqladmin will not work for these
according to
http://dev.mysql.com/doc/mysql-security-excerpt/5.5/en/default-privileges.html