ERROR 1682 (HY000): Native table ‘performance_schema’.‘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’.‘session_variables’ has the wrong structure
–从mysql5.7.6开始information_schema.global_status已经开始被舍弃，为了兼容性，此时需要打开 show_compatibility_56
解决办法
root@localhost [(none)]>set @@global.show_compatibility_56=ON;
Query OK, 0 rows affected (0.00 sec)
root@localhost [(none)]>show variables like ‘%data%’;
±--------------------------------------±----------------------------+
| Variable_name | Value |
±--------------------------------------±----------------------------+
| character_set_database | utf8 |
| collation_database | utf8_general_ci |
| datadir | /data/mysql/mysql3306/data/ |
| innodb_data_file_path | ibdata1:12M:autoextend |
| innodb_data_home_dir | |
| innodb_stats_on_metadata | OFF |
| innodb_temp_data_file_path | ibtmp1:12M:autoextend |
| max_length_for_sort_data | 1024 |
| metadata_locks_cache_size | 1024 |
| metadata_locks_hash_instances | 64 |
| myisam_data_pointer_size | 6 |
| performance_schema_max_metadata_locks | -1 |
| skip_show_database | OFF |
| updatable_views_with_limit | YES |
±--------------------------------------±----------------------------+
14 rows in set (0.00 sec)
