Windows下 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

分类: 文章 • 2023-10-14 17:10:28

1、找到配置文件my.ini，用记事本打开

2、在mysqld关键字后面添加skip-grant-tables，保存退出

Windows下 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

my.ini保存后重新启动mysql服务

Windows下 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

3、运行cmd，输入mysql -u root -p，回车出现password不用输入密码直接回车进入

Windows下 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

4、进入mysql数据库

Windows下 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

为root用户设置新密码

Windows下 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

刷新数据库

Windows下 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

退出mysql

Windows下 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

5、修改完root密码后，将my.ini文件添加的skip-grant-tables删除，保存重启mysql服务就可以通过密码登陆mysql了

Windows下 MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)