centos输入show variables like "%auto%"出现该错误,前辈给出了解决办法https://blog.csdn.net/yidragon88xx/article/details/53888719
1.在centos中输入whereis mysql 找到mysql安装目录,我的是/usr/bin/,进入;
2.执行mysql_upgrade -u root -p --force,输入自己mysql的用户root的密码即可;
但我接着出现Native table 'performance_schema'.'session_variables' has the wrong structure错误,同样有前辈指点:https://blog.csdn.net/landylxy/article/details/78477332
命令行直接:set @@global.show_compatibility_56=ON;