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 :)
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 :)