Table ‘performance_schema.session_variables’ doesn’t exist

December 18, 2017Comments

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

解决方法：
1:UPGRADE MySQL

mysql_upgrade -u root -p --force

0	mysql_upgrade -u root -p --force

2:重新启动MySQL

net stop mysql
net start mysql

0 1	net stop mysql net start mysql

3:重置密码

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

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

文章源自 note.t4x.orgByrd's Blog-https://note.t4x.org/error/table-performance_schema-session-variables-doesnt-exist/ 文章源自 note.t4x.orgByrd's Blog-https://note.t4x.org/error/table-performance_schema-session-variables-doesnt-exist/

申明：除非注明Byrd's Blog内容均为原创,未经许可禁止转载!详情请阅读版权申明!

On this day in past years

December

2012EIGRP等价负载和不等价负载均衡

Hot search

On this day in past years