“未加载插件‘0’"
问题描述：
将 MySQL 升级到更新版本后，我想连接到服务器时出错:
After upgading MySQL to newer version I have error when I want to connect to server:
ERROR 1524 (HY000): Plugin '0' is not loaded
有什么想法吗?
答
这看起来像 MySQL 中的一个 Bug 作为 错误 #60432修改mysql.user表可以拒绝用户登录.其中指出:
This looks like a Bug in MySQL as Bug #60432
Modifying mysql.user table can deny users from logging in . Which states that:
如果数据库管理器不小心(或故意)修改了mysql.user通过在位置低于(或等于)的位置添加任何列来表max_user_connections"，然后重新加载权限后没有人允许登录.
If database manager accidentally (or deliberately) modifies mysql.user table by adding any column in position lower (or equal) than "max_user_connections", then after reloading privileges no one is allowed to log in.
解决方法:撤消在 user 表中所做的修改.
Workaround: Undoing the modification made in user table.