修改root用户密码
mysql> set password for root@localhost = password('新密码');
修改普通用户密码
mysql> set password for 用户名@localhost = password('新密码');