建站资讯

mysql

作者:admin 发布时间:2021-03-29
mysql_front联接出错,sql实行不正确#3167的处理计划方案 今年九月份五日 1:05 阅读文章(1,066) 评价关掉

提醒:The INFORMATION_SCHEMA.SESSION_VARIABLES feature is disabled; see the documen

提醒:The INFORMATION_SCHEMA.SESSION_VARIABLES feature is disabled; see the documentation patibility_56

从mysql5.rmation_schema.global_status早已刚开始被放弃,以便适配性,patibility_56
MySQL select * rmation_schema.global_status limit 3;
ERROR 3167 (HY000): The INFORMATION_SCHEMA.GLOBAL_STATUS feature is
disabled; see the documentation patibility_56

patibility_56其值
mysql show variables like %patibility_56%
+ + -+
| Variable_name         | Value |
+ + -+
| patibility_56 | OFF   |
+ + -+
1 row in set (0.01 sec)

patibility_56开启
mysql set patibility_56=on;
Query OK, 0 rows affected (0.00 sec)

mysql show variables like %patibility_56%
+ + -+
| Variable_name         | Value |
+ + -+
| patibility_56 | ON    |
+ + -+
1 row in set (0.00 sec)

mysql select * rmation_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数据信息库了,能够多数据库开展图型化的页面实际操作~


收缩