INFORMATION_SESSION_VARIABLES feature is disabled问题

本文涉及的产品
云数据库 RDS MySQL,集群系列 2核4GB
推荐场景:
搭建个人博客
RDS MySQL Serverless 基础系列,0.5-2RCU 50GB
云数据库 RDS MySQL,高可用系列 2核4GB
简介:

12233

mysql5.7 客户端连接出现:INFORMATION_SESSION_VARIABLES feature is disabled问题:

从mysql5.7.6开始information_schema.global_status已经开始被舍弃,为了兼容性,mysql提供了向下兼容的参数:show_compatibility_56,默认是OFF。

临时调整:
set global show_compatibility_56=on;

修改mysql配置文件:
[mysqld]
show_compatibility_56=on

相关实践学习
如何在云端创建MySQL数据库
开始实验后,系统会自动创建一台自建MySQL的 源数据库 ECS 实例和一台 目标数据库 RDS。
全面了解阿里云能为你做什么
阿里云在全球各地部署高效节能的绿色数据中心,利用清洁计算为万物互联的新世界提供源源不断的能源动力,目前开服的区域包括中国(华北、华东、华南、香港)、新加坡、美国(美东、美西)、欧洲、中东、澳大利亚、日本。目前阿里云的产品涵盖弹性计算、数据库、存储与CDN、分析与搜索、云通信、网络、管理与监控、应用服务、互联网中间件、移动服务、视频服务等。通过本课程,来了解阿里云能够为你的业务带来哪些帮助     相关的阿里云产品:云服务器ECS 云服务器 ECS(Elastic Compute Service)是一种弹性可伸缩的计算服务,助您降低 IT 成本,提升运维效率,使您更专注于核心业务创新。产品详情: https://www.aliyun.com/product/ecs
目录
相关文章
|
4月前
|
Oracle 关系型数据库
Mixed Mode Auditing
Mixed Mode Auditing
20 1
|
机器学习/深度学习 PyTorch 算法框架/工具
【完美解决】RuntimeError: one of the variables needed for gradient computation has been modified by an inp
将loss.backward()函数内的参数retain_graph值设置为True, loss.backward(retain_graph=True),如果retain_graph设置为False,计算过程中的中间变量使用完即被释放掉。
1516 0
|
应用服务中间件 Android开发
a configuration error occurred during startup. place verify the preference field whth the prompt:TomcatJDK name:
a configuration error occurred during startup. place verify the preference field whth the prompt:TomcatJDK name:
129 0
a configuration error occurred during startup. place verify the preference field whth the prompt:TomcatJDK name:
|
安全 对象存储
set_time_limit() has been disabled for security reasons
set_time_limit() has been disabled for security reasons
159 0
set_time_limit() has been disabled for security reasons
We cannot activate inspection type for article master in transaction code MM41?
We cannot activate inspection type for article master in transaction code MM41?
We cannot activate inspection type for article master in transaction code MM41?
How to give query view parameter values in APF
How to give query view parameter values in APF
114 0
How to give query view parameter values in APF
After Opp is saved - change mode filling place
After Opp is saved - change mode filling place
112 0
After Opp is saved - change mode filling place
Another approach to enable table edit in SE16
Another approach to enable table edit in SE16
105 0
Another approach to enable table edit in SE16
成功解决Instructions for updating: Use `tf.global_variables_initializer` instead.
成功解决Instructions for updating: Use `tf.global_variables_initializer` instead.