Tag Archives: ERROR 1805 (HY000): Column count of mysql.user is wrong. Expected 45

[Solved] ERROR 1805 (HY000): Column count of mysql.user is wrong. Expected 45, found 42. The table is probably corrupted

######################

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.