系统重装后,恢复mysql5.5?
黄舟
黄舟 2017-04-17 15:35:13
0
1
653

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

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

黄舟
黄舟

人生最曼妙的风景,竟是内心的淡定与从容!

reply all(1)
Peter_Zhu

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.

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template