150814 9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
150814 9:09:14 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
150814 9:09:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Atomicorp
Then I run
mysql_upgrade
It shows:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed
It seems this happens after you have done upgrade. Simply restart mysql:
service mysql restart
and the error should now have disappeared.
If you're running MySQL on your local device, you need to upgrade your mysql and then restart:
Upgrade:
$ mysql_upgrade -u root
Restart:
$ mysql.server restart
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With