解决windows10下mysql出现ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘

￡神魔★判官ぃ 2022-11-22 10:21 213阅读 0赞

解决windows10下mysql出现ERROR 1045 (28000): Access denied for user 'root'@'localhost'

因修改登录密码,记不清,导致登录错误.

解决办法:

### 1.找到my.ini,加一句skip-grant-tables ###

注意:下图中该句前的\#要去掉,并且,后面不能带分号,否则mysql服务重启时会出问题,该服务启动不了.

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70][]

### 2.win+r  运行service.msc ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70 1][]

重启与mysql有关的那个服务(我这个把mysql注册为后台运行的时候用的是mysqldb1这个名字,所以这里显示的是mysqldb1.)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70 2][]

### 3.登录mysql,一路回车, ###

### mysql -u root -p ###

不输入密码,成功。

之后,再修改my.ini,把添加的那句,前面加个\#,注释掉使不效或直接删除该句也可.

over.

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70]: /images/20221120/9b2b505fb4d247da9131c3810c81001f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20201104020706911.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201104020908771.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA==,size_16,color_FFFFFF,t_70

解决windows10下mysql出现ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MySQL 登录数据库报错'ERROR 1045 (28000): Access denied for user'..'@'localhost''

相关【未来因你出“粽”_mysql_ERROR 1045 (28000) 】windows ERROR 1045 (28000): Access denied for user ‘root‘@‘local

相关解决windows10下mysql出现ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘

相关 mysql error 1045 授权_MySQl出现ERROR 1045 (28000): Access denied for user 'root'@'localhost'解决方法...

相关 Error 1045(28000) Access Denied for user 'root'@'localhost'

相关解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

相关 mysql 解决ERROR 1045 (28000): Access denied for user'root'@'localhost'(using password:YES)

相关解决mysql出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES/NO)【Mac】

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

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