{"id":623,"date":"2020-06-10T14:52:55","date_gmt":"2020-06-10T05:52:55","guid":{"rendered":"https:\/\/hyandmj.asuscomm.com\/hblog\/?p=623"},"modified":"2021-02-09T12:28:05","modified_gmt":"2021-02-09T03:28:05","slug":"influxdb-quick-guide","status":"publish","type":"post","link":"https:\/\/hyandmj.asuscomm.com\/hblog\/?p=623","title":{"rendered":"InfluxDB Quick Guide"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">  \uc790\uc8fc \uc4f0\uc9c0 \uc54a\uc544\uc11c \ucee4\ub9e8\ub4dc\uac00 \uc790\uafb8 \ud5f7\uac08\ub9b0\ub2e4. \uac8c\ub2e4\uac00 \uac00\ubcbc\uc6b4 TSDB\ub77c \uadf8\ub7f0\uc9c0 MySQL \ub4f1\uacfc \uc0ac\uc6a9\ubc29\ubc95\uc774 \uc0b4\uc9dd \ub2e4\ub974\ub2e4. (\uac1c\ubc1c\uc0ac\uc5d0\uc11c\ub294 InfluxQL, <strong>Influx<\/strong>DB SQL-like <strong>Q<\/strong>uery <strong>L<\/strong>anguage\uc774\ub77c\uace0 \ubd80\ub978\ub2e4) \ub098\ub9cc\uc758 cheating sheet\ub97c \ub9cc\ub4e4\uc5b4 \ubd04. \uc774\ud558\uc758 \uac00\uc774\ub4dc\ub294 \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \ubaa8\ub450 \ubc84\uc804 1.1.1 \uae30\uc900. \uc0c1\ub2f9\ud55c \ubd80\ubd84\uc744 <a href=\"https:\/\/docs.influxdata.com\/influxdb\/v1.1\/query_language\/spec\">https:\/\/docs.influxdata.com\/influxdb\/v1.1\/query_language\/spec<\/a>\uc5d0\uc11c \ucc38\uace0\ud558\uc600\uc74c.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Auth<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">  Influx client\ub97c \uc2e4\ud589\ud574\ubcf4\uc790. \uc811\uc18d\uc740 <code>localhost<\/code>\ub85c.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ influx\nVisit https:\/\/enterprise.influxdata.com to register for updates, InfluxDB server management, and monitoring.\nConnected to http:\/\/localhost:8086 version 1.1.1\nInfluxDB shell version: 1.1.1<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">  \uc790 \uc774\uc81c DB\uac00 \ubb50\uac00 \uc788\ub098 \ubcfc\uae4c?<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; show databases;\nERR: unable to parse authentication credentials\nWarning: It is possible this error is due to not setting a database.\nPlease set a database with the command \"use &lt;database&gt;\".<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc778\uc99d\uc744 \uc548\ud574\uc11c DB \ubaa9\ub85d\uc744 \ubabb\ubd04. \uc560\ucd08\uc5d0 \ub178\uc778\uc99d\uc73c\ub85c \uc811\uadfc \uac00\ub2a5\ud55c DB\ub3c4 \ub9cc\ub4e4\uc5b4 \ub193\uc740 \uc801\uc774 \uc5c6\ub2e4. \uc77c\ub2e8 \uc778\uc99d\uc744 \ud574\uc57c. \uc778\uc99d \u3131\u3131.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>> auth;\nusername: \ud64d\uae38\ub3d9\npassword:\n> show databases;\n_internal\n\uae38\ub3d9\uc774DB1\n\uae38\ub3d9\uc774DB2\n...<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c DB \ubaa9\ub85d\uc774 \ubcf4\uc778\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">User Management<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\ud604\uc7ac \uc720\uc800 \ubaa9\ub85d \ubcf4\uae30<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>> show users;\nuser            admin\n----            -----\naaaaa           true\nbbbbb           true\nccccc           false<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc704\uc640 \uac19\uc774 \uc720\uc800 \ubaa9\ub85d\uc744 \ucd9c\ub825\ud574 \uc90c.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\uc720\uc800 \uc0dd\uc131<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><code>create user &lt;username&gt; with password '&lt;password&gt;';<\/code>\ub85c \uc0dd\uc131. \uc608\uc2dc\ub85c <code>ddddd<\/code>\ub77c\ub294 \uacc4\uc815\uc744 \uc0dd\uc131\ud574 \ubcf8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>> create user ddddd with password 'ddddd';\n> show users;\nuser            admin\n----            -----\naaaaa           true\nbbbbb           true\nccccc           false\nddddd           false<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\ub2e4\uc2dc show users\ub97c \ud574\ubcf4\uba74 \uacc4\uc815\uc774 \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 \uac83\uc744 \ud655\uc778 \uac00\ub2a5. Admin \uc720\uc800\ub97c \uc0dd\uc131\ud558\uace0 \uc2f6\ub2e4\uba74 \ub4a4\uc5d0 with all privileges\ub97c \ubd99\uc778\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>> create user eeeee with password 'eeeee' with all privileges;\n> show users;\nuser            admin\n----            -----\naaaaa           true\nbbbbb           true\nccccc           false\nddddd           false\neeeee           true<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\uc720\uc800 \uc0ad\uc81c<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">  \uc0dd\uc131\ub41c \uc720\uc800\ub97c \ub2e4\uc2dc \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95\uc740?<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>> drop user \"eeeee\";\n> show users;\nuser            admin\n----            -----\naaaaa           true\nbbbbb           true\nccccc           false\nddddd           false<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Database Management<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">DB \uc0dd\uc131<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">  DB\ub97c \ud558\ub098 \ub9cc\ub4e4\uc5b4 \ubcf4\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; create database \"dbdb\";\n&gt; show databases;\n_internal\n\uae38\ub3d9\uc774DB1\n\uae38\ub3d9\uc774DB2\n...\ndbdb<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc0dd\uc131 \ucffc\ub9ac \ub4a4\uc5d0 with\ub97c \ubd99\uc774\uace0 \uc635\uc158\uc744 \ub355\uc9c0\ub355\uc9c0 \ub2ec \uc218 \uc788\ub294\ub370, \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uc774 \uae00\uc758 \ub9e8 \ucc98\uc74c\uc5d0 \ub098\uc624\ub294 \ub9c1\ud06c \ucc38\uace0.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">DB \uc0ad\uc81c<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">  \uc720\uc800\ub97c \uc0ad\uc81c\ud560 \ub54c\uc640 \uc720\uc0ac\ud558\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; drop database \"dbdb\";\n&gt; show databases;\n_internal\n\uae38\ub3d9\uc774DB1\n\uae38\ub3d9\uc774DB2\n...<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Grant Privileges<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\uad8c\ud55c \ubd80\uc5ec<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">  \ud55c \uc720\uc800\uc5d0\uac8c \uc0dd\uc131\ud55c DB\uc758 admin privilege\ub97c \ubd80\uc5ec\ud574\ubcf4\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; grant all on \"dbdb\" to \"ddddd\";\n&gt; show grants for \"ddddd\";\ndatabase        privilege\n--------        ---------\ndbdb            ALL PRIVILEGES<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc720\uc800 <code>ddddd<\/code>\uc758 grants\ub97c \ubf51\uc544\ubcf4\uba74 \uc798 \uc801\uc6a9\ub418\uc5b4 \uc788\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\uad8c\ud55c \ud68c\uc218<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">  \ubd80\uc5ec\ub41c \uad8c\ud55c\uc744 \ub2e4\uc2dc \ube8f\uc5b4\ubcf4\uc790.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; revoke all on \"dbdb\" from \"ddddd\";\n&gt; show grants for \"ddddd\";\ndatabase        privilege\n--------        ---------\ndbdb            NO PRIVILEGES<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c <code>ddddd<\/code>\ub294 \ub354\uc774\uc0c1 <code>dbdb<\/code> DB\uc758 \uadf8 \uc5b4\ub5a4 privilege\ub3c4 \uac00\uc9c0\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc790\uc8fc \uc4f0\uc9c0 \uc54a\uc544\uc11c \ucee4\ub9e8\ub4dc\uac00 \uc790\uafb8 \ud5f7\uac08\ub9b0\ub2e4. \uac8c\ub2e4\uac00 \uac00\ubcbc\uc6b4 TSDB\ub77c \uadf8\ub7f0\uc9c0 MySQL \ub4f1\uacfc \uc0ac\uc6a9\ubc29\ubc95\uc774 \uc0b4\uc9dd \ub2e4\ub974\ub2e4. (\uac1c\ubc1c\uc0ac\uc5d0\uc11c\ub294 InfluxQL, InfluxDB SQL-like Query Language\uc774\ub77c\uace0 \ubd80\ub978\ub2e4) \ub098\ub9cc\uc758 cheating sheet\ub97c \ub9cc\ub4e4\uc5b4 \ubd04. \uc774\ud558\uc758 \uac00\uc774\ub4dc\ub294 \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \ubaa8\ub450 \ubc84\uc804 1.1.1 \uae30\uc900. \uc0c1\ub2f9\ud55c \ubd80\ubd84\uc744 https:\/\/docs.influxdata.com\/influxdb\/v1.1\/query_language\/spec\uc5d0\uc11c \ucc38\uace0\ud558\uc600\uc74c. Auth Influx client\ub97c \uc2e4\ud589\ud574\ubcf4\uc790. \uc811\uc18d\uc740 localhost\ub85c. \uc790 \uc774\uc81c DB\uac00 \ubb50\uac00 \uc788\ub098 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-623","post","type-post","status-publish","format-standard","hentry","category-db"],"_links":{"self":[{"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=\/wp\/v2\/posts\/623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=623"}],"version-history":[{"count":17,"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=\/wp\/v2\/posts\/623\/revisions"}],"predecessor-version":[{"id":713,"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=\/wp\/v2\/posts\/623\/revisions\/713"}],"wp:attachment":[{"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hyandmj.asuscomm.com\/hblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}