MySQL修改密码

mysql> 状态下输入 update user set password=password('新密码') where user='root';

回显
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0

 

mysql> 状态下输入 FLUSH PRIVILEGES;
回显
Query OK, 0 rows affected (0.00 sec)
mysql> 状态下输入 quit ;
退出 sql

F41F8E254D92D4B1FC332C03FBB02299

评论

2 楼 cs_man 2009-12-10  

DDCCFC90D6C8AB3EDE8EF4C6D4183C5E

1 楼 cs_man 2009-12-10  

B485C64CB86CF9066CAA844E7DFF19E0