进入mysql-front时报错：#3167

最近在使用mysql-front，连接时报错了，找到以下解决方案，供大家参考

首先打开Mysql command line client ->输入密码登录->键入sql语句

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'

mysql> show variables like '%show_compatibility_56%';

+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| show_compatibility_56 | OFF |
+-----------------------+-------+
1 row in set, 1 warning (0.01 sec)

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 | 4 |
| ABORTED_CONNECTS | 0 |
| BINLOG_CACHE_DISK_USE | 0 |
+-----------------------+----------------+
3 rows in set, 1 warning (0.00 sec)

然后就好了