Mysql改密码

Posted on

进入Mysql后Set修改

1
set password for root@localhost = password('abc');

用mysqladmin指令

1
mysqladmin -uroot -p123 password abc

把root的密码从123 改为 abc

用update直接更新

1
2
3
use mysql;
update user set password=password('abc') where user='root' and host='localhost';
flush privileges;

Reference

https://www.w3cschool.cn/mysql/mysql-wauz2owl.html