{"id":26139,"date":"2018-08-20T13:47:51","date_gmt":"2018-08-20T04:47:51","guid":{"rendered":"https:\/\/jirak.net\/wp\/?p=26139"},"modified":"2018-08-20T13:47:51","modified_gmt":"2018-08-20T04:47:51","slug":"mysqld_safe-error-log-error-set-to-however-file-dont-exists-on-compiled-mysql8-0","status":"publish","type":"post","link":"https:\/\/jirak.net\/wp\/mysqld_safe-error-log-error-set-to-however-file-dont-exists-on-compiled-mysql8-0\/","title":{"rendered":"mysqld_safe error: log-error set to however file don&#8217;t exists on compiled mysql8.0"},"content":{"rendered":"<p><strong>\ud658\uacbd<\/strong><\/p>\n<p>OS : CentOS7<br \/>\nDB : mysql-8.0.11, mysql-8.0.12 (8.0.11 \uc774\uc804\uc5d0\ub3c4 \ubb38\uc81c\uac00 \uc788\uc5c8\ub294\uc9c0\ub294 \ubaa8\ub974\uc9c0\ub9cc \uc544\ub9c8 \uc788\uc744\ub4ef)<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\ubb38\uc81c\uc810<\/strong><\/p>\n<p>mysql\u00a0 \uc2e4\ud589\uc2dc \uc544\ub798\uc640 \uac19\uc740 \uba54\uc138\uc9c0\uc640 \ud568\uaed8 \uc2e4\ud589 \ubd88\uac00<\/p>\n<blockquote><p># mysql.server start<br \/>\nStarting MySQL.2018-08-20T04:33:38.742995Z mysqld_safe error: log-error set to &#8216;\/var\/log\/mysql\/mysql_error.log&#8217;, however file don&#8217;t exists. Create writable for user &#8216;mysql&#8217;.<br \/>\nThe server quit without updating PID file (\/var\/lib\/mysql\/myserver.pid).<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p><strong>\uc6d0\uc778<\/strong><\/p>\n<p>\ubcf4\ud1b5\uc758 \uc6d0\uc778\uc774\ub77c\uba74<\/p>\n<ul>\n<li>\ub85c\uadf8\uac00 \uc313\uc5ec\uc57c \ud558\ub294 \uc704\uce58(\uc608\uc81c : \/var\/log\/mysql)\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0<\/li>\n<li>\ub85c\uadf8\uac00 \uc313\uc5ec\uc57c \ud558\ub294 \uc704\uce58\uc758 \uad8c\ud55c\uc774 mysql \uc720\uc800\uac00 &#8220;\uc4f0\uae30(write)&#8221; \uac00\ub2a5\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>\uc5ec\uc57c \ud558\uc9c0\ub9cc..<br \/>\n\ud604\uc7ac \uc2dc\uc2a4\ud15c\uc758 \uc0c1\ud669\uc740 \uc774\ub7f0 \ubb38\uc81c\uac00 \uc788\uc9c0 \uc54a\uc74c&#8230;<\/p>\n<p>my.cnf \uc124\uc815\uc911<\/p>\n<blockquote><p>log_error<\/p><\/blockquote>\n<p>\uc635\uc158\uc744 \uc190\ub300\uc9c0 \uc54a\uace0 \uadf8\ub300\ub85c \uc2e4\ud589\ud588\uc744 \uacbd\uc6b0\ub294 \ubb38\uc81c\uac00 \uc5c6\uc9c0\ub9cc<\/p>\n<blockquote><p>log_error=\/var\/log\/mysql\/mysql_error.log<\/p><\/blockquote>\n<p>\ub4f1\uc73c\ub85c \uae30\ubcf8\uac12\uc774 \uc544\ub2cc &#8220;\uc218\uc815&#8221;\uc774 \uc774\ub8e8\uc5b4\uc84c\uc744 \uacbd\uc6b0\uc5d0 \ubc1c\uc0dd \ud558\uace0 \uc788\uc74c<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\ud574\uacb0<\/strong><\/p>\n<blockquote><p>touch \/var\/log\/mysql\/mysql_error.log<br \/>\nchown mysql.mysql \/var\/log\/mysql\/mysql_error.log<\/p><\/blockquote>\n<p>\uc774\ub807\uac8c \uc0dd\uc131 &amp; \uad8c\ud55c\ubd80\uc5ec \ub97c \ud574\uc8fc\uba74 \uc815\uc0c1 \uad6c\ub3d9\uc774 \ub428&#8230;<\/p>\n<p>\ub4e3\ub294 \uc0ac\ub78c\uc740 \ub2f9\uc5f0\ud788 \ud669\ub2f9 \ud558\uaca0\uc9c0\ub9cc&#8230;<br \/>\n\uc9c0\uae08 \uc774 \uacb0\uacfc\uac00 mysql-8.0.11, mysql-8.0.12 \ub97c \uc18c\uc2a4\ucef4\ud30c\uc77c \uc124\uce58 \ud588\uc744 \ub54c \ubc1c\uc0dd \ud558\ub294 \ubb38\uc81c\uc810 \uc784&#8230;<\/p>\n<p>\ubc18\uba74 slow \ub85c\uadf8 \uc124\uc815\uc758 \uacbd\uc6b0\ub294 \uae30\ubcf8\uac12\uc774 \uc544\ub2cc &#8220;\uc218\uc815&#8221;\uc744 \ud574\ub3c4 \ubb38\uc81c \uc5c6\uc774 \uc2e4\ud589 \ub418\uace0 \uc788\uc74c<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\ud658\uacbd OS : CentOS7 DB : mysql-8.0.11, mysql-8.0.12 (8.0.11 \uc774\uc804\uc5d0\ub3c4 \ubb38\uc81c\uac00 \uc788\uc5c8\ub294\uc9c0\ub294 \ubaa8\ub974\uc9c0\ub9cc \uc544\ub9c8 \uc788\uc744\ub4ef) &nbsp; \ubb38\uc81c\uc810 mysql\u00a0 \uc2e4\ud589\uc2dc \uc544\ub798\uc640 \uac19\uc740 \uba54\uc138\uc9c0\uc640 \ud568\uaed8 \uc2e4\ud589 \ubd88\uac00 # mysql.server start Starting MySQL.2018-08-20T04:33:38.742995Z mysqld_safe error: log-error set to &#8216;\/var\/log\/mysql\/mysql_error.log&#8217;, however file don&#8217;t exists. Create writable for user &#8216;mysql&#8217;. The server quit without updating PID file (\/var\/lib\/mysql\/myserver.pid). &nbsp; \uc6d0\uc778 \ubcf4\ud1b5\uc758 \uc6d0\uc778\uc774\ub77c\uba74 \ub85c\uadf8\uac00 \uc313\uc5ec\uc57c \ud558\ub294 \uc704\uce58(\uc608\uc81c : \/var\/log\/mysql)\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \ub85c\uadf8\uac00 \uc313\uc5ec\uc57c \ud558\ub294 \uc704\uce58\uc758 \uad8c\ud55c\uc774 mysql \uc720\uc800\uac00 &#8220;\uc4f0\uae30(write)&#8221; \uac00\ub2a5\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 &nbsp; \uc5ec\uc57c \ud558\uc9c0\ub9cc.. \ud604\uc7ac \uc2dc\uc2a4\ud15c\uc758 \uc0c1\ud669\uc740 \uc774\ub7f0 \ubb38\uc81c\uac00 \uc788\uc9c0 \uc54a\uc74c&#8230; my.cnf \uc124\uc815\uc911 log_error \uc635\uc158\uc744 \uc190\ub300\uc9c0 \uc54a\uace0 \uadf8\ub300\ub85c \uc2e4\ud589\ud588\uc744 \uacbd\uc6b0\ub294 \ubb38\uc81c\uac00 \uc5c6\uc9c0\ub9cc log_error=\/var\/log\/mysql\/mysql_error.log \ub4f1\uc73c\ub85c \uae30\ubcf8\uac12\uc774 \uc544\ub2cc &#8220;\uc218\uc815&#8221;\uc774 \uc774\ub8e8\uc5b4\uc84c\uc744 \uacbd\uc6b0\uc5d0 \ubc1c\uc0dd \ud558\uace0 \uc788\uc74c &nbsp; \ud574\uacb0 touch \/var\/log\/mysql\/mysql_error.log chown mysql.mysql \/var\/log\/mysql\/mysql_error.log \uc774\ub807\uac8c \uc0dd\uc131 &amp; \uad8c\ud55c\ubd80\uc5ec \ub97c \ud574\uc8fc\uba74 \uc815\uc0c1 \uad6c\ub3d9\uc774 \ub428&#8230; \ub4e3\ub294 \uc0ac\ub78c\uc740 \ub2f9\uc5f0\ud788 \ud669\ub2f9 \ud558\uaca0\uc9c0\ub9cc&#8230; \uc9c0\uae08 \uc774 \uacb0\uacfc\uac00 mysql-8.0.11, mysql-8.0.12 \ub97c \uc18c\uc2a4\ucef4\ud30c\uc77c \uc124\uce58 \ud588\uc744 \ub54c \ubc1c\uc0dd <a class=\"mh-excerpt-more\" href=\"https:\/\/jirak.net\/wp\/mysqld_safe-error-log-error-set-to-however-file-dont-exists-on-compiled-mysql8-0\/\" title=\"mysqld_safe error: log-error set to however file don&#8217;t exists on compiled mysql8.0\">[ more&#8230; ]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":927,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[356],"tags":[1242,1297,191,1298,1089,1299,1296,498,1277],"class_list":["post-26139","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-db","tag-8-0","tag-dont","tag-error","tag-exists","tag-file","tag-howerver","tag-log_error","tag-mysql","tag-mysql8"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/26139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/comments?post=26139"}],"version-history":[{"count":1,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/26139\/revisions"}],"predecessor-version":[{"id":26140,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/posts\/26139\/revisions\/26140"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media\/927"}],"wp:attachment":[{"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/media?parent=26139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/categories?post=26139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jirak.net\/wp\/wp-json\/wp\/v2\/tags?post=26139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}