Hint: the ' information_schema. Session_variables ' feature is disabled; See the documentation for ' show_compatibility_56 '
The following transfers are from: http://blog.csdn.net/rudygao/article/details/50403107
--Starting from mysql5.7.6 Information_schema.global_status has started to be discarded, for compatibility, this time need to open 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 '
--View show_compatibility_56 its value
Mysql> Show variables like '%show_compatibility_56% ';
+-----------------------+-------+
| variable_name | Value |
+-----------------------+-------+
| show_compatibility_56 | OFF |
+-----------------------+-------+
1 row in Set (0.01 sec)
--Open the 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)
MySQL 5.7.10 using dbforget Studio Connection exception