{"id":326,"date":"2025-08-21T09:45:49","date_gmt":"2025-08-21T01:45:49","guid":{"rendered":"https:\/\/lib.kimsor.top\/?p=326"},"modified":"2025-08-21T09:45:49","modified_gmt":"2025-08-21T01:45:49","slug":"clickhouse%e9%80%9a%e8%bf%87docker%e5%ae%89%e8%a3%85%e4%bb%a5%e5%8f%8a%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"https:\/\/lib.kimsor.top\/?p=326","title":{"rendered":"Clickhouse\u901a\u8fc7docker\u5b89\u88c5\u4ee5\u53ca\u4f7f\u7528"},"content":{"rendered":"\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\u672c\u6559\u7a0b\u5b89\u88c5\u901a\u8fc7docker\u6765\u8fdb\u884c\u5b89\u88c5\uff0cclickhouse\u6682\u65e0windows\u7248\u672c<\/p>\n<\/blockquote>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>1\u3001\u62c9\u53d6docker clickhouse\u955c\u50cf<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker pull clickhouse\/clickhouse-server<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>2\u3001\u542f\u52a8\u4e34\u65f6\u5bb9\u5668\u83b7\u53d6\u539f\u751f\u914d\u7f6e<\/strong><\/p>\n\n\n\n<p>\u542f\u52a8\u5bb9\u5668<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker run -d --name=temp-clickhouse clickhouse\/clickhouse-server<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>\u590d\u5236\u539f\u751f\u914d\u7f6e\u6587\u4ef6\u5230\u672c\u5730\uff0c\u6b64\u5904\u6211\u662f\u5c06\u914d\u7f6e\u6587\u4ef6\u653e\u7f6e\u5230\u6211\u7684\/opt\/clickhouse\/conf\u76ee\u5f55\u4e0b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker cp temp-clickhouse:\/etc\/clickhouse-server\/users.xml \/opt\/clickhouse\/conf\/users.xml\n\ndocker cp temp-clickhouse:\/etc\/clickhouse-server\/config.xml \/opt\/clickhouse\/conf\/config.xml<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>3\u3001\u4fee\u6539\u914d\u7f6e<\/strong><\/p>\n\n\n\n<p>\u6253\u5f00\u83b7\u53d6\u5230\u7684users.xml<\/p>\n\n\n\n<p>\u914d\u7f6e\u5bc6\u7801\uff0c\u8fd9\u91cc\u6211\u6d4b\u8bd5\u8bbe\u7f6e\u4e3a123456<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">&lt;password>123456&lt;\/password><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>\u6dfb\u52a0\u4ee5\u4e0b\u914d\u7f6e\uff0c\u5982\u679c\u7f3a\u5931\u5219\u6dfb\u52a0\uff0c\u6dfb\u52a0\u4ee5\u4e0b\u914d\u7f6e\u662f\u56e0\u4e3adefault\u9ed8\u8ba4\u7528\u6237\u662f\u65e0\u6cd5\u8fdb\u884c\u5927\u91cf\u64cd\u4f5c\u7684\uff0c\u5fc5\u987b\u901a\u8fc7default\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u7ba1\u7406\u5458\u8d26\u6237\u4f7f\u7528<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">&lt;named_collection_control>1&lt;\/named_collection_control><br>&lt;show_named_collections>1&lt;\/show_named_collections><br>&lt;show_named_collections_secrets>1&lt;\/show_named_collections_secrets><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>networks\u6807\u7b7e\u4e2d\u7684ip\u6807\u7b7e\u8bbe\u7f6e\u4e3a::\/0 \uff0c\u4f7fdefault\u7528\u6237\u6240\u6709ip\u5747\u53ef\u8bbf\u95ee<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">&lt;networks><br>    &lt;ip>::\/0&lt;\/ip><br>&lt;\/networks><\/pre>\n\n\n\n<p>\u4fee\u6539\u5b8c\u6bd5\u4fdd\u5b58<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u6253\u5f00\u83b7\u53d6\u7684conf.xml<\/p>\n\n\n\n<p>\u5c06listen_host\u6807\u7b7e\u8bbe\u7f6e\u4e3a\u6240\u6709ip\u5747\u53ef\u8fde\u63a5<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">&lt;listen_host>0.0.0.0&lt;\/listen_host><\/pre>\n\n\n\n<p>\u4fee\u6539\u5b8c\u6bd5\u4fdd\u5b58<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>4\u3001\u521b\u5efa\u6b63\u5f0f\u5bb9\u5668<\/strong><\/p>\n\n\n\n<p>\u524d\u9762\u521b\u5efa\u7684\u4e34\u65f6\u5bb9\u5668\u53ef\u8fdb\u884c\u5220\u9664<\/p>\n\n\n\n<p>\u521b\u5efa\u5bb9\u5668<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker run  -d --name clickhouse -p 8123:8123 -p 9000:9000 -p 9004:9004 -v \/opt\/clickhouse\/conf\/config.xml:\/etc\/clickhouse-server\/config.xml -v \/opt\/clickhouse\/conf\/users.xml:\/etc\/clickhouse-server\/users.xml -v \/opt\/clickhouse\/data:\/var\/lib\/clickhouse\/ bdc92f76af67\n<\/code><\/pre>\n\n\n\n<p>\u89e3\u6790\uff1a<\/p>\n\n\n\n<p>8123\u662fclickhouse\u7684\u8fde\u63a5\u7aef\u53e3\uff0c9004\u662f\u53ef\u901a\u8fc7mysql\u9a71\u52a8\u8fde\u63a5\u7684\u7aef\u53e3\uff0c9000\u662f\u8fde\u63a5\u63a7\u5236\u53f0\u7684\u8fde\u63a5\u7aef\u53e3\u3002\u6b63\u5e38\u8fde\u63a5\u53ef\u53ea\u5f00\u653e8123<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>5\u3001\u521b\u5efa\u5b8c\u6210\uff0c\u8fdb\u5165\u5bb9\u5668<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker exec -it clickhouse \/bin\/bash<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>6\u3001\u901a\u8fc7default\u767b\u5f55clickhouse<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>clickhouse-client -u default -p 123456<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>7\u3001\u6dfb\u52a0\u65b0\u7528\u6237\u8d4b\u4e88\u6743\u9650<\/strong><\/p>\n\n\n\n<p>\u8fd9\u91cc\u6211\u521b\u5efa\u7684\u662fclickhouse_admin\u7528\u6237\uff0c\u5bc6\u7801\u4e3apassword<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER clickhouse_admin IDENTIFIED BY 'password'<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>\u8d4b\u4e88\u6743\u9650<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL ON *.* TO clickhouse_admin WITH GRANT OPTION<\/code><\/pre>\n\n\n\n<p>\u7528\u65b0\u7528\u6237\u767b\u5f55\u5219\u53ef\u4ee5\u4f7f\u7528clickhouse\u4e86\uff0c\u5b8c\u6210<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6559\u7a0b\u5b89\u88c5\u901a\u8fc7docker\u6765\u8fdb\u884c\u5b89\u88c5\uff0cclickhouse\u6682\u65e0windows\u7248\u672c 1\u3001\u62c9\u53d6docker cli [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,3],"tags":[],"class_list":["post-326","post","type-post","status-publish","format-standard","hentry","category-clickhouse","category-database"],"_links":{"self":[{"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=\/wp\/v2\/posts\/326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=326"}],"version-history":[{"count":2,"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=\/wp\/v2\/posts\/326\/revisions"}],"predecessor-version":[{"id":328,"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=\/wp\/v2\/posts\/326\/revisions\/328"}],"wp:attachment":[{"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lib.kimsor.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}