has the wrong structure
mysql 5.6升级到5.7之后报错
root@localhost:mysql.sock [test]>show variables like '%log%' ;
ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong structure
重启之后问题得到解决
[root@gg ~]# /etc/init.d/mysql.server restart
Shutting down MySQL...[ OK ]
Starting MySQL...[ OK ]
[root@gg ~]#
[root@gg ~]#
[root@gg ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.22 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
root@localhost:mysql.sock [(none)]>
root@localhost:mysql.sock [(none)]>
root@localhost:mysql.sock [(none)]>
root@localhost:mysql.sock [(none)]>show variables like '%log%' ;
+--------------------------------------------+--------------------------------+
| Variable_name | Value |
+--------------------------------------------+--------------------------------+
| back_log | 80 |
| binlog_cache_size | 32768 |
| binlog_checksum | CRC32 |
| binlog_direct_non_transactional_updates | OFF |
最新文章
- errno.h
- winform用户控件、动态创建添加控件、timer控件、控件联动
- Cocos2d-x 核心概念 - 坐标系(UI.OpenGL.世界坐标系.模型坐标系)
- 深入理解计算机系统-从书中看到了异或交换ab两个值的新感
- UnWind Segue
- 在serviceImpl里使用自身的方法
- AJax学习一
- Python中Cookie的处理（二）cookielib库
- （转载）ubuntu安装pyton-pip问题解决
- Windows Form简易计算器实现（下）
- AngularJs ui-router 路由的介绍
- B/S与C/S架构
- 5)django-模板
- SpringBoot注解大全（转）
- 分布式作业 Elastic-Job 快速上手指南，从理论到实战一文搞定！
- Linux中的Diff和Patch
- （六）cxf处理一些Map等复杂类型
- redis 的消息订阅和消息队列的功能比较
- 第一篇，编译生成libcef_dll_wrapper
- Android WebView H5开发拾遗