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                            |