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

Source: Internet
Author: User

1548-Cannot load from mysql. proc. the table is probably updated upted solves The problem when a colleague sends an email saying navicat queries The database and reports The error 1548-Cannot load from mysql. proc. the table is probably successfully upted colleague checked The information and asked me if The database was upgraded. I just took over and did not know if I had been upgraded before, fix and upgrade mysql_upgrade-uroot-p [root @ db2343 ~] # Mysql_upgrade-uroot Looking for 'mysql' as: mysqlLooking for 'mysqlcheck' as: mysqlcheckRunning 'mysqlcheck' with connection arguments: '-- port = 3306 ''-- socket =/my/base/mysql. sock 'running' mysqlcheck' with connection arguments: '-- port = 100'' -- socket =/my/base/mysql. sock '................... Mysql. columns_priv OKmysql. db OKmysql. event OKmysql. func OKmysql. general_log OKmysql. help_category OKmysql. help_keyword OKmysql. help_relation OKmysql. help_topic OKmysql. host OKmysql. ndb_binlog_index OKmysql. plugin OKmysql. proc OKmysql. procs_priv OKmysql. proxies_priv OK .................... Mysql. user OKtest. test OKRunning 'mysql _ fix_privilege_tables '... OK after many OK statements are displayed, the repair is basically completed. Inform colleagues about the query.
 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.