1.无法查看mysql变量 

从mysql5.7.6开始information_schema.global_status已经开始被舍弃,为了兼容性,
此时需要打开 show_compatibility_56

2.修改参数文件 。

vi /etc/my.cnf 
[mysqld]
show_compatibility_56=ON

3.直接修改变量。

15:35:  [(none)]> show variables like '%log%';
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.检查。

15:39:  [(none)]> select version();
+------------+
| version()  |
+------------+
| 5.7.43-log |
+------------+
1 row in set (0.00 sec)
15:36:  [(none)]> show variables like '%log%';
+--------------------------------------------+--------------------------------------------------------------+
| Variable_name                              | Value                                                        |
+--------------------------------------------+--------------------------------------------------------------+
| back_log                                   | 1024                                                         |
| binlog_cache_size                          | 4194304                                                      |
| binlog_checksum                            | CRC32                                                        |
| binlog_direct_non_transactional_updates    | OFF                                                          |
| binlog_error_action                        | ABORT_SERVER                                                 |

5.总结 
针对MySQL5.7,应该设置:
set @@global.show_compatibility_56=ON;

更多推荐