1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50564, now

最新推荐文章于 2024-01-27 21:02:36 发布

gufyang

最新推荐文章于 2024-01-27 21:02:36 发布

阅读量3.3k

点赞数 1

分类专栏：学习杂记

本文链接：https://blog.csdn.net/qq_40437747/article/details/105468093

版权

学习杂记专栏收录该内容

9 篇文章 0 订阅

订阅专栏

在使用MariaDB时，使用命令升级了MariaDB版本，在使用Navicat Premium导出数据库数据和结构的时候除了问题

 1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50564, now running 100412. Please use mysql_upgrade to fix this error

可以使用 mysql_upgrade 命令来解决这个问题：

[root@172 ~]# mysql_upgrade -uroot -p
Enter password: 
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         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.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
Upgrading from a version before MariaDB-10.1
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
db_mall
db_mall.aa                                         OK
db_mall.t_mall_admin_user                          OK
db_mall.t_mall_carousel                            OK
db_mall.t_mall_goods_category                      OK
db_mall.t_mall_goods_detail                        OK
db_mall.t_mall_goods_info                          OK
db_mall.t_mall_index_category                      OK
db_mall.t_mall_index_config                        OK
db_mall.t_mall_index_left_category                 OK
db_mall.t_mall_order                               OK
db_mall.t_mall_order_item                          OK
db_mall.t_mall_shopping_cart_item                  OK
db_mall.t_mall_user                                OK
information_schema
performance_schema
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK
[root@172 ~]#

然后再执行导出数据和结构就可以啦。