1. 论坛系统升级为Xenforo，欢迎大家测试！
    Dismiss Notice

MySQL 的 root 密码不知道，该如何修改呢？

Discussion in '后端开发' started by Ulysses, Sep 9, 2009.

  1. Ulysses

    Ulysses New Member

    Joined:
    Feb 5, 2006
    Messages:
    10,018
    Likes Received:
    16
    Windows 上安装的 MySQL ，应该如何修改 root 密码？

    看到有介绍用一个什么启动参数。对在 CMD 中操作不熟悉，谁能给个详细的步骤？

    谢谢！
     
    #1 Ulysses, Sep 9, 2009
  2. wmchief

    wmchief New Member

    Joined:
    Sep 6, 2005
    Messages:
    4
    Likes Received:
    0
    最简单的方法是用phpmyadmin修改user表（记得选password函数），修改后重启mysql
     
    #2 wmchief, Sep 9, 2009
  3. 风狼

    风狼 New Member

    Joined:
    Oct 1, 2005
    Messages:
    7,452
    Likes Received:
    25
    连root的密码都不记得，如何使用phpmyadmin？楼上的？
     
    #3 风狼, Sep 9, 2009
  4. Ulysses

    Ulysses New Member

    Joined:
    Feb 5, 2006
    Messages:
    10,018
    Likes Received:
    16
    哎，root 密码写在了某程序的配置文件中，我真是服了那家伙……
     
    #4 Ulysses, Sep 9, 2009
  5. wm_chief

    wm_chief New Member

    Joined:
    Sep 5, 2005
    Messages:
    17,890
    Likes Received:
    46
    那要在命令行下运行safe_mysqld --skip-grant-tables&
    再进行密码修改
     
    #5 wm_chief, Sep 9, 2009
  6. apple

    apple New Member

    Joined:
    May 22, 2006
    Messages:
    9,561
    Likes Received:
    78
    :D:D
     
    #6 apple, Sep 9, 2009
  7. Ulysses

    Ulysses New Member

    Joined:
    Feb 5, 2006
    Messages:
    10,018
    Likes Received:
    16
    看到网上的帖子中就是这么介绍的，但是具体的操作命令，我不会啊。

    好在从配置文件找到密码了，可是程序的管理员密码又不知道。

    覆盖没效果，正在努力中。
     
    #7 Ulysses, Sep 9, 2009
  8. swsw007

    swsw007 New Member

    Joined:
    Jul 4, 2006
    Messages:
    2,228
    Likes Received:
    1
    牛人到。
     
    #8 swsw007, Sep 9, 2009
(You must log in or sign up to post here.)
Toggle Width
Language
English (US)