Symptoms
After upgrading MySQL, logging into phpMyAdmin presents the below error.
Another symptom of this problem would present the below login failure for phpMyAdmin.
This problem can also affect Backups or Transfers. The mysqldump command will return the below error:
[2021-01-08 21:08:38 +0500] mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Table 'performance_schema.session_variables' doesn't exist (1146)
[2021-01-08 21:08:38 +0500] mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Table 'performance_schema.session_variables' doesn't exist (1146)
[2021-01-08 21:08:38 +0500] mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Table 'performance_schema.session_variables' doesn't exist (1146)
Description
During the process of upgrading MySQL, it may be necessary to update the performance schema tables of the original process for mysql_upgrade didn't complete the task. Upgrading MySQL may generally involve structure changes for several of the system tables. Always be sure to create backups before upgrading MySQL.
Workaround
Perform the system table upgrade via SSH or terminal as the root user.
Note: These commands should be performed by the system administrator.
/usr/bin/mysql_upgrade -sf
/scripts/restartsrv_mysql