{"id":18538,"date":"2014-10-21T06:50:18","date_gmt":"2014-10-20T22:50:18","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/10\/21\/banana-pi-%e6%b8%ac%e8%a9%a6-%e5%ae%89%e8%a3%9d-mariadb\/"},"modified":"2021-03-18T17:24:07","modified_gmt":"2021-03-18T09:24:07","slug":"banana-pi-%e6%b8%ac%e8%a9%a6-%e5%ae%89%e8%a3%9d-mariadb","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/10\/21\/banana-pi-%e6%b8%ac%e8%a9%a6-%e5%ae%89%e8%a3%9d-mariadb\/","title":{"rendered":"Banana Pi \u6e2c\u8a66 &#8211; \u5b89\u88dd MariaDB"},"content":{"rendered":"<p>\u56e0\u70ba\u5957\u4ef6\u5eab\u4e2d\u6c92\u6709 MariaDB\uff0c\u6240\u4ee5\u63a1\u7528\u624b\u52d5\u7de8\u8b6f\u5b89\u88dd<br \/>\u5e95\u4e0b\u6587\u7ae0\u53c3\u8003\uff1a<br \/><a href=\"http:\/\/www.raspberrypi.org\/forums\/viewtopic.php?t=12859&amp;p=288820\" target=\"_blank\" rel=\"noopener noreferrer\">Raspberry Pi \u2022 View topic &#8211; How I compiled MariaDB and Phidget drivers<\/a><br \/><a href=\"http:\/\/raspbian-france.fr\/installer-mariadb-raspbian\/\" target=\"_blank\" rel=\"noopener noreferrer\">Installer MariaDB sur Raspbian &#8211; Raspbian France | Raspbian France<\/a><\/p>\n<p>\u5148\u5230 MariaDB\u00a0\u5b98\u65b9\u7db2\u7ad9\u4e0b\u8f09 Source Code<br \/>MariaDB\u00a0\u5b98\u65b9\u7db2\u7ad9\uff1a<a href=\"https:\/\/mariadb.org\/en\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/mariadb.org\/en\/<\/a><br \/><a id=\"res_2675236\" href=\"https:\/\/2blog.ilc.edu.tw\/wp-content\/uploads\/sites\/985\/25793\/25793-2675236.png\"><img decoding=\"async\" src=\"https:\/\/2blog.ilc.edu.tw\/wp-content\/uploads\/sites\/985\/25793\/previews-med\/25793-2675236.png\" border=\"0\" alt=\"\" \/><\/a><\/p>\n<p><a id=\"res_2675235\" href=\"https:\/\/2blog.ilc.edu.tw\/wp-content\/uploads\/sites\/985\/25793\/25793-2675235.png\"><img decoding=\"async\" src=\"https:\/\/2blog.ilc.edu.tw\/wp-content\/uploads\/sites\/985\/25793\/previews-med\/25793-2675235.png\" border=\"0\" alt=\"\" \/><\/a>[@more@]<br \/>\u4e0b\u8f09<br \/># <span style=\"color: #ff0000\">wget -O mariadb-5.5.39.tar.gz &#8220;https:\/\/downloads.mariadb.org\/interstitial\/mariadb-5.5.39\/source\/mariadb-5.5.39.tar.gz\/from\/http%3A\/\/mirrors.neusoft.edu.cn\/mariadb&#8221;<\/span><\/p>\n<p>\u89e3\u58d3\u7e2e<br \/># <span style=\"color: #ff0000\">tar xvzf mariadb-5.5.39.tar.gz<\/span><\/p>\n<p>\u5207\u63db\u76ee\u9304<br \/># <span style=\"color: #ff0000\">cd mariadb-5.5.39\/BUILD<\/span><\/p>\n<p>\u5b89\u88dd\u7de8\u8b6f\u6642\u6240\u9808\u5957\u4ef6<br \/># <span style=\"color: #ff0000\">apt-get install cmake libncurses5-dev bison<\/span><br \/># <span style=\"color: #ff0000\">apt-get install build-essential<\/span><\/p>\n<p>\u958b\u59cb\u7de8\u8b6f\u53ca\u5b89\u88dd<br \/>#<span style=\"color: #ff0000\"> .\/autorun.sh<\/span><br \/># <span style=\"color: #ff0000\">cd ..<\/span><br \/># <span style=\"color: #ff0000\">.\/configure<\/span><br \/># <span style=\"color: #ff0000\">make;make install<\/span><\/p>\n<p>\u5efa\u7acb mysql\u00a0\u4f7f\u7528\u8005<br \/># <span style=\"color: #ff0000\">useradd mysql<\/span><\/p>\n<p>\u6539\u8b8a\u76ee\u9304\u64c1\u6709\u8005\u53ca\u7fa4\u7d44<br \/># <span style=\"color: #ff0000\">chown -R mysql \/usr\/local\/mysql<\/span><\/p>\n<p>\u5207\u63db\u76ee\u9304<br \/># <span style=\"color: #ff0000\">cd \/usr\/local\/mysql<\/span><\/p>\n<p>\u5b89\u88dd\u8cc7\u6599\u5eab<br \/># <span style=\"color: #ff0000\">scripts\/mysql_install_db &#8211;user=mysql<\/span><\/p>\n<p>\u8907\u88fd\u555f\u52d5\u6a94\u6848\u5230 <span style=\"color: #0000ff\">\/etc\/init.d<\/span>\u00a0\u76ee\u9304<br \/># <span style=\"color: #ff0000\">cp support-files\/mysql.server \/etc\/init.d\/mysqld<\/span><\/p>\n<p>\u555f\u52d5 MariaDB SQL Server<br \/># <span style=\"color: #ff0000\">\/etc\/init.d\/mysqld start<\/span><br \/><span style=\"color: #0000ff\">Starting MySQL<\/span><br \/><span style=\"color: #0000ff\">[ ok &#8230;..<\/span><\/p>\n<p>\u5b89\u5168\u6027\u8a2d\u5b9a<br \/># <span style=\"color: #ff0000\">.\/bin\/mysql_secure_installation<\/span><\/p>\n<p>\u6aa2\u67e5\u662f\u5426\u6709\u6b63\u78ba\u555f\u52d5<br \/># <span style=\"color: #ff0000\">netstat -ant | grep :3306<\/span><br \/><span style=\"color: #0000ff\">tcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0.0.0.0:3306\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0:*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN<\/span><\/p>\n<p>\u8a2d\u5b9a\u958b\u6a5f\u5f8c\u555f\u52d5<br \/># <span style=\"color: #ff0000\">\/usr\/sbin\/update-rc.d -f mysqld defaults<\/span><br \/><span style=\"color: #0000ff\">update-rc.d: using dependency based boot sequencing<\/span><\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u56e0\u70ba\u5957\u4ef6\u5eab\u4e2d\u6c92\u6709 MariaDB\uff0c\u6240\u4ee5\u63a1\u7528\u624b\u52d5\u7de8\u8b6f\u5b89\u88dd\u5e95\u4e0b\u6587\u7ae0\u53c3\u8003\uff1aRaspberry Pi \u2022 View t &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/2blog.ilc.edu.tw\/25793\/2014\/10\/21\/banana-pi-%e6%b8%ac%e8%a9%a6-%e5%ae%89%e8%a3%9d-mariadb\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008Banana Pi \u6e2c\u8a66 &#8211; \u5b89\u88dd MariaDB\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[162,116],"tags":[],"class_list":["post-18538","post","type-post","status-publish","format-standard","hentry","category-c-83744","category-c-78461"],"meta_key":{"_pingme":["1"],"_encloseme":["1"],"lt_post_id":["519982"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18538"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=18538"}],"version-history":[{"count":1,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18538\/revisions"}],"predecessor-version":[{"id":20169,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18538\/revisions\/20169"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=18538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=18538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=18538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}