Tag Archives: 1146 – Table ‘performance_schema.session_variables’ doesn’t exist

[Solved] 1146 – Table ‘performance_schema.session_variables’ doesn’t exist

1146 – Table ‘performance_ schema.session_ variables’ doesn’t exist

The scene of a problem

1 when flash uses Sqlalchemy to operate mysql,

appears

2 when using Navicat to connect to the database,

2 will appear

Attachment: key points of connecting Navicat to success

(1) Users are required to have sufficient permissions

(2) Mysql database does not allow these client tools to connect by default. You need to change the bind address = 127.0.0.1 in/etc/MySQL/mysql.conf.d/mysqld.cnf file to bind address = 0.0.0.0 and restart (my environment is Ubuntu)

II. Solutions

mysql_upgrade -u root -p --force  # Upgrade to fix MySQL database structure errors
sudo service mysql restart # Restart