mysql> SHOW GRANTS FOR 'root'@'localhost'; ERROR 1141 (42000): There is no such grant defined for user 'root' on host 'localhost'
时间: 2023-08-09 08:09:10 浏览: 232
解决mysql登录错误:'Access denied for user 'root'@'localhost'
5星 · 资源好评率100%
根据引用\[1\]和引用\[3\]的信息,当执行`mysql> SHOW GRANTS FOR 'root'@'localhost';`命令时,出现了错误1141 (42000),提示在主机localhost上没有为用户root定义的授权。这意味着在localhost上的root用户没有任何授权。
#### 引用[.reference_title]
- *1* [Linux-mysql权限管理](https://blog.csdn.net/qq_36913644/article/details/104413462)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* *3* [MySQL权限管理](https://blog.csdn.net/weixin_42612223/article/details/113854502)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]
阅读全文