Tuesday, April 28, 2020

mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'':

Issue happens when I take a mysqldump after I upgrade Mysql 5.5 to Mysql 5.7

Error:

[root@ip-10-26-91-168 mnt]# mysqldump -u userone -p db1 > db1.sql
Enter password:
mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Native table 'performance_schema'.'session_variables' has the wrong structure (1682)
[root@ip-10-26-91-168 mnt]#

Solution:

Login to the server as root

# mysql_upgrade -u root -p --force
# systemctl restart mysqld

This helped to fix my issue :)