要收回用户权限必须先查看用户权限!
#查看用户权限
show grants for accountadmin@'localhost';
收回部分权限:
SET PERSIST partial_revokes = ON;
REVOKE SELECT ON mysql.* FROM bitnami@'localhost';
收回全部权限:
#收回全部权限
revoke all privileges,grant option from bitnami@'localhost';
参考文献:
手把手教你看MySQL官方文档
https://www.cnblogs.com/mysqljs/p/13181133.html
mysql grant 用户权限总结
https://blog.csdn.net/wulantian/article/details/38230635
SQL之语句分类_绣花针-CSDN博客_sql语言分类https://blog.csdn.net/mmake1994/article/details/85944438# 安装MySQL8.0.25后,出现“Exception: Current profile has no WMI enabled”错误解决方案_灰色芍药的博客-CSDN博客
https://blog.csdn.net/qq_38161520/article/details/117092893
mysql用户授权以及权限收回 - 阿波罗Apollo - 博客园 (cnblogs.com)https://www.cnblogs.com/apollo1616/p/10294578.html