mysql5.7.20使用mysqlFront 连接异常:INFORMATION_SCHEMA.SESSION_VARIABLES

最新推荐文章于 2025-07-26 15:37:27 发布

原创最新推荐文章于 2025-07-26 15:37:27 发布 · 785 阅读

1 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

3 篇文章

订阅专栏

本文介绍在MySQL5.7.6及更高版本中，由于information_schema.global_status被弃用，如何通过开启show_compatibility_56来查询全局状态变量的方法。包括检查当前设置、开启兼容性选项及验证是否成功。

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

以下转自：http://blog.youkuaiyun.com/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)