MySQL - ERROR Missing system table mysql.proxies priv; please run mysql upgrade to create it

Материал из Wiki - Iphoster - the best ever hosting and support. 2005 - 2023
Перейти к:навигация, поиск
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


Ошибка Missing system table mysql.proxies_priv; please run mysql_upgrade to create it :

41129  9:48:10 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong 
 structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong
 structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
141129  9:48:10 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
141129  9:52:07 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
141129 10:40:27 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
141129 10:40:27 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
141129 10:40:27 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it


Решаем:

 # /etc/init.d/mysqld stop
# mysqld_safe --skip-grant-tables &
# mysql_upgrade
# /etc/init.d/mysqld stop
# /etc/init.d/mysqld start