[ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)]

问题解决 [ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)]

1、找到MySQL文件夹下的my.ini,在[mqsqld]下添加如下指令（登录时跳过权限检查），并保存：

[mysqld]
skip-grant-tables

2、重启MySQL服务，并重连MySQL服务

mysql -u root

3、修改密码

use mysql;
update user set password=password('123456') where User='root';
flush privileges;

4、重启MySQL服务，使用那navicat连接