When trying to connect to mysql version 5.7.41, the error below occurs. "performance_schema.session_variables doesn't exist" I know this is a problem with the server, but I cannot fix it because I do not have DB management rights. I can access and query this database with DBeaver, but the same error occurs when i try to access system info. Is there a way to connect and query using heidisql?
'performance_schema.session_variables' doesn't exist
I tried using 'dbeaver' as another client. There is no problem when connecting from dbeaver, and queries are executed normally. However, when trying to access system information such as 'Session Status' and 'Global Status', the error 'performance_schema.session_variables doesn't exist' occurs.
It is assumed that information may have been corrupted during the process of updating the mysql version. However, as I said above, I am not a DB administrator, so I cannot solve this problem. Services using the DB are currently operating normally. So, I think there is no problem in the connection and query process.
Then it's obviously a corrupted MySQL update which caused the non existing table.
I am just reading on stackoverflow, your server administrator may try to upgrade to solve the issue:
mysql_upgrade -u root -p --force
Afterwards restart the server.
Please login to leave a reply, or register at first.