mysql> set password for 'root'@'localhost' =PASSWORD('');
Query OK, 0 rows affected (0.17 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)
shell>mysqladmin -u用户名 -h主机名 passworld "newpwd"
mysql>set password for '用户名'@'主机地址'=PASSWORD('新密码')
如果是更改自己的密码,可以省略for语句;
set password=PASSWORD('密码');
grant uasge on *.* to '用户名'@'主机' identified by '密码';
update user set password=PASSWORD('密码') where host=''and user='';
drop user '用户名'@'主机名';