MySQL执行脚本发生如下错误时:
ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50045, now running 50514. Please use mysql_upgrade to fix this error. Database changed
ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50045, now running 50514. Please use mysql_upgrade to fix this error.
ERROR:
No query specified
ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start
ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler were found damaged at server start
采用如下方法即可:
[root@HiTV ~]# mysql_upgrade -h 192.168.0.21 -u root -p111 Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' '--host=192.168.0.21' Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' '--host=192.168.0.21' hitv.t_app_ad OK hitv.t_app_ad_slot OK hitv.t_app_application OK hitv.t_app_asset OK hitv.t_app_asset_member OK hitv.t_app_authorize OK hitv.t_app_bookmark OK hitv.t_app_bulletin OK hitv.t_app_business_guide OK hitv.t_app_cache OK hitv.t_app_catalog OK hitv.t_app_catalog_asset OK hitv.t_app_catalog_template OK hitv.t_app_content OK hitv.t_app_dictionary OK hitv.t_app_favorite OK hitv.t_app_group OK hitv.t_app_group_role OK hitv.t_app_product OK hitv.t_app_product_member OK hitv.t_app_ranking OK hitv.t_app_recommend OK hitv.t_app_record OK hitv.t_app_role OK hitv.t_app_role_catalog OK hitv.t_app_save OK hitv.t_app_session OK hitv.t_app_template OK hitv.t_app_user OK hitv.t_app_user_group OK hitv.t_app_user_order OK hitv.t_app_user_role OK hitv.t_hitv_log OK hitv.t_lbo_channel OK hitv.t_lbo_enduser_log OK hitv.t_lbo_program OK hitv.t_lbo_program_arrange OK hitv.t_lbo_schedule OK hitv.t_record_log OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log OK mysql.help_category error : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it! mysql.help_keyword error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it! mysql.help_relation OK mysql.help_topic error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" or dump/reload to fix it! mysql.host OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc error : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it! mysql.procs_priv OK mysql.proxies_priv OK mysql.servers OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name error : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" or dump/reload to fix it! mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Repairing tables mysql.help_category OK mysql.help_keyword OK mysql.help_topic OK mysql.proc OK mysql.time_zone_name OK Running 'mysql_fix_privilege_tables'... WARNING: NULL values of the 'character_set_client' column ('mysql.proc' table) have been updated with a default value (utf8). Please verify if necessary. WARNING: NULL values of the 'collation_connection' column ('mysql.proc' table) have been updated with a default value (utf8_general_ci). Please verify if necessary. WARNING: NULL values of the 'db_collation' column ('mysql.proc' table) have been updated with default values. Please verify if necessary. OK [root@HiTV ~]#