打开mysql.ini配置文件
![一招解决 MySQL Access denied for user [email protected]](/default/index/img?u=aHR0cHM6Ly9waWFuc2hlbi5jb20vaW1hZ2VzLzQ5NS9lZmE0NjFjYzk1YzhhODk3MTc3YzFhNDg5YWVlZWY3Zi5wbmc= "一招解决 MySQL Access denied for user [email protected]")
找到[mysqld]，在下面添加skip-grant-tables，如下图
![一招解决 MySQL Access denied for user [email protected]](/default/index/img?u=aHR0cHM6Ly9waWFuc2hlbi5jb20vaW1hZ2VzLzYzNS83MDhhMjljMTk3MTZmMjNmYTFjY2Q3YzMyMGMwODA4My5wbmc= "一招解决 MySQL Access denied for user [email protected]")
然后重启MySQL服务
cmd 进入MySQL 的bin 目录下
输入命令：mysql -u root -p
出现Enter password 按下回车键
然后输入use mysql
然后输入：update user set authentication_string=password(“123456”) where user=“root”;
最后输入：flush privileges;
然后重启MySQL服务即可。
![一招解决 MySQL Access denied for user [email protected]](/default/index/img?u=aHR0cHM6Ly9waWFuc2hlbi5jb20vaW1hZ2VzLzIxNC8xNDU3MjgxYjBiMjliYzU0OTlkYWJmMjVhYTYyMjk0ZS5wbmc= "一招解决 MySQL Access denied for user [email protected]")
亲测可用！
