Home > Database > Mysql Tutorial > body text

1548-Cannot load from mysql.proc.The table is probably corru_MySQL

WBOY
Release: 2016-06-01 13:34:11
Original
1029 people have browsed it

bitsCN.com

1548-Cannot load from mysql.proc.The table is probably corrupted解决

 

   同事发邮件说navicat查询数据库,报错:1548-Cannot load from mysql.proc. The table is probably corrupted

 

      同事查了查资料,问我数据库是否升级,刚接手不久,不知道在我之前是否升过级,那就mysql_upgrade  -uroot  -p 修复升级

 

[root@db2343 ~]# mysql_upgrade -uroot 

Looking for 'mysql' as: mysql

Looking for 'mysqlcheck' as: mysqlcheck

Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/my/base/mysql.sock' 

Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/my/base/mysql.sock' 

    。。。。。。。。。。。。。。。。。。。

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.user                                         OK

test.test                                          OK

Running 'mysql_fix_privilege_tables'...

OK

 

当出现许多ok之后,基本上就修复完毕。告知同事,查询ok。
 

bitsCN.com
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template