Table ‘performance_schema.session_variables’ doesn’t exist

  • A+
所属分类：Error

MySQL报错：Table 'performance_schema.session_variables' doesn't exist

解决方法：
1:UPGRADE MySQL

0
mysql_upgrade -u root -p --force

2:重新启动MySQL

0
1
net stop mysql
net start mysql

3:重置密码

0
1
2
mysqld --defaults-file="../my.ini" --skip-grant-tables
update mysql.user set authentication_string=password('admin') where user='root' and Host = 'localhost';
mysqladmin shutdown -uroot -p