mysql密码丢失时恢复密码的方法V1.1

六月 25th, 2010 Posted in mysql | 阅读次数: 159 次

制作:高进波
时间:2010-06-25

很多时候忘记了mysql root密码，导致不能管理数据库，非常麻烦，根据下面的方法，可以在任何linux发行版下重置root密码。centos mysql 忘记密码，ubuntu mysql 忘记密码,redhat mysql 忘记密码

 

1.使用下面方法启动mysql
mysqld_safe –skip-grant-tables &

 

2.连接到数据库，不需要输入密码，直接回车 

mysql -uroot –p

 

3.置设root密码

update user set password=PASSWORD("gaojinbo.com") \
where user='root';

 

完成!

相关日志：

Tags:

This entry was posted on 星期五, 六月 25th, 2010 at 09:33 and is filed under mysql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

5 Responses to “mysql密码丢失时恢复密码的方法V1.1”

  1. Yeast Infection Home Remedy Says:

    五月 9th, 2011 at 21:37

    Recommended Sites…

    [...]below you can check out my links page http://www.yeastinfectiontreatmentcure.net/links/ with some fantastic websites that I think you should go visit[...]…


  2. yeast infection treatment Says:

    六月 17th, 2011 at 06:53

    Interesting Article…

    [...]some interesting sites worth visitng. We recommend all our readers go and check these out[...]……


  3. home buiness ideas Says:

    七月 10th, 2011 at 00:04

    Visitor recommendations…

    [...]one of our visitors recently recommended the following website[...]……


  4. Hotels in Prague Says:

    九月 8th, 2011 at 06:07

    Websites worth visiting……

    [...]here are some links to sites that we link to because we think they are worth visiting[...]………


  5. nutrients for growing Says:

    十二月 3rd, 2011 at 14:45

    Visitor recommendations trackback……

    [...]one of our visitors recently recommended the following website[...]………


留下您的脚印