mysql 5.7.10使用dbforget Studio 连接异常 提示:The'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is dis
来源:互联网 发布:文件服务器监控软件 编辑:程序博客网 时间:2024/05/18 22:18
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)
- mysql 5.7.10使用dbforget Studio 连接异常 提示:The'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is dis
- mysql 5.7.10使用dbforget Studio 连接异常 提示:The'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is dis
- mysql 5.7.10使用客户端mysql-font 连接异常 提示:The'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is dis
- mysql 5.7.10使用dbforget Studio 连接异常
- mysql 5.7.10使用dbforget Studio 连接异常
- mysql 5.7.11使用dbforget Studio 连接异常
- MySQL INFORMATION_SCHEMA 使用
- dbforget mysql connection 20171118
- 解决MySQL The 'InnoDB' feature is disabled 的问题
- 解决mysql 添加插件时提示 ERROR 1289 (HY000): The ‘plugin’ feature is disabled; you need MySQL built with ‘HAVE_DLOPEN&#
- MySQL数据库执行sql语句创建数据库和表提示The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist
- 运行mysql时,提示Table ‘performance_schema.session_variables’ doesn’t exist
- [解决方法]Eclipse连接mysql失败:Error1682:Native table 'performance_schma'.'session_variables'
- java连接mysql、 Table 'performance_schema.session_variables' doesn't exist
- Mysql Native table 'performance_schema'.'session_variables' has the wrong structure
- Mysql 5.7 information_schema相关介绍
- information_schema mysql
- mysql非安装版安装与配置
- 伯克利包过滤(Berkeley Packet Filter,BPF)语言
- leetcode---Search a 2D Matrix
- float,double和decimal类型
- Java基础知识学习(一)
- mysql 5.7.10使用dbforget Studio 连接异常 提示:The'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is dis
- Wireshark和TcpDump抓包分析心得
- tikz-坐标平移
- 326. Power of Three
- MySQL5.7 更改root密码时报错
- 【Java基础三】InputStream获取文件并保存
- 苹果邓白氏编码 以及申请开发者账号流程
- MySQL安装板安装及配置详细图解
- FZU 1056之扫雷游戏