**今天重装了笔记本的win7系统,在重装之前备份了一下数据库。现在mysql服务已经可以启动了,
但是,输入密码后,无法进入,如下图:**
还需要做哪些设置??
求教,挺急的
天蓬老师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.