开发者社区> 问答> 正文

MySQL-Front连接数据库报错

数据库添加了允许所有外网访问: 经典网络 0.0.0.0/0; MySQL-Front连接数据库是却报错:
SQL执行错误#3167.从数据库的响应:"The'INFORMATION_SCHEMA.SESSION_VARIABLES'feature is disabled;see the documentation for 'show_compatibility_56'

展开
收起
xicunnet 2018-11-11 21:28:26 816 0
1 条回答
写回答
取消 提交回答
  • 阿里云论坛版主,QQ 1978638808
    --从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)
    2018-11-11 21:49:13
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
DTCC 2022大会集锦《云原生一站式数据库技术与实践》 立即下载
阿里云瑶池数据库精要2022版 立即下载
2022 DTCC-阿里云一站式数据库上云最佳实践 立即下载

相关镜像