step1. kill mysql server processID
可以在${datadir}/hostname.pid 取出pid;
step2. restart mysql server:
use opt `--skip-grant-tables'
mysqld_safe --skip-grant-tables --user=mysql&
step3. 使用`mysql -h hostname mysql'命令登录到mysqld server ,修改口令。
(即连接到mysql db)
update user set password =password('passwd') where user='root'; 或grant;
step4. flush privileges;
step5. relogin using root with new password;
阅读(1139) | 评论(0) | 转发(0) |