dbforget mysql connection 20171118

dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql connection 20171118dbforget mysql $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

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)