search

Home  >  Q&A  >  body text

系统重装后,恢复mysql5.5?

**今天重装了笔记本的win7系统,在重装之前备份了一下数据库。现在mysql服务已经可以启动了,
但是,输入密码后,无法进入,如下图:**

还需要做哪些设置??
求教,挺急的

黄舟黄舟2864 days ago650

reply all(1)I'll reply

  • 天蓬老师

    天蓬老师2017-04-17 15:37:13

    mysql -uroot -p password, you did not write the password.

    If you forget your password, just reset it.

    1. Command prompt 1 window: End the mysql service through taskkill /f /im mysqld-nt.exe
    2. Start mysql through mysqld-nt.exe –skip-grant-tables
    3. New Open the Command Prompt 2 window: execute mysql.exe and enter without entering a password.
    4. update users set password=password('your password') where user='root';
    5. Close the command prompt 1 window and restart the MySQL service.

    reply
    0
  • Cancelreply