SQL错误1146 table performance_schema.session_status'

本文共有502个字,关键词:

问题:mysql5.7错误:[Err] 1146 - Table 'performance_schema.session_status' doesn't exist

解决:运行mysql_upgrade

方法:

cd /etc/mysql
mysql_upgrade -uroot -p --force
sudo service mysql restart

注意:如果不重新启动mysql会报错:ERROR 1682 (HY000): Native table  'performance_schema'.'session_variables' has the wrong structure

参考:

http://blog.csdn.net/qq_22642239/article/details/59513956
http://blog.csdn.net/u011726984/article/details/50650299
版权声明:本文为作者原创,如需转载须联系作者本人同意,未经作者本人同意不得擅自转载。
添加新评论
暂无评论