時々起動に失敗する我が家のMAMP PROのMySQL。
停止して開始にしたら起動したりするのでそのまま使ってたけど、気持ち悪いのでログを見ることにしました。
出てる出てる。
[ERROR]の文字がたくさん…
please run mysql_upgrade to create it
らしいのでアップグレードすることに。
MAMP PROはエライ。
ちゃーんとメニューを用意してくれていました。
ツール -> MYSQL データベースをアップグレード
データーベースをバックアップしましょうねの警告つきです。
DBをさわる時は手を抜かずにダンプしておきましょう。
[ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure [ERROR] Native table 'performance_schema'.'threads' has the wrong structure [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure |