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

【测试通过】请看
MySQL（版本8.0.*）之后使用mysqld --console --skip-grant-tables --shared-memory跳过权限登录
打开一个命令窗口（CMD(win+R)），进入你安装好的MySQL的bin目录之下执行mysqld --console --skip-grant-tables --shared-memory跳过权限登录。
接着在重新打开一个CDM，（重）之前的不要关闭，同样进入MySQL的bin目录下，执行mysql -u root -p，接着会出现Enter password:，直接回车，就会出现Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 7Server version: 8.0.19 MySQL Community Server - GPLCopyright © 2000, 2020, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.表明登陆成功，然后就是use mysql（意思不用说了吧！）接着就可以修改密码啦， 执行alter user ‘root’@‘localhost’ identified by ‘123456’;这是会报错
1396 (HY000): Operation ALTER USER failed for ‘root’@‘localhost’，别慌，这是需要刷新一下权限，于是接下来先执行flush privileges;刷新权限，接着重新执行alter user ‘root’@‘localhost’ identified by ‘123456’;就会显示Query OK, 0 rows affected (0.08 sec)；修改成功，退出exit，重新登陆MySQL，完成。
特别说明如果MySQL数据库版本是5.7.11之前的可以使用mysqld --skip-grant-tables跳过权限登陆否则就使用以上的。