As i was setting up the Datadog Agent, i ran into this error “Native table ‘performance_schema’.’session_variables’ has the wrong structure”
Apparently, this happens if you forget to run mysql_upgrade after a MySQL server upgrade, so in order to fix it, just run:
mysql_upgrade
systemctl restart mysql
Pay attention that a MySQL server is required after running this.
Cheers!