Please use mysql_upgrade to fix thiserror

最新推荐文章于 2023-10-26 14:18:40 发布

原创最新推荐文章于 2023-10-26 14:18:40 发布 · 6.4k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #mysql_upgrade

数据库专栏收录该内容

8 篇文章

订阅专栏

本文解决了MySQL更新版本后出现的权限错误问题。通过使用mysql_upgrade命令，成功更新了mysql库，并修复了新旧版本不匹配导致的权限问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql在创建用户或者设置权限，操作mysql库时

出现以下错误：

Column count of mysql.useris wrong. Expected 43, found 42. Created with MySQL 50552, nowrunning 50636. Please use mysql_upgrade to fix thiserror.

出现问题的原因：更新mysql版本后出现了新旧版本不匹配的问题！

解决方法：使用命令：mysql_upgrade -u root -p 更新mysql库

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 beinsecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can beinsecure.
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 beinsecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can beinsecure.
Running 'mysqlcheck with default connection arguments
Warning: Using a password on the command line interface can beinsecure.
test.stu                                          OK
OK
更新成功！！！！！