{"id":331,"date":"2016-11-14T10:24:52","date_gmt":"2016-11-14T01:24:52","guid":{"rendered":"https:\/\/eng.miteel.net\/?page_id=331"},"modified":"2017-04-28T11:04:59","modified_gmt":"2017-04-28T02:04:59","slug":"mysql%e3%81%8c%e7%aa%81%e7%84%b6%e8%b5%b7%e5%8b%95%e3%81%a7%e3%81%8d%e3%81%aa%e3%81%8f%e3%81%aa%e3%81%a3%e3%81%9f","status":"publish","type":"page","link":"https:\/\/eng.miteel.net\/?page_id=331","title":{"rendered":"mysql\u304c\u7a81\u7136\u8d77\u52d5\u3067\u304d\u306a\u304f\u306a\u3063\u305f"},"content":{"rendered":"

mysql\u304c\u7a81\u7136\u8d77\u52d5\u3067\u304d\u306a\u304f\u306a\u3063\u305f\u5834\u5408\u306e\u5bfe\u51e6\u6cd5<\/p>\n

service mysql restart
\n\u3067\u518d\u8d77\u52d5\u304c\u4e0d\u53ef\u80fd\u306a\u5834\u5408\u306e\u5bfe\u51e6\u65b9\u6cd5<\/p>\n

\u2460\u3000\u30a8\u30e9\u30fc\u30ed\u30b0\u306e\u53ce\u96c6\u65b9\u6cd5<\/p>\n

# mysqld \u3067\u3001\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u76f4\u63a5\u8d77\u52d5\u3057\u3066\u307f\u308b<\/p>\n

\u3053\u306e\u65b9\u6cd5\u3067\u3001\u78ba\u5b9f\u306b\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8aad\u307f\u51fa\u305b\u308b<\/p>\n

\u4f8b<\/p>\n

161114 10:11:39 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.\r\nmysqld: Error on realpath() on '\/var\/lib\/mysql-files' (Error 2)\r\n161114 10:11:39 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : \/var\/lib\/mysql-files\r\n161114 10:11:39 [ERROR] Aborting<\/pre>\n
\u3053\u306e\u5834\u5408\u3001”\/var\/lib\/mysql-files” \u304c\u5b58\u5728\u3057\u306a\u3044\u306e\u3067\u8d77\u52d5\u304c\u963b\u307e\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u539f\u56e0\u3068\u5206\u304b\u308b<\/p>\n
\u203b\u3000\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u306b\u3088\u308a\u3000\/etc\/apparmor.d\/usr.sbin.mysqld\u3000\u304c\u66f8\u304d\u63db\u3048\u3089\u308c\u3066\u3000\u8d77\u52d5\u3067\u304d\u306a\u3044\u73fe\u8c61\u304c\u78ba\u8a8d\u3055\u308c\u3066\u3044\u307e\u3059
\n\u3000\u3000\u3000\u672c\u4ef6\u306b\u3064\u3044\u3066\u306f\u3000mysql\u95a2\u9023\/\u30c7\u30fc\u30bf\u30a8\u30ea\u30a2\u306e\u5909\u66f4\u3000\u3067\u89e3\u8aac\u3055\u308c\u3066\u3044\u307e\u3059<\/p>\n","protected":false},"excerpt":{"rendered":"
mysql\u304c\u7a81\u7136\u8d77\u52d5\u3067\u304d\u306a\u304f\u306a\u3063\u305f\u5834\u5408\u306e\u5bfe\u51e6\u6cd5 service mysql restart \u3067\u518d\u8d77\u52d5\u304c\u4e0d\u53ef\u80fd\u306a\u5834\u5408\u306e\u5bfe\u51e6\u65b9\u6cd5 \u2460\u3000\u30a8\u30e9\u30fc\u30ed\u30b0\u306e\u53ce\u96c6\u65b9\u6cd5 # mysqld \u3067\u3001\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u76f4\u63a5\u8d77\u52d5\u3057\u3066\u307f\u308b \u3053\u306e\u65b9\u6cd5\u3067 … \u7d9a\u304d\u3092\u8aad\u3080 mysql\u304c\u7a81\u7136\u8d77\u52d5\u3067\u304d\u306a\u304f\u306a\u3063\u305f<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":306,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-331","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages\/331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=331"}],"version-history":[{"count":4,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages\/331\/revisions"}],"predecessor-version":[{"id":364,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages\/331\/revisions\/364"}],"up":[{"embeddable":true,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages\/306"}],"wp:attachment":[{"href":"https:\/\/eng.miteel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}