mysql 5.7.10使用客户端mysql-font 连接异常 提示：The'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is dis

mysql 5.7.10使用dbforget Studio 连接异常

提示：The'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see thedocumentation for 'show_compatibility_56'

 

以下转自：http://blog.csdn.NET/rudygao/article/details/50403107

 

--从mysql5.7.6开始information_schema.global_status已经开始被舍弃，为了兼容性，此时需要打开show_compatibility_56

MySQL> select * from information_schema.global_status limit 3; ERROR 3167 (HY000): The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'     --查看show_compatibility_56其值 MySQL> show variables like '%show_compatibility_56%'; +-----------------------+-------+ | Variable_name         | Value | +-----------------------+-------+ | show_compatibility_56 | OFF   | +-----------------------+-------+ 1 row in set (0.01 sec)     --把show_compatibility_56打开 mysql> set global show_compatibility_56=on; Query OK, 0 rows affected (0.00 sec)     mysql> show variables like '%show_compatibility_56%'; +-----------------------+-------+ | Variable_name         | Value | +-----------------------+-------+ | show_compatibility_56 | ON    | +-----------------------+-------+ 1 row in set (0.00 sec)     mysql> select * from information_schema.global_status limit 3; +-----------------------+----------------+ | VARIABLE_NAME         | VARIABLE_VALUE | +-----------------------+----------------+ | ABORTED_CLIENTS       | 0              | | ABORTED_CONNECTS      | 0              | | BINLOG_CACHE_DISK_USE | 0              | +-----------------------+----------------+ 3 rows in set, 1 warning (0.00 sec)