Shulou(Shulou.com)06/03 Report--

This article mainly tells you how to delete user errors in mysql. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on how to delete user errors in mysql can bring you some practical help.

1. Error prompt

ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50560, now running 50645. Please use mysql_upgrade to fix this error.

It means that the database has been upgraded before, but the mysql library in the database does not have the permission confusion caused by the upgrade.

2. Solution

Upgrade database using commands

Mysql_upgrade-uroot-p 'password'

Enter password:

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

Running 'mysqlcheck with default connection arguments

Warning: Using a password on the command line interface can be insecure.

Running 'mysqlcheck with default connection arguments

Warning: Using a password on the command line interface can be insecure.

Mysql.columns_priv OK

Mysql.db OK

Mysql.event OK

Mysql.func OK

Mysql.general_log OK

Mysql.help_category OK

Mysql.help_keyword OK

Mysql.help_relation OK

Mysql.help_topic OK

Mysql.host OK

Mysql.ndb_binlog_index OK

Mysql.plugin OK

Mysql.proc OK

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 OK

Mysql.time_zone_transition OK

Mysql.time_zone_transition_type OK

Mysql.user OK

Running 'mysql_fix_privilege_tables'...

Warning: Using a password on the command line interface can be insecure.

Running 'mysqlcheck with default connection arguments

Warning: Using a password on the command line interface can be insecure.

Running 'mysqlcheck with default connection arguments

Warning: Using a password on the command line interface can be insecure.

Mysqlcheck: Got error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.2_b_cloud_provider FOR UPGRADE' at line 1 when executing' CHECK TABLE... FOR UPGRADE'

Cb-fetch-data-pre.cron_task OK

Cb-fetch-data-pre.cron_task_result OK

Cb-fetch-data-pre.xxl_job_qrtz_blob_triggers OK

Cb-fetch-data-pre.xxl_job_qrtz_calendars OK

Cb-fetch-data-pre.xxl_job_qrtz_cron_triggers OK

Cb-fetch-data-pre.xxl_job_qrtz_fired_triggers OK

Cb-fetch-data-pre.xxl_job_qrtz_job_details OK

Cb-fetch-data-pre.xxl_job_qrtz_locks OK

Cb-fetch-data-pre.xxl_job_qrtz_paused_trigger_grps OK

Cb-fetch-data-pre.xxl_job_qrtz_scheduler_state OK

Cb-fetch-data-pre.xxl_job_qrtz_simple_triggers OK

Cb-fetch-data-pre.xxl_job_qrtz_simprop_triggers OK

Cb-fetch-data-pre.xxl_job_qrtz_trigger_group OK

Cb-fetch-data-pre.xxl_job_qrtz_trigger_info OK

Cb-fetch-data-pre.xxl_job_qrtz_trigger_log OK

Cb-fetch-data-pre.xxl_job_qrtz_trigger_logglue OK

Cb-fetch-data-pre.xxl_job_qrtz_trigger_registry OK

Cb-fetch-data-pre.xxl_job_qrtz_triggers OK

Cloudbest-index-point-pre.b_cloud_provider OK

Cloudbest-index-point-pre.cron_task OK

Cloudbest-index-point-pre.cron_task_result_2019_09 OK

Cloudbest-index-point-pre.cron_task_result_2019_10 OK

Cloudbest-index-point-pre.cron_task_result_2019_11 OK

Cloudbest-index-point-pre.cron_task_result_2019_12 OK

Cloudbest-index-point-pre.cron_task_result_2020_01 OK

Cloudbest-index-point-pre.cron_task_result_2020_02 OK

Cloudbest-index-point-pre.cron_task_result_2020_03 OK

Cloudbest-index-point-pre.cron_task_result_2020_04 OK

Cloudbest-index-point-pre.cron_task_result_2020_05 OK

Cloudbest-index-point-pre.cron_task_result_2020_06 OK

Cloudbest-index-point-pre.cron_task_result_2020_07 OK

Cloudbest-index-point-pre.cron_task_result_2020_08 OK

Cloudbest-index-point-pre.cron_task_result_2020_09 OK

Cloudbest-index-point-pre.i_index_rank OK

Cloudbest-index-point-pre.i_instances OK

Cloudbest-index-point-pre.i_model OK

Cloudbest-index-point-pre.i_model_price OK

Cloudbest-index-point-pre.i_performance_reportes OK

Cloudbest-index-point-pre.i_region OK

Cloudbest-index-point-pre.statistic_index OK

Cloudbest-market.ddos_accounts OK

Cloudbest-market.ddos_custom OK

Cloudbest-market.ddos_shield_info OK

Cloudbest-market.ddos_task_queue OK

Cloudbest-order.cb_order OK

FATAL ERROR: Error during call to mysql_check for upgrading the tables names on all db (s) except mysql

The last error is because other database tables cannot be changed, and this does not affect it. This is to solve the above mistake. Permissions can be used normally.

Mysql delete user errors how to first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.