MySQL如何修改密码

如
mysql> set password for root@localhost = password('123');  

把密码修改成123