mysql_front连接报错,sql执行错误#3167的解决方案

提示:The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documen…

提示:The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'

–从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_front连接到mysql数据库了,可以对数据库进行图形化的界面操作~

作者: admin

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam viverra euismod odio, gravida pellentesque urna varius vitae. Sed dui lorem, adipiscing in adipiscing et, interdum nec metus. Mauris ultricies, justo eu convallis placerat, felis enim ornare nisi vitae.

为您推荐

联系我们

联系我们

返回顶部