Fix Mysql:[error] Native table ' Performance_schema '

Ext.: http://www.amznz.com/error-native-table-performance_schema/

The MySQL database has the following error, mainly due to the upgrading of the MySQL software package, and some of the database table structure changes and does not function properly.

140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Events_waits_current ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Events_waits_history ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Events_waits_history_long ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Setup_consumers ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Setup_instruments ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Setup_timers ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Performance_timers ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Threads ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Events_waits_summary_by_thread_by_event_name ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Events_waits_summary_by_instance ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Events_waits_summary_global_by_event_name ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' File_summary_by_event_name ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' File_summary_by_instance ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Mutex_instances ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Rwlock_instances ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' Cond_instances ' has the wrong structure
140213 16:55:47 [ERROR] Native table ' Performance_schema '. ' File_instances ' has the wrong structure

The fix is simple simply run the following command under root:

/usr/local/mysql/bin/mysql_upgrade-u root-p

After entering the command, you will be asked to verify the MySQL password, and after filling in the password confirm that the repair is complete as shown:

? Original address: http://www.amznz.com/error-native-table-performance_schema/

Fix Mysql:[error] Native table ' Performance_schema '