【mysql连接与mysqldump】INFORMATION_SESSION_VARIABLES feature is disabled

2023-02-17,,,,

摘要: mysql5.7 客户端连接出现:INFORMATION_SESSION_VARIABLES feature is disabled问题:

mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `GLOBAL_STATUS`': The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56' (3167)

从mysql5.7.6开始information_schema.global_status已经开始被舍弃,为了兼容性,mysql提供了向下兼容的参数:show_compatibility_56,默认是OFF。

mysql5.7 客户端连接出现:INFORMATION_SESSION_VARIABLES feature is disabled问题:

从mysql5.7.6开始information_schema.global_status已经开始被舍弃,为了兼容性,mysql提供了向下兼容的参数:show_compatibility_56,默认是OFF。

临时调整:
set global show_compatibility_56=on;

修改mysql配置文件:
[mysqld]
show_compatibility_56=on

【mysql连接与mysqldump】INFORMATION_SESSION_VARIABLES feature is disabled的相关教程结束。

《【mysql连接与mysqldump】INFORMATION_SESSION_VARIABLES feature is disabled.doc》

下载本文的Word格式文档,以方便收藏与打印。