1045 access denied for user 'root'@'localhost'

navicat 提示“1045 access denied for user ‘root’@’localhost’ ”解决方法

我的mysql安装在D:\xampp\mysql
1. 关闭mysql
2. 管理员dos打开mysql的bin目录，cd /d D:\xampp\mysql\bin
3. 关闭权限检查D:\xampp\mysql\bin>mysqld –defaults-file=”D:\xampp\mysql\bin\my.ini” –console –skip-grant-tables
4. 再打开新的dos终端，D:\xampp\mysql\bin>mysql -uroot mysql
5. mysql> UPDATE user SET Password=PASSWORD(‘要设定的密码’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
ctrl+c
6. D:\xampp\mysql\bin>mysqladmin shutdown，重启mysql