每次我尝试并添加一个权限，我得到以下错误：
ERROR 2013 (HY000): Lost connection to MySQL server during query 这发生在terminal和通过PhpMyAdmin使用mysql
执行更改的用户是具有所有权限和GRANT选项的root用户。 无论我设置的权限，无论是，所有，授予，没有授予，只需select。 他们都只是有这个错误。
任何想法为什么？
最近从5.0.1 – > 5.6升级
我已经重新启动MySQL
我曾尝试冲洗特权
# mysql --version mysql Ver 14.14 Distrib 5.6.19, for Linux (x86_64) using EditLine wrapper mysql> select current_user(); +----------------+ | current_user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.00 sec) mysql> select user(); +----------------+ | user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.00 sec) mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user; +---------------------------+------------------+-------------------------------------------+------------+------------+ | host | user | password | Grant_priv | Super_priv | +---------------------------+------------------+-------------------------------------------+------------+------------+ | localhost | root | *hash | Y | Y | | localhost | debian-sys-maint | *hash | Y | Y | ...trim... +---------------------------+------------------+-------------------------------------------+------------+------------+ 15 rows in set (0.00 sec)
试试mysql_fix_privilege_tables – 升级MySQL系统表。
结果yum没有更新数据库，
2014-07-14 14:49:27 2135 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2014-07-14 14:49:27 2135 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2014-07-14 14:49:27 2135 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2014-07-14 14:49:27 2135 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2014-07-14 14:49:27 2135 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2014-07-14 14:49:27 2135 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2014-07-14 14:49:27 2135 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
运行mysql_update -u root -p<pw>对它进行sorting
我今天在Gentoo上有类似的东西。 有mysql_upgrade固定的东西给我。
查看一个gdb会话的细节， mysqld在从mysql_grant调用的函数replace_user_table尝试访问mysql.user表的MYSQL_USER_FIELD_PLUGIN aka plugin列时MYSQL_USER_FIELD_PLUGIN ，这个列表在我的系统上还是不存在。
我认为，如果系统表模式已经过时，服务器会崩溃，但是显然这就是写入的方式。