ERROR 1728 (HY000): Cannot load from mysql.procs_priv. The table is probably corrupted

今天在搞mysql binlog收集时,需要创建一个mysql用户,结果出现了:

ERROR 1728 (HY000): Cannot load from mysql.procs_priv. The table is probably corrupted异常

解决办法:

sudo mysql_upgrade -u root -p

注意后面的用户名和密码自己修改为自己的哈。

~ » sudo mysql_upgrade -u root -p
Password:
Enter password:
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.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).
Checking databases.
application_platform.application                   OK
application_platform.application_acl               OK
application_platform.application_apply_state_dict  OK
application_platform.application_developer         OK
application_platform.application_operation_log     OK
application_platform.data_state_dict               OK
application_platform.team_dict                     OK
data_platform.connection_config                    OK
data_platform.user                                 OK
qcloudagent.qcloud_server                          OK
qcloudagent.qcloud_server_agent_mapping            OK
qcustomer.accelerator_contact                      OK
qcustomer.accelerator_cross_reference              OK
qcustomer.accelerator_customer                     OK
qcustomer.accelerator_user                         OK
qcustomer.accelerator_website                      OK
qcustomer.account                                  OK
qcustomer.account_base                             OK
qcustomer.account_cross_reference                  OK
qcustomer.account_customer_relationship            OK
qcustomer.account_extension                        OK
qcustomer.address                                  OK
qcustomer.address_type_dict                        OK
qcustomer.business_line                            OK
qcustomer.business_scope_dict                      OK
qcustomer.business_system_dict                     OK
qcustomer.communication                            OK
qcustomer.communication_type_dict                  OK
qcustomer.contact                                  OK
qcustomer.contact_preference                       OK
qcustomer.contact_preference_type_dict             OK
qcustomer.contact_type_dict                        OK
qcustomer.contacts                                 OK
qcustomer.contractual_relation                     OK
qcustomer.cooperation                              OK
qcustomer.cooperation_type                         OK
qcustomer.credentials_type                         OK
qcustomer.crm_cid_qid_mapping                      OK
qcustomer.crm_customer_aptitude                    OK
qcustomer.crm_customer_center                      OK
qcustomer.crm_customer_center_log                  OK
qcustomer.cross_reference                          OK
qcustomer.custom_data                              OK
qcustomer.customer                                 OK
qcustomer.customer_clean_result                    OK
qcustomer.customer_promotion                       OK
qcustomer.customers                                OK
qcustomer.customers_companys                       OK
qcustomer.data_source                              OK
qcustomer.data_state_dict                          OK
qcustomer.designation                              OK
qcustomer.designation_type_dict                    OK
qcustomer.dm_export_task                           OK
qcustomer.dm_export_task_execution                 OK
qcustomer.gender_dict                              OK
qcustomer.hotel_account_info                       OK
qcustomer.location                                 OK
qcustomer.location_type_dict                       OK
qcustomer.merchant_handle_pool                     OK
qcustomer.merchant_handle_result                   OK
qcustomer.merchant_interface_mappings              OK
qcustomer.merchant_interface_mappings_bak          OK
qcustomer.notify_nodes                             OK
qcustomer.notify_record                            OK
qcustomer.operation_log                            OK
qcustomer.participant                              OK
qcustomer.participant_category_dict                OK
qcustomer.participant_relationship                 OK
qcustomer.participant_relationship_type_dict       OK
qcustomer.participant_state_dict                   OK
qcustomer.participant_type_dict                    OK
qcustomer.paychannel                               OK
qcustomer.product_line_dict                        OK
qcustomer.product_line_mapping                     OK
qcustomer.qadmin_org                               OK
qcustomer.qadmin_user                              OK
qcustomer.qadmin_user_group                        OK
qcustomer.qadmin_user_org                          OK
qcustomer.qmq_message                              OK
qcustomer.qualification                            OK
qcustomer.qualification_type_dict                  OK
qcustomer.scm_customer                             OK
qcustomer.scm_customer_log                         OK
qcustomer.scm_qualification                        OK
qcustomer.scm_qualification_log                    OK
qcustomer.scm_qualification_standby                OK
qcustomer.scm_store_qid_mapping                    OK
qcustomer.sequences                                OK
qcustomer.settle_config                            OK
qcustomer.sys_meta_info                            OK
qcustomer.task_instance                            OK
qcustomer.tmp_log_company                          OK
qcustomer.tmp_log_cross_ref                        OK
qcustomer.tmp_log_issue                            OK
qcustomer.tmp_log_qcustomer                        OK
qcustomer.tmp_log_qss_customer                     OK
qcustomer.website                                  OK
sys.sys_config                                     OK
temp.hsc_biz_system_customer                       OK
temp.hsc_settlement_info                           OK
temp.hsc_settlement_invoice                        OK
temp.hsc_settlement_object                         OK
temp.invoice_config                                OK
test.worker_node                                   OK
test.a                                             OK
test.application                                   OK
test.application_acl                               OK
test.b                                             OK
test.big_table                                     OK
test.certificate_info_tab                          OK
test.company_tab                                   OK
test.connection_config                             OK
test.leader_election                               OK
test.test                                          OK
test.test1                                         OK
test.test_emoij                                    OK
test.user                                          OK
Upgrade process completed successfully.
Checking if update is needed.
------------------------------------------------------------

然后重启mysql以后,在尝试创建用户,发现完美解决。

本文版权归作者所有,禁止一切形式的转载,复制等操作
赞赏

微信赞赏支付宝赞赏

One reply to ERROR 1728 (HY000): Cannot load from mysql.procs_priv. The table is probably corrupted

  1. zzzzzz内容xxxxxx

发表评论

电子邮件地址不会被公开。 必填项已用*标注