更改mysql的密码

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 '用户名'@'主机名';

转载于:https://www.cnblogs.com/lehao/p/3924579.html