{"id":1074,"date":"2016-04-01T11:25:43","date_gmt":"2016-04-01T02:25:43","guid":{"rendered":"http:\/\/blog.moramcnt.com\/?p=1074"},"modified":"2016-04-01T11:25:43","modified_gmt":"2016-04-01T02:25:43","slug":"pydio-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%9d%b4%ea%b4%80-mysql-mariadb","status":"publish","type":"post","link":"http:\/\/blog.moramcnt.com\/?p=1074","title":{"rendered":"pydio \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\uad00 (Mysql->MariaDB)"},"content":{"rendered":"<p>Pydio\uc5d0\uc11c MySql 5.7\uc744 \uc0ac\uc6a9\ud558\ub2e4\uac00, \uc0ac\uc815\uc0c1 MariaDB 10.1 \ub85c \uc774\uad00\ud574\uc57c \ud588\ub2e4.<br \/>\n\uadf8\ub798\uc11c \uc774\uad00\uc791\uc5c5 \uc808\ucc28\ub97c \uc544\ub798\uc640 \uac19\uc774 \uc815\ub9ac\ud558\uc5ec\ubcf4\uc558\ub2e4.<\/p>\n<p>1. Mysql \ub370\uc774\ud130 \ubc31\uc5c5<\/p>\n<pre>\r\nmysqldump -u root -p pydio > pydio.sql\r\n<\/pre>\n<p>2. MariaDB \uc124\uce58<br \/>\n   \uc124\uce58\uc808\ucc28\ub294 \uc0dd\ub7b5<\/p>\n<p>3. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131<br \/>\n  MariaDB\ub3c4 mysql\uae30\ubc18\uc774\ub77c \uadf8\ub7f0\uc9c0 \uba85\ub839\uc5b4\uac00 \ub3d9\uc77c\ud558\ub2e4.<\/p>\n<pre>\r\nmysqladmin -uroot -p create pydio\r\n<\/pre>\n<p>4. \uc720\uc800\uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec<\/p>\n<pre>\r\nmysql -uroot -p mysql\r\nCREATE USER \"pydiouser\"@\"localhost\" IDENTIFIED BY \"\ubcf8\uc778\uc758 \ube44\ubc00\ubc88\ud638\";\r\nGRANT ALL PRIVILEGES ON pydio.* TO \"pydiouser\"@\"localhost\";\r\nGRANT ALL PRIVILEGES ON pydio.* TO 'pydiouser'@'%' identified by '\ubcf8\uc778\uc758 \ube44\ubc00\ubc88\ud638';\r\nflush privileges;\r\n<\/pre>\n<p>5. \ub370\uc774\ub354 \ubcf5\uc6d0<\/p>\n<pre>\r\nmysql -u root -p pydio < pydio.sql\r\n<\/pre>\n<p>6. pydio \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0<br \/>\n   MariaDB\uac00 \ub85c\uceec\uc11c\ubc84\uac00 \uc544\ub2c8\ub77c\uba74 Admin\uc73c\ub85c \ub85c\uadf8\uc778\ud558\uc5ec \uc544\ub798 \uc704\uce58\uc5d0 \uc788\ub294 \uc811\uc18d\uc815\ubcf4\ub97c \uc218\uc815\ud558\uba74 \ub41c\ub2e4.<br \/>\n   Admin > \uc124\uc815 > Application Parameters > Application Core > Configuration Management > Core SQL Connection<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pydio\uc5d0\uc11c MySql 5.7\uc744 \uc0ac\uc6a9\ud558\ub2e4\uac00, \uc0ac\uc815\uc0c1 MariaDB 10.1 \ub85c \uc774\uad00\ud574\uc57c \ud588\ub2e4. \uadf8\ub798\uc11c \uc774\uad00\uc791\uc5c5 \uc808\ucc28\ub97c \uc544\ub798\uc640 \uac19\uc774 \uc815\ub9ac\ud558\uc5ec\ubcf4\uc558\ub2e4. 1. Mysql \ub370\uc774\ud130 \ubc31\uc5c5 mysqldump -u root -p pydio > pydio.sql 2. MariaDB \uc124\uce58 \uc124\uce58\uc808\ucc28\ub294 \uc0dd\ub7b5 3. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131 MariaDB\ub3c4 mysql\uae30\ubc18\uc774\ub77c \uadf8\ub7f0\uc9c0 \uba85\ub839\uc5b4\uac00 \ub3d9\uc77c\ud558\ub2e4. mysqladmin -uroot -p create pydio 4. \uc720\uc800\uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec mysql -uroot -p mysql CREATE [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[180],"tags":[188,190,179],"class_list":["post-1074","post","type-post","status-publish","format-standard","hentry","category-cloud","tag-mariadb","tag-mysql","tag-pydio"],"_links":{"self":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/1074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1074"}],"version-history":[{"count":1,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/1074\/revisions"}],"predecessor-version":[{"id":1077,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/1074\/revisions\/1077"}],"wp:attachment":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1074"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}