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


Материал из Wiki - Iphoster - 'the best ever support'

Перейти к: навигация, поиск

Доступная цена


Ошибка 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
Индекс цитирования