mysql 5.7.10使用dbforget Studio 连接异常

mysql 5.7.10使用dbforget Studio 连接异常

https://blog.csdn.net/makyan/article/details/51704816/

mysql> select * from information_schema.global_status limit 3;
3167 - The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'
mysql> show variables like '%show_compatibility_56%';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| show_compatibility_56 | OFF |
+-----------------------+-------+
1 row in set (0.03 sec)

mysql> set global show_compatibility_56=on;
Query OK, 0 rows affected (0.04 sec)

mysql> show variables like '%show_compatibility_56%';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| show_compatibility_56 | ON |
+-----------------------+-------+
1 row in set (0.02 sec)

mysql> select * from information_schema.global_status limit 3;
+-----------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+-----------------------+----------------+
| ABORTED_CLIENTS | 3 |
| ABORTED_CONNECTS | 1 |
| BINLOG_CACHE_DISK_USE | 0 |
+-----------------------+----------------+
3 rows in set (0.02 sec)

mysql>