######################
Background:
After importing the data of MySQL version 5.5 into MySQL 5.7, mysql The user table is broken
There is a problem: MySQL My watch is broken
[email protected] ((none)) > grant all privileges on *.* to 'tmp'@'localhost' identified by 'tmp' with grant option; ERROR 1805 (HY000): Column count of mysql.user is wrong. Expected 45, found 42. The table is probably corrupted Mon Dec 13 17:31:40 2021
Solution: upgrade mysql_upgrade
[[email protected]]$ ./bin/mysql_upgrade -utmp -ptmp -h10.10.10.10 -P3307 mysql_upgrade: [Warning] Using a password on the command line interface can be insecure. Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK mysql.engine_cost OK mysql.event OK mysql.func OK mysql.general_log OK mysql.gtid_executed OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.server_cost OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK The sys schema is already up to date (version 1.5.1). Found 0 sys functions, but expected 22. Re-installing the sys schema. Upgrading the sys schema. Checking databases. dba_metadata.cluster OK dba_metadata.karma OK galaxy_availability_tjwq.EMQ_AVAILABILITY_DAY OK galaxy_availability_tjwq.EMQ_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.EMQ_FUSION_AVAILABILITY_DAY OK galaxy_availability_tjwq.EMQ_FUSION_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.EMR_AVAILABILITY_DAY OK galaxy_availability_tjwq.EMR_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.EMR_FUSION_AVAILABILITY_DAY OK galaxy_availability_tjwq.EMR_FUSION_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.FDS_AVAILABILITY_DAY OK galaxy_availability_tjwq.FDS_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.FDS_BACKUP_AVAILABILITY_DAY OK galaxy_availability_tjwq.FDS_BACKUP_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.FDS_FUSION_AVAILABILITY_DAY OK galaxy_availability_tjwq.FDS_FUSION_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.FDS_FUSION_BACKUP_AVAILABILITY_DAY OK galaxy_availability_tjwq.FDS_FUSION_BACKUP_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.SDS_AVAILABILITY_DAY OK galaxy_availability_tjwq.SDS_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.SDS_FUSION_AVAILABILITY_DAY OK galaxy_availability_tjwq.SDS_FUSION_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.SDS_FUSION_S0_AVAILABILITY_DAY OK galaxy_availability_tjwq.SDS_FUSION_S0_AVAILABILITY_MINUTE OK galaxy_availability_tjwq.SDS_S0_AVAILABILITY_DAY OK galaxy_availability_tjwq.SDS_S0_AVAILABILITY_MINUTE OK spark_thriftserver.param_default OK spark_thriftserver.spark_cluster OK spark_thriftserver.spark_thriftserver_queue OK spark_thriftserver.spark_version_setting OK spark_thriftserver.trino_cluster OK sparksql.grant_history OK sparksql.history OK sparksql.kudu_table_reviews OK sparksql.sparksql_queue OK sparksql.sparksql_queue_review OK sparksql_manager.param_default OK sparksql_manager.spark_cluster OK sparksql_manager.spark_thriftserver_queue OK sparksql_manager.spark_version_setting OK sparksql_manager.trino_cluster OK sys.sys_config OK tjwq_resource_management._apps_old OK tjwq_resource_management.admin OK tjwq_resource_management.appInfo OK tjwq_resource_management.appTrackingUrl OK tjwq_resource_management.apps OK tjwq_resource_management.auth_team OK tjwq_resource_management.auth_user OK tjwq_resource_management.bills OK tjwq_resource_management.bills_v3 OK tjwq_resource_management.cluster_apps OK tjwq_resource_management.cluster_availability OK tjwq_resource_management.cluster_state OK tjwq_resource_management.clusters OK tjwq_resource_management.containers OK tjwq_resource_management.containers_summary OK tjwq_resource_management.monitor OK tjwq_resource_management.operations OK tjwq_resource_management.queue_types OK tjwq_resource_management.queues OK tjwq_resource_management.reviews OK tjwq_resource_management.schedules OK tjwq_resource_management.xiaomi_teams OK tjwq_yarn_platform.admin OK tjwq_yarn_platform.app_info OK tjwq_yarn_platform.apps OK tjwq_yarn_platform.auth_team OK tjwq_yarn_platform.auth_user OK tjwq_yarn_platform.bills OK tjwq_yarn_platform.cluster_apps OK tjwq_yarn_platform.cluster_availability OK tjwq_yarn_platform.cluster_queue_mapping OK tjwq_yarn_platform.cluster_state OK tjwq_yarn_platform.clusters OK tjwq_yarn_platform.monitor OK tjwq_yarn_platform.operations OK tjwq_yarn_platform.queue_adjustment_whitelist OK tjwq_yarn_platform.queue_priority OK tjwq_yarn_platform.queue_types OK tjwq_yarn_platform.queues OK tjwq_yarn_platform.regions OK tjwq_yarn_platform.reviews OK tjwq_yarn_platform.reviews_transfer OK tjwq_yarn_platform.schedules OK tjwq_yarn_platform.xiaomi_teams OK tjwqstaging_resource_management._apps_old OK tjwqstaging_resource_management.admin OK tjwqstaging_resource_management.appInfo OK tjwqstaging_resource_management.appTrackingUrl OK tjwqstaging_resource_management.apps OK tjwqstaging_resource_management.auth_team OK tjwqstaging_resource_management.auth_user OK tjwqstaging_resource_management.bills_v2 OK tjwqstaging_resource_management.bills_v3 OK tjwqstaging_resource_management.cluster_apps OK tjwqstaging_resource_management.cluster_availability OK tjwqstaging_resource_management.cluster_state OK tjwqstaging_resource_management.clusters OK tjwqstaging_resource_management.containers OK tjwqstaging_resource_management.containers_summary OK tjwqstaging_resource_management.monitor OK tjwqstaging_resource_management.operations OK tjwqstaging_resource_management.queue_types OK tjwqstaging_resource_management.queues OK tjwqstaging_resource_management.reviews OK tjwqstaging_resource_management.rm_app_attempt_tjwqstaging_hdd OK tjwqstaging_resource_management.rm_app_tjwqstaging_hdd OK tjwqstaging_resource_management.schedules OK tjwqstaging_resource_management.xiaomi_teams OK tjwqstaging_yarn_platform.admin OK tjwqstaging_yarn_platform.app_info OK tjwqstaging_yarn_platform.apps OK tjwqstaging_yarn_platform.auth_team OK tjwqstaging_yarn_platform.auth_user OK tjwqstaging_yarn_platform.bills OK tjwqstaging_yarn_platform.cluster_apps OK tjwqstaging_yarn_platform.cluster_availability OK tjwqstaging_yarn_platform.cluster_queue_mapping OK tjwqstaging_yarn_platform.cluster_state OK tjwqstaging_yarn_platform.clusters OK tjwqstaging_yarn_platform.monitor OK tjwqstaging_yarn_platform.operations OK tjwqstaging_yarn_platform.queue_adjustment_whitelist OK tjwqstaging_yarn_platform.queue_priority OK tjwqstaging_yarn_platform.queue_types OK tjwqstaging_yarn_platform.queues OK tjwqstaging_yarn_platform.regions OK tjwqstaging_yarn_platform.reviews OK tjwqstaging_yarn_platform.reviews_transfer OK tjwqstaging_yarn_platform.schedules OK tjwqstaging_yarn_platform.xiaomi_teams OK Upgrade process completed successfully. Checking if update is needed.