{"id":5490,"date":"2021-01-04T11:30:43","date_gmt":"2021-01-04T11:30:43","guid":{"rendered":"https:\/\/blog.gwlin.com\/?p=5490"},"modified":"2023-03-30T13:52:17","modified_gmt":"2023-03-30T13:52:17","slug":"\u89e3\u51b3Column count of mysql.user is wrong. The table is probably corrupted\u95ee\u9898","status":"publish","type":"post","link":"https:\/\/www.gwlin.com\/blog\/posts\/5490","title":{"rendered":"\u89e3\u51b3Column count of mysql.user is wrong. The table is probably corrupted\u95ee\u9898"},"content":{"rendered":"<p>\u4e4b\u524d\u6570\u636e\u5e93\u4ecemariadb\u8f6c\u5230mysql\uff0c\u53d1\u73b0\u6dfb\u52a0\u7528\u6237\u7684\u65f6\u5019\u4f1a\u62a5\u9519\uff1aColumn count of mysql.user is wrong. The table is probably corrupted.\u539f\u56e0\u662fmariadb\u7684\u7528\u6237\u8868\u548cmysql\u7684\u7528\u6237\u8868\u7ed3\u6784\u662f\u4e0d\u4e00\u6837\u7684\uff0cmariadb\u591a\u4e86\u4e09\u4e2a\u5b57\u6bb5\u3002\u628a\u4ed6\u4eec\u53bb\u6389\u4e4b\u540emysql\u5c31\u4f1a\u6062\u590d\u6b63\u5e38\u3002\u4e0b\u9762\u662f\u4ee3\u7801\uff0c\u8fd0\u884c\u4e4b\u524d\u4fdd\u5b58\u5907\u4efd\uff0c\u5e76\u68c0\u67e5\u4e00\u4e0b\u662f\u5426\u771f\u7684\u662f\u591a\u4e86\u8fd9\u51e0\u4e2a\u5b57\u6bb5\u3002<\/p>\n<pre><code class=\"prettyprint\" >alter table user drop column is_role;\nalter table user drop column default_role;\nalter table user drop column max_statement_time;\nalter table user modify max_user_connections int(11) unsigned NOT NULL DEFAULT &#039;0&#039;;\nflush privileges;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e4b\u524d\u6570\u636e\u5e93\u4ecemariadb\u8f6c\u5230mysql\uff0c\u53d1\u73b0\u6dfb\u52a0\u7528\u6237\u7684\u65f6\u5019\u4f1a\u62a5\u9519\uff1aColumn count of mysql [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[179],"tags":[],"class_list":["post-5490","post","type-post","status-publish","format-standard","hentry","category-notes"],"_links":{"self":[{"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/posts\/5490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/comments?post=5490"}],"version-history":[{"count":0,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/posts\/5490\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/media?parent=5490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/categories?post=5490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/tags?post=5490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}