Warning: include(/home/blog66rr/public_html/wp-content/plugins/hyper-cache/cache.php): failed to open stream: No such file or directory in /home/blog66rr/public_html/wp-content/advanced-cache.php on line 24

Warning: include(/home/blog66rr/public_html/wp-content/plugins/hyper-cache/cache.php): failed to open stream: No such file or directory in /home/blog66rr/public_html/wp-content/advanced-cache.php on line 24

Warning: include(): Failed opening '/home/blog66rr/public_html/wp-content/plugins/hyper-cache/cache.php' for inclusion (include_path='.:/opt/cpanel/ea-php70/root/usr/share/pear') in /home/blog66rr/public_html/wp-content/advanced-cache.php on line 24

Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723

Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723

Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723

Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723

Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723

Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723

Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723

Warning: Cannot modify header information - headers already sent by (output started at /home/blog66rr/public_html/wp-content/advanced-cache.php:24) in /home/blog66rr/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1723
{"id":4247,"date":"2017-01-17T16:29:56","date_gmt":"2017-01-17T08:29:56","guid":{"rendered":"http:\/\/blog.unethost.com\/?p=4247"},"modified":"2017-01-17T16:29:56","modified_gmt":"2017-01-17T08:29:56","slug":"how_to_fix_mysql_issue_matching-row_when_transfer_web","status":"publish","type":"post","link":"https:\/\/blog.unethost.com\/how_to_fix_mysql_issue_matching-row_when_transfer_web\/","title":{"rendered":"\u5982\u4f55\u89e3\u6c7awhm\u642c\u7ad9\u51fa\u73fe\u7684 mysql error message:Can’t find any matching row in the user table"},"content":{"rendered":"

\u6700\u8fd1\u6211\u5011\u5728\u4f7f\u7528whm<\/a>\u81ea\u52d5\u642c\u6a5f\u6642\uff0c\u767c\u73fe\u8cc7\u6599\u5eab\u6703\u6709\u7570\u5e38\u7684\u72c0\u6cc1\uff0c<\/strong>
\n\u7cfb\u7d71\u6703\u63d0\u793a\u51fa:\u00a0Can’t find any matching row in the user table<\/span>\uff0c<\/strong>
\n\u7d93\u6211\u5011\u67e5\u8a62\u5f8c\uff0c\u767c\u73fe\u539f\u4f86\u8ddf my.cnf\u7684\u8a2d\u5b9a\u6a94\u6709\u95dc\u3002<\/strong><\/p>\n

<\/p>\n

\u9664\u932f\u53ca\u89e3\u6c7a\u7684\u65b9\u5f0f:
\n<\/strong><\/span>1.\u4eca\u5929\u9019\u500b\u932f\u8aa4\u8a0a\u606f\uff0c\u5982\u679c\u7528google\u53bb\u641c\u7d22\uff0c\u6703\u767c\u73fe\u5f88\u591a\u6587\u7ae0\u7684\u901a\u4fd7\u89e3\u6cd5\uff0c
\n\u90fd\u6703\u63d0\u793a\u662f\u95dc\u65bc mysql \u5e95\u4e0b\u8981\u57f7\u884c Flush privileges; \u53bb\u8655\u7406\u3002<\/p>\n

2.\u4f46\u662f\u4eca\u5929\u7d66\u5927\u5bb6\u4e00\u500b\u6982\u5ff5\uff0c\u662f\u53ea\u8981\u5361\u5230 whm<\/a>\/cpanel<\/a> \u63a7\u5236\u53f0\u7684\u8a71\uff0c
\n\u5176\u512a\u5148\u6b0a\u5c31\u4e0d\u662f\u5728mysql\u8eab\u4e0a\uff0c\u5c31\u8981\u53bb\u8ffd\u67e5\u95dc\u65bcwhm\u7684\u89e3\u6cd5\uff1b<\/p>\n

3.\u7d93\u6211\u5011\u7ffb\u4e86\u4e00\u4e9b\u6587\u7ae0\u5f8c\u767c\u73fe\uff0c\u539f\u4f86\u662f my.cnf \u7684\u4e00\u6bb5\u8a9e\u6cd5\u5c0e\u81f4\u7684\u554f\u984c\uff0c
\n\u5176\u8a9e\u6cd5\u662f:skip-name-resolve\uff0c\u8981\u5c07\u4ed6\u5f9e my.cnf \u62ff\u6389\u3002<\/p>\n

4.\u9019\u8a9e\u6cd5\u672c\u4f86\u662f\u70ba\u4e86\u52a0\u901fmysql\u7684\u8b80\u53d6\u6240\u8a2d\u5b9a\uff0c\u4f46\u6709\u6642\u820a\u7684\u8a9e\u6cd5\uff0c
\n\u5728\u65b0\u7248\u7684mysql\u4e0a\u9762\uff0c\u53cd\u800c\u6703\u662fbugs\u3002<\/p>\n

5.\u79fb\u9664\u8a72\u8a9e\u6cd5\uff0c\u4e26restart mysql\u5f8c\uff0c\u5c31\u53ef\u4ee5\u9806\u5229\u642c\u79fb\u4e86\u3002<\/p>\n

\u6700\u5f8c\u9700\u6ce8\u610f\u7684\u5730\u65b9:<\/span><\/strong>
\n6. \u53e6\u5916\u4e4b\u524d\u642c\u904e\u7684\u5e33\u865f\uff0c\u9084\u767c\u73fe\u4e00\u500bbugs\uff0c\u7576\u524d\u9762\u642c\u5931\u6557\u4f46\u5df2\u7d93\u5f9e
whm<\/a>\u780d\u6389\u7684\u5e33\u865f\uff0c
\n\u5176db\u8cc7\u6599\u9084\u4fdd\u7559\u5728 \/var\/lib\/mysql\u88e1\uff0c\u5c0e\u81f4\u642c\u7ad9\u5f8c\uff0cdb name\u6703\u88ab\u7cfb\u7d71\u6539\u6389\uff0c
\n\u6240\u4ee5\u9084\u8981\u624b\u52d5\u9032 linux shell\u53bb\u6e05\u9664\u4e00\u6b21\uff0c\u9019\u6a23\u91cd\u65b0\u642c\u7ad9\u5f8c\uff0c\u624d\u4e0d\u6703\u51fa\u73fe\u5176\u4ed6\u554f\u984c\u3002<\/p>\n

 <\/p>\n

(\u672c\u7bc7\u6559\u5b78\u7531unethost.com\u5ba2\u670d\u64b0\u5beb<\/a>)<\/strong><\/span><\/p>\n

\u5ef6\u4f38\u95b1\u8b80:\u5982\u4f55\u5099\u4efdCpanel\u5f8c\u53f0\u5b89\u88dd\u7684\u5957\u88dd\u7a0b\u5f0f?<\/a><\/strong><\/p>\n

\u5b89\u88dd\u4e0a\u8ff0\u7684\u8edf\u9ad4\uff0c\u6211\u5011\u63d0\u4f9b\u865b\u64ec\u4e3b\u6a5f\u8a66\u7528\uff0c\u4e03\u5929\u6eff\u610f\u4fdd\u8b49\uff0c<\/span><\/strong>
\n\u529f\u80fd\u5b8c\u6574\u4f7f\u7528\u4e0d\u53d7\u9650\u5236\uff0c\u6b61\u8fce
\u9ede\u6211<\/a>\u7533\u8acb\u3002<\/span><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

\u6700\u8fd1\u6211\u5011\u5728\u4f7f\u7528whm\u81ea\u52d5\u642c\u6a5f\u6642\uff0c\u767c\u73fe\u8cc7\u6599\u5eab\u6703\u6709\u7570\u5e38\u7684\u72c0\u6cc1\uff0c \u7cfb\u7d71\u6703\u63d0\u793a\u51fa:\u00a0Can’t find … \u95b1\u8b80\u5168\u6587 \u5982\u4f55\u89e3\u6c7awhm\u642c\u7ad9\u51fa\u73fe\u7684 mysql error message:Can’t find any matching row in the user table<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":4250,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[15,151],"tags":[1201,1200,1202],"_links":{"self":[{"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/posts\/4247"}],"collection":[{"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/comments?post=4247"}],"version-history":[{"count":2,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/posts\/4247\/revisions"}],"predecessor-version":[{"id":4251,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/posts\/4247\/revisions\/4251"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/media\/4250"}],"wp:attachment":[{"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/media?parent=4247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/categories?post=4247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.unethost.com\/wp-json\/wp\/v2\/tags?post=4247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}