{"id":5290,"date":"2021-11-05T14:42:39","date_gmt":"2021-11-05T06:42:39","guid":{"rendered":"https:\/\/www.xttblog.com\/?p=5290"},"modified":"2021-11-05T14:42:39","modified_gmt":"2021-11-05T06:42:39","slug":"%e6%89%8b%e6%8a%8a%e6%89%8b%e6%95%99%e4%bd%a0%e8%a7%a3%e5%86%b3mysql%e6%9c%8d%e5%8a%a1%e5%90%af%e5%8a%a8%e5%a4%b1%e8%b4%a5%e6%8e%92%e6%9f%a5%e5%b9%b6%e4%bf%ae%e5%a4%8d%e6%81%a2%e5%a4%8d%e5%90%af","status":"publish","type":"post","link":"https:\/\/www.xttblog.com\/?p=5290","title":{"rendered":"\u624b\u628a\u624b\u6559\u4f60\u89e3\u51b3MySQL\u670d\u52a1\u542f\u52a8\u5931\u8d25\u6392\u67e5\u5e76\u4fee\u590d\u6062\u590d\u542f\u52a8\u95ee\u9898"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u624b\u628a\u624b\u6559\u4f60\u89e3\u51b3MySQL\u670d\u52a1\u542f\u52a8\u5931\u8d25\u6392\u67e5\u5e76\u4fee\u590d\u6062\u590d\u542f\u52a8\u95ee\u9898<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u6b21\u5e2e\u4e00\u4e2a\u7f51\u53cb\u8fdc\u7a0b\u89e3\u51b3\u4e86\u4e00\u4e2a\u95ee\u9898\uff0c\u76f4\u63a5\u6253\u8d4f\u4e86\u6211\uff0c\u4eca\u5929\u53c8\u4e00\u4e2a\u7f51\u53cb\u6253\u8d4f\u4e86\u6211\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e8b\u4ef6\u8d77\u56e0\u662f\u8fd9\u6837\u7684\uff0c\u7f51\u53cb\u5728\u6267\u884c\u4e00\u6761 SQL \u65f6\uff0c\u63d0\u793a\u9519\u8bef\u3002\u7f51\u53cb\u641c\u7d22\u5f97\u51fa\u7b54\u6848\uff0c\u9700\u8981\u8bbe\u7f6e sql_mode\uff0c\u5979\u767e\u5ea6\u4e00\u756a\uff0c\u7136\u540e\u8fdb\u884c\u4e86\u4fee\u6539\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/xmt1139057136\/xttblog\/2021\/11\/bug-1.png\" alt=\"\" \/><figcaption>ONLY_FULL_GROUP_BY<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u91cd\u542f\u670d\u52a1\u540e\uff0c\u53d1\u73b0 MySQL \u670d\u52a1\u65e0\u6cd5\u542f\u52a8\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6211\u95ee\u7f51\u53cb\u9047\u5230\u4e86\u4ec0\u4e48\u9519\u8bef\uff0c\u5bf9\u65b9\u7ed9\u6211\u53d1\u6765\u4e86\u4e00\u4e2a\u622a\u56fe\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/xmt1139057136\/xttblog\/2021\/11\/bug-2.png\" alt=\"\" \/><figcaption>mysql \u542f\u52a8\u5931\u8d25\uff0c\u53d1\u751f\u9519\u8bef<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u7531\u4e8e\u622a\u56fe\u592a\u5c0f\uff0c\u770b\u4e0d\u5168\u5185\u5bb9\uff0c\u56e0\u6b64\u8fdb\u884c\u4e86\u8fdc\u7a0b\u624b\u628a\u624b\u6559\u7a0b\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6211\u9996\u5148\u6267\u884c mysql \u7684\u542f\u52a8\u547d\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>service mysql start<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u7136\u540e\u83b7\u5f97\u4e86\u542f\u52a8\u62a5\u9519\u4fe1\u606f\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Starting mysqld (via systemctl):  Job for mysqld.service failed because the control process exited with error code. See \"systemctl status mysqld.service\" and \"journalctl -xe\" for details. [FAILED]<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd9\u6bb5\u5185\u5bb9\u7ffb\u8bd1\u8fc7\u6765\uff0c\u5c31\u662f\u63d0\u793a\u6211\uff1a\u201c\u5206\u522b\u4f7f\u7528systemctl status mysqld.service\u548cjournalctl -xe\u67e5\u770b\u670d\u52a1\u542f\u52a8\u5931\u8d25\u7684\u539f\u56e0\u201d\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e8e\u662f\uff0c\u6211\u5148\u6267\u884c\u4e86 systemctl status mysqld.service \u547d\u4ee4\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl status mysqld.service<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u73b0\u4e86\u4e0b\u9762\u7684\u65e5\u5fd7\u5185\u5bb9\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>?.mysqld.service - SYSV: MySQL database server.\n   Loaded: loaded (\/etc\/rc.d\/init.d\/mysqld)\n   Active: failed (Result: exit-code) since Wed 2016-01-20 18:26:57 CST; 40s ago\n     Docs: man:systemd-sysv-generator(8)\n  Process: 2979 ExecStart=\/etc\/rc.d\/init.d\/mysqld start (code=exited, status=1\/FAILURE)\n\n systemd[1]: Starting SYSV: MySQL database server....\n xttblog mysqld[2979]: MySQL Daemon failed to start.\n xttblog mysqld[2979]: Starting mysqld:  [FAILED]\n xttblog systemd[1]: mysqld.service: control process exited, code=exited status=1\n xttblog systemd[1]: Failed to start SYSV: MySQL database server..\n xttblog systemd[1]: Unit mysqld.service entered failed state.\n xttblog systemd[1]: mysqld.service failed.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u9762\u8fd9\u6bb5\u9519\u8bef\u65e5\u5fd7\uff0c\u6211\u6ca1\u770b\u51fa\u5177\u4f53\u7684\u9519\u8bef\u539f\u56e0\u3002\u4e8e\u662f\uff0c\u5c31\u53c8\u6267\u884c\u4e86 journalctl -xe \u547d\u4ee4\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Unit session-2.scope has begun starting up.\nxttblog sshd[2916]: pam_unix(sshd:session): session opened for user spark by (uid=0)\nxttblog su[2944]: (to root) spark on pts\/1\nxttblog su[2944]: pam_unix(su-l:session): session opened for user root by spark(uid=1000)\nxttblog polkitd[909]: Registered Authentication Agent for unix-process:2974:117137 (system bus name :1.25\nxttblog systemd[1]: Starting SYSV: MySQL database server....\n-- Subject: Unit mysqld.service has begun start-up\n-- Defined-By: systemd\n-- Support: http:\/\/lists.freedesktop.org\/mailman\/listinfo\/systemd-devel\n-- \n-- Unit mysqld.service has begun starting up.\nxttblog mysqld[2979]: MySQL Daemon failed to start.\nxttblog mysqld[2979]: Starting mysqld:  [FAILED]\nxttblog systemd[1]: mysqld.service: control process exited, code=exited status=1\nxttblog systemd[1]: Failed to start SYSV: MySQL database server..\n[ERROR] Could not open file '\/var\/log\/mysql\/error.log' for error logging: No such file or directory\n-- Subject: Unit mysqld.service has failed\n-- Defined-By: systemd\n-- Support: http:\/\/lists.freedesktop.org\/mailman\/listinfo\/systemd-devel\n-- \n-- Unit mysqld.service has failed.\n-- \n-- The result is failed.\nxttblog systemd[1]: Unit mysqld.service entered failed state.\nxttblog systemd[1]: mysqld.service failed.\nxttblog polkitd[909]: Unregistered Authentication Agent for unix-process:2974:117137 (system bus name :1.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u9762\u7684\u65e5\u5fd7\u4e2d\uff0c\u6709\u4e00\u6bb5\u5f88\u660e\u663e\u7684\u5185\u5bb9\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u201c[ERROR] Could not open file '\/var\/log\/mysql\/error.log' for error logging: No such file or directory\u201d<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6293\u4f4f\u91cd\u70b9\u4fe1\u606f\uff0c\u6211\u5728 \/var\/log\/mysql\/error.log \u76ee\u5f55\u4e0b\uff0c\u65b0\u5efa\u4e86 error.log \u6587\u4ef6\uff0c\u5e76\u7ed9\u4e0a 755 \u6743\u9650\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7136\u540e\uff0c\u6211\u518d\u6b21\u542f\u52a8 mysql \u670d\u52a1\uff0cservice mysql start \u6210\u529f\u542f\u52a8\uff01<\/p>\n<!-- <audio autoplay=\"autoplay\" height=\"100\" width=\"100\" hidden=\"true\"><source src=\"https:\/\/c.coka.la\/orAvPR.mp3\" type=\"audio\/mp3\"\/><\/audio><img decoding=\"async\" src=\"https:\/\/images.weserv.nl\/?url=https:\/\/ws3.sinaimg.cn\/large\/8fa5dcfcgy1g4em3rzar5j20ib089ae0.jpg\" alt=\"\u4e1a\u4f59\u8349\u516c\u4f17\u53f7\"\/> --><p><!-- <img decoding=\"async\" src=\"https:\/\/raw.githubusercontent.com\/xmt1139057136\/xttblog\/master\/8fa5dcfcgy1g4em3rzar5j20ib089ae0.jpg\" alt=\"\u4e1a\u4f59\u8349\u516c\u4f17\u53f7\"\/>--><img decoding=\"async\" src=\"https:\/\/saas.51autoparts.cn\/api\/admin\/sys-file\/oss\/file?fileName=84db51f8561e448f9a4fda2eff0811f9.jpg\" alt=\"\u4e1a\u4f59\u8349\u516c\u4f17\u53f7\"\/><\/p><p>\u6700\u540e\uff0c\u6b22\u8fce\u5173\u6ce8\u6211\u7684\u4e2a\u4eba\u5fae\u4fe1\u516c\u4f17\u53f7\uff1a\u4e1a\u4f59\u8349\uff08yyucao\uff09\uff01<b>\u53ef\u52a0\u4f5c\u8005\u5fae\u4fe1\u53f7\uff1a<font color=\"red\">xttblog2<\/font>\u3002\u5907\u6ce8\uff1a\u201c1\u201d\uff0c\u6dfb\u52a0\u535a\u4e3b\u5fae\u4fe1\u62c9\u4f60\u8fdb\u5fae\u4fe1\u7fa4\u3002\u5907\u6ce8\u9519\u8bef\u4e0d\u4f1a\u540c\u610f\u597d\u53cb\u7533\u8bf7\u3002<\/b>\u518d\u6b21\u611f\u8c22\u60a8\u7684\u5173\u6ce8\uff01\u540e\u7eed\u6709\u7cbe\u5f69\u5185\u5bb9\u4f1a\u7b2c\u4e00\u65f6\u95f4\u53d1\u7ed9\u60a8\uff01\u539f\u521b\u6587\u7ae0\u6295\u7a3f\u8bf7\u53d1\u9001\u81f3532009913@qq.com\u90ae\u7bb1\u3002\u5546\u52a1\u5408\u4f5c\u4e5f\u53ef\u6dfb\u52a0\u4f5c\u8005\u5fae\u4fe1\u8fdb\u884c\u8054\u7cfb\uff01<\/p><p>\u672c\u6587\u539f\u6587\u51fa\u5904\uff1a<a href=\"https:\/\/www.xttblog.com\">\u4e1a\u4f59\u8349<\/a>\uff1a &raquo; <a href=\"https:\/\/www.xttblog.com\/?p=5290\">\u624b\u628a\u624b\u6559\u4f60\u89e3\u51b3MySQL\u670d\u52a1\u542f\u52a8\u5931\u8d25\u6392\u67e5\u5e76\u4fee\u590d\u6062\u590d\u542f\u52a8\u95ee\u9898<\/a><\/p><!-- <div class=\"bd-reward-stl\"><button id=\"bdRewardBtn\"><span><\/span><\/button><\/div> -->","protected":false},"excerpt":{"rendered":"<p>\u624b\u628a\u624b\u6559\u4f60\u89e3\u51b3MySQL\u670d\u52a1\u542f\u52a8\u5931\u8d25\u6392\u67e5\u5e76\u4fee\u590d\u6062\u590d\u542f\u52a8\u95ee\u9898 \u4e0a\u6b21\u5e2e\u4e00\u4e2a\u7f51\u53cb\u8fdc\u7a0b\u89e3\u51b3\u4e86\u4e00\u4e2a\u95ee\u9898\uff0c\u76f4\u63a5\u6253\u8d4f\u4e86\u6211\uff0c\u4eca [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[83,392,391,393,681],"class_list":["post-5290","post","type-post","status-publish","format-standard","hentry","category-sql","tag-mysql","tag-681"],"_links":{"self":[{"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/posts\/5290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5290"}],"version-history":[{"count":1,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/posts\/5290\/revisions"}],"predecessor-version":[{"id":5291,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/posts\/5290\/revisions\/5291"}],"wp:attachment":[{"href":"https:\/\/www.xttblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}