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

亦凉 2024-03-16 21:31 14阅读 0赞

## 问题 ##

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

### 解决 ###

#### 通过查询—找到了解决方案 ####

> 首先，使用管理员身份登录到`cmd命令行窗口`;  
> 其次，在命令行中，输入`net stop mysql`—使其停止mysql服务；  
> 然后，输入`mysqld --console --skip-grant-tables --shared-memory`—跳过权限认证；  
> 最后，管理员身份打开看新命令行窗口，依次输入`mysql`&&`flush privileges;`

![在这里插入图片描述][204caf635f6648399c712a51f2ab0516.png]  
![在这里插入图片描述][88cfdc7b670345289c55c99f47d4f82a.png]  
**new windows**

![在这里插入图片描述][993ad199c3844d5c98378d991876dd97.png]  
![在这里插入图片描述][0c13d9abd93c4579a664c13c60dee2ce.png]  
![在这里插入图片描述][4223f41c9ca8466c8204d297f1f01033.png]

##### 修复后 可修改 数据库 密码 #####

`set password for root@localhost = password('8888888')`

##### 退出mysql #####

·`quit`·

##### 。。。 #####

##### 实则，flush之后就可以正常使用啦~ #####

![在这里插入图片描述][1645849eef404c67affd366233acf281.png]

###### reference ######

[参考文章][Link 1]

### 大家加油~~~ ###

## 成长的路上，挫折常在，一起加油~~~fighting~ ##

[204caf635f6648399c712a51f2ab0516.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/d2e6a2aea17d422d9393a04a66ad6a53.png
[88cfdc7b670345289c55c99f47d4f82a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/76894c7ace6441c584887f4b9cc21580.png
[993ad199c3844d5c98378d991876dd97.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/5eef7598a7f045578b8bc9984016bb1d.png
[0c13d9abd93c4579a664c13c60dee2ce.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/1de93e3259884af595fd7357e946b545.png
[4223f41c9ca8466c8204d297f1f01033.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/df5a9b7d37b24f239e6de7226668fc9d.png
[1645849eef404c67affd366233acf281.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/c5619121debe4351bfcdf5394a6d32fb.png
[Link 1]: http://t.csdn.cn/MamRl

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

发表评论取消回复

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

相关阅读

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

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

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

相关 HIVE-ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

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

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

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

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

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

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