回到家，把学校拷的软件（tomcat,MyEclipse，mysql，Navicat...）给更新了下。结果出问题了，MyEclipse连不上数据库。Navicat Premium 可以连。提示信息是
Native table 'performance_schema'.'session_variables' has the wrong structure；
我百度试了试 mysql_upgrade 提示already upgrade..... 还有重启服务器mysql.service restart，提示不是内部外部指令。
'session_variables' has the wrong structure
- 写回答
- 好问题 0 提建议
- 关注问题
分享- 邀请回答
-
3条回答 默认 最新
- hyf9457 2017-01-25 08:28关注
谢了 已经解决了。 用net mysql stop 再 net mysql start 重启了 就好使了。 之前用restart 一直不行
评论 打赏解决 2无用举报 分享
- 2023-05-12 14:16AnchorSpace的博客 原因是升级了mysql的版本，可以在cmd中使用。
- 2024-03-18 10:19@Saint的博客 ‘session_variables’ has the wrong structure mysql 5.6升级到mysql5.7查看参数报错 root@localhost [(none)]>show variables like ‘%data%’; ERROR 1682 (HY000): Native table ‘performance_schema’....
- 小T猴的博客 两种方式： 1、在命令行状态下：mysql_upgrade -u root -p --force，重启mysqlServer； 2、命令行状态下： mysql -u app -p mysql> set @@global.show_compatibility_56=ON;
- LI_AINY的博客 Native table 'performance_schema'.'session_variables' has the wrong structure cmd’进入mysqlmysql -u root -p 执行set @@global.show_compatibility_56=ON;
- 2019-11-07 10:14小小的木头人的博客 --从mysql5.7.6开始information_schema.global_status已经开始被舍弃，为了兼容性，此时需要打开 show_compatibility_56 2）character_set_database ，collation_database Value改为utf8，修改my.conf ...
- 2024-02-02 15:43戒掉贪嗔痴的博客 ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong structure 15:35: [(none)]> set @@global.show_compatibility_56=ON; Query OK, 0 rows affected (0.00 sec) 4.检查。...
- 2019-06-26 16:46hzp666的博客 https://blog.csdn.net/landylxy/article/details/78477332 命令行直接：set @@global.show_compatibility_56=ON;
- 2017-11-08 12:43gerberasn的博客 命令行直接：set @@global.show_compatibility_56=ON;
- 2018-02-13 10:11七岁小男孩的博客 schema.session_variables' doesn't exist（某表不存在）的错误第一：运行之前编写的myeclipse测试，发现第二个Native table 'performance_schema'.'session_variables' has the wrong structure（某表结构错误）的...
- 2019-05-05 16:48
问题解答1：ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong struct尘埃落定2000的博客 数据库MySQL在MySQL5.7.6版本之后，导入的文件只能在secure_file_priv 指定的文件夹下。 执行 mysql> show variables like ‘%secure%’; ERROR 1682 (HY000): ...‘session_variables’ has the wrong structu... - 2021-02-07 22:43weixin_39998521的博客 出现的原因是我升级了mysql的版本. 只要root用户执行以下语句即可. # mysql_upgrade -u root -p --force # ... # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/
- 2019-04-04 09:25 阿里云MySql数据库突然出现运行查询语句失败提示：Native table 'performance_schema'.'session_variables' has the wrong structPillar~的博客 1、问题描述： 阿里云数据库MySQL运行查询语句突然...‘session_variables’ has the wrong structure 3、问题原因：MySQL过时，需要升级 4、解决办法： 只要root用户执行以下语句即可： # mysql_upgrade -...
- 2016-02-10 21:42一大三千的博客 # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 127.0.0.1 log-error = /var/log/mysql/error.log # ...
- 2017-02-16 16:33Time-Traveller的博客 今天，升级了MySQL 5.7，使用mysql...先提示’performance_schema’.’session_variables’不存在，后来提示结构错误：mysql-workbench Connecting to MySQL server ... Native table 'performance_schema'.'session_va
- 2018-11-05 15:35ahisky的博客 Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;... Type '\c' to clear the current i...
- weixin_30474613的博客 err: 150418 13:25:06 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 150418 13:25:06 [ERROR] Native table 'performance_schema'.'events_waits_current' has the ...
- 2017-11-09 14:53weixin_33701617的博客 mysql_upgrade -u root -p--force 升级完重启 转载于:https://www.cnblogs.com/long613/p/7809377.html
- haohao_ding的博客 报 1146 "Table 'performance_schema.session_variables' doesn't exist" 原因： MySQL 5.5新增一个存储引擎：命名PERFORMANCE_SCHEMA ,主要用于收集数据库服务器性能参数。MySQL用户是不能创建存储引擎为...
- 没有解决我的问题, 去提问