关闭

mysql 5.7.10使用dbforget Studio 连接异常 提示:The'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is dis

359人阅读 评论(0) 收藏 举报
分类:

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)

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:381346次
    • 积分:5316
    • 等级:
    • 排名:第5305名
    • 原创:99篇
    • 转载:383篇
    • 译文:0篇
    • 评论:34条
    最新评论