<!DOCTYPE html>
<html lang="zh-CN" data-theme="light">
  <head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width,initial-scale=1" />
    <meta name="generator" content="VuePress 2.0.0-beta.61" />
    <meta name="theme" content="VuePress Theme Hope" />
    <meta property="og:url" content="https://iotdb.apache.org/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html"><meta property="og:site_name" content="IoTDB Website"><meta property="og:description" content="Workbench简介 Workbench是一个可创建多个连接的图形化数据库管理工具，用于管理IoTDB，提供元数据的可视化与管理、数据的增删改查以及权限控制等功能。Workbench不仅满足专业开发人员的所有需求，同时简洁友好的界面设计对初学者来说也易于上手。 安装 如果你在安装过程中遇到任何问题，你可以参考文档或向软件供应商或技术支持团队寻求帮助。..."><meta property="og:type" content="article"><meta property="og:locale" content="zh-CN"><script type="application/ld+json">{"@context":"https://schema.org","@type":"Article","headline":"","image":[""],"dateModified":null,"author":[]}</script><link rel="icon" href="/favicon.ico"><meta name="Description" content="Apache IoTDB: Time Series Database for IoT"><meta name="Keywords" content="TSDB, time series, time series database, IoTDB, IoT database, IoT data management,时序数据库, 时间序列管理, IoTDB, 物联网数据库, 实时数据库, 物联网数据管理, 物联网数据"><meta name="baidu-site-verification" content="wfKETzB3OT"><meta name="google-site-verification" content="mZWAoRY0yj_HAr-s47zHCGHzx5Ju-RVm5wDbPnwQYFo"><title>IoTDB Website</title><meta name="description" content="Workbench简介 Workbench是一个可创建多个连接的图形化数据库管理工具，用于管理IoTDB，提供元数据的可视化与管理、数据的增删改查以及权限控制等功能。Workbench不仅满足专业开发人员的所有需求，同时简洁友好的界面设计对初学者来说也易于上手。 安装 如果你在安装过程中遇到任何问题，你可以参考文档或向软件供应商或技术支持团队寻求帮助。...">
    <style>
      :root {
        --bg-color: #fff;
      }

      html[data-theme="dark"] {
        --bg-color: #1d1e1f;
      }

      html,
      body {
        background: var(--bg-color);
      }
    </style>
    <script>
      const userMode = localStorage.getItem("vuepress-theme-hope-scheme");
      const systemDarkMode =
        window.matchMedia &&
        window.matchMedia("(prefers-color-scheme: dark)").matches;

      if (userMode === "dark" || (userMode !== "light" && systemDarkMode)) {
        document.documentElement.setAttribute("data-theme", "dark");
      }
    </script>
    <link rel="preload" href="/assets/style-13611a3c.css" as="style"><link rel="stylesheet" href="/assets/style-13611a3c.css">
    <link rel="modulepreload" href="/assets/app-bf7ef9dd.js"><link rel="modulepreload" href="/assets/framework-ae7271bd.js"><link rel="modulepreload" href="/assets/Workbench.html-2efc251f.js"><link rel="modulepreload" href="/assets/Workbench.html-39b08b0c.js">
  </head>
  <body>
    <div id="app"><!--[--><!--[--><!--[--><span tabindex="-1"></span><a href="#main-content" class="skip-link sr-only">跳至主要內容</a><!--]--><!--[--><div class="theme-container has-toc"><!--[--><header class="navbar hide-icon" id="navbar"><div class="navbar-start"><button class="toggle-sidebar-button" title="Toggle Sidebar"><span class="icon"></span></button><!--[--><!----><!--]--><a href="/zh/" class="brand"><img class="logo" src="/logo.png" alt="IoTDB Website"><!----><span class="site-name hide-in-pad">IoTDB Website</span></a><!--[--><!----><!--]--></div><div class="navbar-center"><!--[--><!----><!--]--><!--[--><!----><!--]--></div><div class="navbar-end"><!--[--><!----><!--]--><div id="docsearch-container"></div><nav class="nav-links"><div class="nav-item hide-in-mobile"><div class="dropdown-wrapper"><button class="dropdown-title" type="button" aria-label="文档"><span class="title"><!---->文档</span><span class="arrow"></span><ul class="nav-dropdown"><li class="dropdown-item"><a href="/zh/UserGuide/Master/QuickStart/QuickStart.html" class="nav-link" aria-label="latest"><!---->latest<!----></a></li><li class="dropdown-item"><a href="/zh/UserGuide/V1.1.x/QuickStart/QuickStart.html" class="nav-link" aria-label="v1.1.x"><!---->v1.1.x<!----></a></li><li class="dropdown-item"><a href="/zh/UserGuide/V1.0.x/QuickStart/QuickStart.html" class="nav-link" aria-label="v1.0.x"><!---->v1.0.x<!----></a></li><li class="dropdown-item"><a href="/zh/UserGuide/V0.13.x/QuickStart/QuickStart.html" class="nav-link" aria-label="v0.13.x"><!---->v0.13.x<!----></a></li></ul></button></div></div><div class="nav-item hide-in-mobile"><a href="https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=177051872" rel="noopener noreferrer" target="_blank" aria-label="系统设计" class="nav-link"><!---->系统设计<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!----></a></div><div class="nav-item hide-in-mobile"><a href="/zh/Download/" class="nav-link" aria-label="下载"><!---->下载<!----></a></div><div class="nav-item hide-in-mobile"><div class="dropdown-wrapper"><button class="dropdown-title" type="button" aria-label="社区"><span class="title"><!---->社区</span><span class="arrow"></span><ul class="nav-dropdown"><li class="dropdown-item"><a href="/zh/Community/About.html" class="nav-link" aria-label="关于社区"><!---->关于社区<!----></a></li><li class="dropdown-item"><a href="https://cwiki.apache.org/confluence/display/iotdb" rel="noopener noreferrer" target="_blank" aria-label="Wiki" class="nav-link"><!---->Wiki<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="/zh/Community/Community-Project-Committers.html" class="nav-link" aria-label="开发人员"><!---->开发人员<!----></a></li><li class="dropdown-item"><a href="/zh/Community/Community-Powered-By.html" class="nav-link" aria-label="技术支持"><!---->技术支持<!----></a></li><li class="dropdown-item"><a href="/Community/Materials.html" class="nav-link" aria-label="活动与报告"><!---->活动与报告<!----></a></li><li class="dropdown-item"><a href="/zh/Community/Feedback.html" class="nav-link" aria-label="交流与反馈"><!---->交流与反馈<!----></a></li></ul></button></div></div><div class="nav-item hide-in-mobile"><div class="dropdown-wrapper"><button class="dropdown-title" type="button" aria-label="开发"><span class="title"><!---->开发</span><span class="arrow"></span><ul class="nav-dropdown"><li class="dropdown-item"><a href="/zh/Development/VoteRelease.html" class="nav-link" aria-label="如何投票"><!---->如何投票<!----></a></li><li class="dropdown-item"><a href="/zh/Development/HowToCommit.html" class="nav-link" aria-label="如何提交代码"><!---->如何提交代码<!----></a></li><li class="dropdown-item"><a href="/zh/Development/HowToJoin.html" class="nav-link" aria-label="成为Contributor"><!---->成为Contributor<!----></a></li><li class="dropdown-item"><a href="/zh/Development/Committer.html" class="nav-link" aria-label="成为Committer"><!---->成为Committer<!----></a></li><li class="dropdown-item"><a href="/zh/Development/ContributeGuide.html" class="nav-link" aria-label="项目开发指南"><!---->项目开发指南<!----></a></li><li class="dropdown-item"><a href="/zh/Development/HowtoContributeCode.html" class="nav-link" aria-label="技术贡献指南"><!---->技术贡献指南<!----></a></li><li class="dropdown-item"><a href="/zh/Development/format-changelist.html" class="nav-link" aria-label="TsFile的更改列表"><!---->TsFile的更改列表<!----></a></li><li class="dropdown-item"><a href="/zh/Development/rpc-changelist.html" class="nav-link" aria-label="RPC变更清单"><!---->RPC变更清单<!----></a></li></ul></button></div></div><div class="nav-item hide-in-mobile"><div class="dropdown-wrapper"><button class="dropdown-title" type="button" aria-label="ASF"><span class="title"><!---->ASF</span><span class="arrow"></span><ul class="nav-dropdown"><li class="dropdown-item"><a href="https://www.apache.org/" rel="noopener noreferrer" target="_blank" aria-label="基金会" class="nav-link"><!---->基金会<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/licenses/" rel="noopener noreferrer" target="_blank" aria-label="许可证" class="nav-link"><!---->许可证<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/security/" rel="noopener noreferrer" target="_blank" aria-label="安全" class="nav-link"><!---->安全<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/foundation/sponsorship.html" rel="noopener noreferrer" target="_blank" aria-label="赞助" class="nav-link"><!---->赞助<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/foundation/thanks.html" rel="noopener noreferrer" target="_blank" aria-label="致谢" class="nav-link"><!---->致谢<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!----></a></li><li class="dropdown-item"><a href="https://www.apache.org/events/current-event" rel="noopener noreferrer" target="_blank" aria-label="活动" class="nav-link"><!---->活动<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!----></a></li></ul></button></div></div></nav><div class="nav-item"><div class="dropdown-wrapper i18n-dropdown"><button class="dropdown-title" type="button" aria-label="选择语言"><!--[--><svg xmlns="http://www.w3.org/2000/svg" class="icon i18n-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="i18n icon" style="width:1rem;height:1rem;vertical-align:middle;"><path d="M379.392 460.8 494.08 575.488l-42.496 102.4L307.2 532.48 138.24 701.44l-71.68-72.704L234.496 460.8l-45.056-45.056c-27.136-27.136-51.2-66.56-66.56-108.544h112.64c7.68 14.336 16.896 27.136 26.112 35.84l45.568 46.08 45.056-45.056C382.976 312.32 409.6 247.808 409.6 204.8H0V102.4h256V0h102.4v102.4h256v102.4H512c0 70.144-37.888 161.28-87.04 210.944L378.88 460.8zM576 870.4 512 1024H409.6l256-614.4H768l256 614.4H921.6l-64-153.6H576zM618.496 768h196.608L716.8 532.48 618.496 768z"></path></svg><!--]--><span class="arrow"></span><ul class="nav-dropdown"><li class="dropdown-item"><a href="/" class="nav-link" aria-label="English"><!---->English<!----></a></li><li class="dropdown-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html" class="router-link-active router-link-exact-active nav-link active" aria-label="简体中文"><!---->简体中文<!----></a></li></ul></button></div></div><div class="nav-item hide-in-mobile"><button id="appearance-switch"><svg xmlns="http://www.w3.org/2000/svg" class="icon auto-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="auto icon" style="display:block;"><path d="M512 992C246.92 992 32 777.08 32 512S246.92 32 512 32s480 214.92 480 480-214.92 480-480 480zm0-840c-198.78 0-360 161.22-360 360 0 198.84 161.22 360 360 360s360-161.16 360-360c0-198.78-161.22-360-360-360zm0 660V212c165.72 0 300 134.34 300 300 0 165.72-134.28 300-300 300z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" class="icon dark-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="dark icon" style="display:none;"><path d="M524.8 938.667h-4.267a439.893 439.893 0 0 1-313.173-134.4 446.293 446.293 0 0 1-11.093-597.334A432.213 432.213 0 0 1 366.933 90.027a42.667 42.667 0 0 1 45.227 9.386 42.667 42.667 0 0 1 10.24 42.667 358.4 358.4 0 0 0 82.773 375.893 361.387 361.387 0 0 0 376.747 82.774 42.667 42.667 0 0 1 54.187 55.04 433.493 433.493 0 0 1-99.84 154.88 438.613 438.613 0 0 1-311.467 128z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" class="icon light-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="light icon" style="display:none;"><path d="M952 552h-80a40 40 0 0 1 0-80h80a40 40 0 0 1 0 80zM801.88 280.08a41 41 0 0 1-57.96-57.96l57.96-58a41.04 41.04 0 0 1 58 58l-58 57.96zM512 752a240 240 0 1 1 0-480 240 240 0 0 1 0 480zm0-560a40 40 0 0 1-40-40V72a40 40 0 0 1 80 0v80a40 40 0 0 1-40 40zm-289.88 88.08-58-57.96a41.04 41.04 0 0 1 58-58l57.96 58a41 41 0 0 1-57.96 57.96zM192 512a40 40 0 0 1-40 40H72a40 40 0 0 1 0-80h80a40 40 0 0 1 40 40zm30.12 231.92a41 41 0 0 1 57.96 57.96l-57.96 58a41.04 41.04 0 0 1-58-58l58-57.96zM512 832a40 40 0 0 1 40 40v80a40 40 0 0 1-80 0v-80a40 40 0 0 1 40-40zm289.88-88.08 58 57.96a41.04 41.04 0 0 1-58 58l-57.96-58a41 41 0 0 1 57.96-57.96z"></path></svg></button></div><div class="nav-item"><a class="repo-link" href="https://github.com/apache/iotdb" target="_blank" rel="noopener noreferrer" aria-label="GitHub"><svg xmlns="http://www.w3.org/2000/svg" class="icon github-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="github icon" style="width:1.25rem;height:1.25rem;vertical-align:middle;"><path d="M511.957 21.333C241.024 21.333 21.333 240.981 21.333 512c0 216.832 140.544 400.725 335.574 465.664 24.49 4.395 32.256-10.07 32.256-23.083 0-11.69.256-44.245 0-85.205-136.448 29.61-164.736-64.64-164.736-64.64-22.315-56.704-54.4-71.765-54.4-71.765-44.587-30.464 3.285-29.824 3.285-29.824 49.195 3.413 75.179 50.517 75.179 50.517 43.776 75.008 114.816 53.333 142.762 40.79 4.523-31.66 17.152-53.377 31.19-65.537-108.971-12.458-223.488-54.485-223.488-242.602 0-53.547 19.114-97.323 50.517-131.67-5.035-12.33-21.93-62.293 4.779-129.834 0 0 41.258-13.184 134.912 50.346a469.803 469.803 0 0 1 122.88-16.554c41.642.213 83.626 5.632 122.88 16.554 93.653-63.488 134.784-50.346 134.784-50.346 26.752 67.541 9.898 117.504 4.864 129.834 31.402 34.347 50.474 78.123 50.474 131.67 0 188.586-114.73 230.016-224.042 242.09 17.578 15.232 33.578 44.672 33.578 90.454v135.85c0 13.142 7.936 27.606 32.854 22.87C862.25 912.597 1002.667 728.747 1002.667 512c0-271.019-219.648-490.667-490.71-490.667z"></path></svg></a></div><!--[--><!----><!--]--><button class="toggle-navbar-button" aria-label="Toggle Navbar" aria-expanded="false" aria-controls="nav-screen"><span class="button-container"><span class="button-top"></span><span class="button-middle"></span><span class="button-bottom"></span></span></button></div></header><!----><!--]--><!----><div class="toggle-sidebar-wrapper"><span class="arrow start"></span></div><aside class="sidebar" id="sidebar"><!--[--><!----><!--]--><ul class="sidebar-links"><li><section class="sidebar-group"><p class="sidebar-heading"><!----><span class="title">IoTDB用户手册 (In progress)</span><!----></p><ul class="sidebar-links"></ul></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">关于IoTDB</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">快速上手</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">数据模式与概念</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">语法约定</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">应用编程接口</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">元数据操作</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">数据写入（数据更新）</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">数据删除</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">数据查询</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">运算符和函数</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">触发器</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">监控告警</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">权限管理</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">运维工具</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">端云协同</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable active"><!----><span class="title">系统集成</span><span class="arrow down"></span></button><ul class="sidebar-links"><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/Grafana-Plugin.html" class="nav-link sidebar-link sidebar-page" aria-label="Grafana-Plugin"><!---->Grafana-Plugin<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/Grafana-Connector.html" class="nav-link sidebar-link sidebar-page" aria-label="Grafana-Connector（不推荐）"><!---->Grafana-Connector（不推荐）<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/Zeppelin-IoTDB.html" class="nav-link sidebar-link sidebar-page" aria-label="Zeppelin-IoTDB"><!---->Zeppelin-IoTDB<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/DBeaver.html" class="nav-link sidebar-link sidebar-page" aria-label="DBeaver-IoTDB"><!---->DBeaver-IoTDB<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/MapReduce-TsFile.html" class="nav-link sidebar-link sidebar-page" aria-label="MapReduce-TsFile"><!---->MapReduce-TsFile<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/Spark-TsFile.html" class="nav-link sidebar-link sidebar-page" aria-label="Spark-TsFile"><!---->Spark-TsFile<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/Spark-IoTDB.html" class="nav-link sidebar-link sidebar-page" aria-label="Spark-IoTDB"><!---->Spark-IoTDB<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/Hive-TsFile.html" class="nav-link sidebar-link sidebar-page" aria-label="Hive-TsFile"><!---->Hive-TsFile<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/Flink-IoTDB.html" class="nav-link sidebar-link sidebar-page" aria-label="Flink-IoTDB"><!---->Flink-IoTDB<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/Flink-TsFile.html" class="nav-link sidebar-link sidebar-page" aria-label="Flink-TsFile"><!---->Flink-TsFile<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a href="/zh/UserGuide/Master/Ecosystem-Integration/NiFi-IoTDB.html" class="nav-link sidebar-link sidebar-page" aria-label="NiFi-IoTDB"><!---->NiFi-IoTDB<!----></a><ul class="sidebar-sub-headers"></ul><!--]--></li><li><!--[--><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html" class="router-link-active router-link-exact-active nav-link active sidebar-link sidebar-page active" aria-label="Workbench"><!---->Workbench<!----></a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#workbench简介" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="Workbench简介"><!---->Workbench简介<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#安装" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="安装"><!---->安装<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#登录" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="登录"><!---->登录<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#用户界面" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="用户界面"><!---->用户界面<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#连接" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="连接"><!---->连接<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#服务器安全性" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="服务器安全性"><!---->服务器安全性<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#数据迁移" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="数据迁移"><!---->数据迁移<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#数据预览" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="数据预览"><!---->数据预览<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#查询" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="查询"><!---->查询<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#集群管理" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="集群管理"><!---->集群管理<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#存储组管理" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="存储组管理"><!---->存储组管理<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#设备及物理量管理" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="设备及物理量管理"><!---->设备及物理量管理<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#操作日志" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="操作日志"><!---->操作日志<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#监控管理" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="监控管理"><!---->监控管理<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#数据看板" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="数据看板"><!---->数据看板<!----></a><ul class="sidebar-sub-headers"></ul></li><li class="sidebar-sub-header"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#q-a" class="router-link-active router-link-exact-active nav-link sidebar-link heading" aria-label="Q&amp;A"><!---->Q&amp;A<!----></a><ul class="sidebar-sub-headers"></ul></li></ul><!--]--></li></ul></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">分布式</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">FAQ</span><span class="arrow end"></span></button><!----></section></li><li><section class="sidebar-group"><button class="sidebar-heading clickable"><!----><span class="title">参考</span><span class="arrow end"></span></button><!----></section></li></ul><!--[--><!----><!--]--></aside><!--[--><main class="page" id="main-content"><!--[--><!----><nav class="breadcrumb disable"></nav><div class="page-title"><h1><!----></h1><div class="page-info"><!----><!----><!----><!----><span class="page-reading-time-info" aria-label="阅读时间"><svg xmlns="http://www.w3.org/2000/svg" class="icon timer-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="timer icon"><path d="M799.387 122.15c4.402-2.978 7.38-7.897 7.38-13.463v-1.165c0-8.933-7.38-16.312-16.312-16.312H256.33c-8.933 0-16.311 7.38-16.311 16.312v1.165c0 5.825 2.977 10.874 7.637 13.592 4.143 194.44 97.22 354.963 220.201 392.763-122.204 37.542-214.893 196.511-220.2 389.397-4.661 5.049-7.638 11.651-7.638 19.03v5.825h566.49v-5.825c0-7.379-2.849-13.981-7.509-18.9-5.049-193.016-97.867-351.985-220.2-389.527 123.24-37.67 216.446-198.453 220.588-392.892zM531.16 450.445v352.632c117.674 1.553 211.787 40.778 211.787 88.676H304.097c0-48.286 95.149-87.382 213.728-88.676V450.445c-93.077-3.107-167.901-81.297-167.901-177.093 0-8.803 6.99-15.793 15.793-15.793 8.803 0 15.794 6.99 15.794 15.793 0 80.261 63.69 145.635 142.01 145.635s142.011-65.374 142.011-145.635c0-8.803 6.99-15.793 15.794-15.793s15.793 6.99 15.793 15.793c0 95.019-73.789 172.82-165.96 177.093z"></path></svg><span>大约 12 分钟</span><meta property="timeRequired" content="PT12M"></span><!----><!----></div><hr></div><div class="toc-place-holder"><aside id="toc"><!--[--><!----><!--]--><div class="toc-header">此页内容<button class="print-button" title="打印"><svg xmlns="http://www.w3.org/2000/svg" class="icon print-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="print icon"><path d="M819.2 364.8h-44.8V128c0-17.067-14.933-32-32-32H281.6c-17.067 0-32 14.933-32 32v236.8h-44.8C145.067 364.8 96 413.867 96 473.6v192c0 59.733 49.067 108.8 108.8 108.8h44.8V896c0 17.067 14.933 32 32 32h460.8c17.067 0 32-14.933 32-32V774.4h44.8c59.733 0 108.8-49.067 108.8-108.8v-192c0-59.733-49.067-108.8-108.8-108.8zM313.6 160h396.8v204.8H313.6V160zm396.8 704H313.6V620.8h396.8V864zM864 665.6c0 25.6-19.2 44.8-44.8 44.8h-44.8V588.8c0-17.067-14.933-32-32-32H281.6c-17.067 0-32 14.933-32 32v121.6h-44.8c-25.6 0-44.8-19.2-44.8-44.8v-192c0-25.6 19.2-44.8 44.8-44.8h614.4c25.6 0 44.8 19.2 44.8 44.8v192z"></path></svg></button></div><div class="toc-wrapper"><ul class="toc-list"><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#workbench简介" class="router-link-active router-link-exact-active toc-link level2">Workbench简介</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#安装" class="router-link-active router-link-exact-active toc-link level2">安装</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#登录" class="router-link-active router-link-exact-active toc-link level2">登录</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#用户界面" class="router-link-active router-link-exact-active toc-link level2">用户界面</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#连接" class="router-link-active router-link-exact-active toc-link level2">连接</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#服务器安全性" class="router-link-active router-link-exact-active toc-link level2">服务器安全性</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#数据迁移" class="router-link-active router-link-exact-active toc-link level2">数据迁移</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#数据预览" class="router-link-active router-link-exact-active toc-link level2">数据预览</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#查询" class="router-link-active router-link-exact-active toc-link level2">查询</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#集群管理" class="router-link-active router-link-exact-active toc-link level2">集群管理</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#存储组管理" class="router-link-active router-link-exact-active toc-link level2">存储组管理</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#设备及物理量管理" class="router-link-active router-link-exact-active toc-link level2">设备及物理量管理</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#操作日志" class="router-link-active router-link-exact-active toc-link level2">操作日志</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#监控管理" class="router-link-active router-link-exact-active toc-link level2">监控管理</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#数据看板" class="router-link-active router-link-exact-active toc-link level2">数据看板</a></li><!----><!--]--><!--[--><li class="toc-item"><a aria-current="page" href="/zh/UserGuide/Master/Ecosystem-Integration/Workbench.html#q-a" class="router-link-active router-link-exact-active toc-link level2">Q&amp;A</a></li><!----><!--]--></ul></div><!--[--><!----><!--]--></aside></div><!----><div class="theme-hope-content"><!--

    Licensed to the Apache Software Foundation (ASF) under one
    or more contributor license agreements.  See the NOTICE file
    distributed with this work for additional information
    regarding copyright ownership.  The ASF licenses this file
    to you under the Apache License, Version 2.0 (the
    "License"); you may not use this file except in compliance
    with the License.  You may obtain a copy of the License at
    
        http://www.apache.org/licenses/LICENSE-2.0
    
    Unless required by applicable law or agreed to in writing,
    software distributed under the License is distributed on an
    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
    KIND, either express or implied.  See the License for the
    specific language governing permissions and limitations
    under the License.

--><h2 id="workbench简介" tabindex="-1"><a class="header-anchor" href="#workbench简介" aria-hidden="true">#</a> Workbench简介</h2><p>Workbench是一个可创建多个连接的图形化数据库管理工具，用于管理IoTDB，提供元数据的可视化与管理、数据的增删改查以及权限控制等功能。Workbench不仅满足专业开发人员的所有需求，同时简洁友好的界面设计对初学者来说也易于上手。</p><h2 id="安装" tabindex="-1"><a class="header-anchor" href="#安装" aria-hidden="true">#</a> 安装</h2><p>如果你在安装过程中遇到任何问题，你可以参考文档或向软件供应商或技术支持团队寻求帮助。</p><p>环境要求：JDK1.8.0_162及以上。</p><ol><li>下载并解压软件。第一步是从官方网站或一个可信赖的来源下载软件，下载地址为<a href="https://www.timecho.com/product" target="_blank" rel="noopener noreferrer">https://www.timecho.com/product<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span></a> 。</li><li>启动后端服务。输入指令：</li></ol><div class="language-text line-numbers-mode" data-ext="text"><pre class="language-text"><code>java -jar workbench.jar
</code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>或：</p><div class="language-text line-numbers-mode" data-ext="text"><pre class="language-text"><code>nohup java -jar workbench.jar  &gt;/dev/null 2&gt;&amp;1 &amp;
</code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div><p>默认端口为 9090；</p><ol><li>访问web界面。默认地址为<code>IP：9090</code>。</li></ol><h2 id="登录" tabindex="-1"><a class="header-anchor" href="#登录" aria-hidden="true">#</a> 登录</h2><p>默认用户名为root,密码为123456。用户名必须由字母、数字、下划线组成，不能以数字和下划线开始，须大于等于4个字符，密码必须大于等于6位。点击&quot;<strong>文A</strong>&quot;可切换语言，有中文、英文可选。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image6.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="用户界面" tabindex="-1"><a class="header-anchor" href="#用户界面" aria-hidden="true">#</a> 用户界面</h2><p><strong>主界面</strong></p><p>主界面由操作栏、导航栏、工具栏和几个窗格组成。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image7.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>1、连接操作栏</p><p>可以新建数据库的连接或者数据库的查询。</p><p>2、对象窗格</p><p>对象窗格显示已连接的数据库实例，采用树状结构设计，点击出现子节点可以方便地处理数据库和它们管理的对象，展示的最低层级是设备。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image8.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>3、导航栏</p><p>导航栏可选择&quot;<strong>数据库管理</strong>&quot;、&quot;<strong>监控管理</strong>&quot;、&quot;<strong>操作日志</strong>&quot;、&quot;<strong>数据看板</strong>&quot;。</p><p>4、状态栏</p><p>状态栏显示当前选项下的状态信息，当选中&quot;<strong>数据库管理</strong>&quot;时，状态栏显示数据库的在线情况、IP、端口、服务器状态及其存储组、设备、物理量的数量信息。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image9.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>当选&quot;<strong>监控管理</strong>&quot;时，状态栏显示数据库的在线情况、IP、端口、服务器状态、数据库版本、激活信息及到期时间。z注：&quot;<strong>数据库版本</strong>&quot;处的图标表示企业版或开源版，Workbench部分功能在开源版上无法使用。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image10.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>5、操作列</p><p>操作列可以选择任意选项进行操作。</p><p>6、信息窗格</p><p>信息窗格显示对象的详细信息。</p><h2 id="连接" tabindex="-1"><a class="header-anchor" href="#连接" aria-hidden="true">#</a> 连接</h2><p>首先用连接窗口创建一个或多个连接。点击&quot;<strong>数据连接</strong>&quot;创建新建连接。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image11.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>在弹出的连接窗口输入需要填写的信息，其中数据连接名称必须大于等于3个字符。然后点击&quot;<strong>连接测试</strong>&quot;，显示&quot;<strong>连接测试通过</strong>&quot;则表示正确连接，点击确定即可新建连接。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image12.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>若要修改连接情况，则可在状态栏右侧点&quot;<strong>编辑</strong>&quot;选项即可修改数据库连接信息。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image13.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="服务器安全性" tabindex="-1"><a class="header-anchor" href="#服务器安全性" aria-hidden="true">#</a> 服务器安全性</h2><p><strong>白名单</strong></p><p>企业版IoTDB可以通过添加白名单列表来设置允许访问IoTDB的IP。使用开源版IoTDB连接Workbench无法使用该功能。</p><p>从导航栏选择&quot;<strong>数据库管理</strong>&quot;-&gt;&quot;<strong>白名单</strong>&quot;可查看已添加的白名单IP列表。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image14.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>点击&quot;<strong>白名单</strong>&quot;可新增白名单IP，点击&quot;<strong>编辑</strong>&quot;/&quot;<strong>删除</strong>&quot;可修改白名单列表的IP信息。</p><p><strong>权限管理</strong></p><p>Workbench提供强大的工具以管理服务器用户帐号和数据库对象的权限。在操作列中点击 &quot;<strong>数据库用户管理</strong>&quot;或 &quot;<strong>数据库角色管理</strong>&quot;来打开用户或角色的对象列表。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image15.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>新增用户</strong>。选择&quot;<strong>数据库用户管理</strong>&quot;-&gt;&quot;<strong>用户账号＋</strong>&quot;可新增用户，按要求填写用户名和密码即可，可以为用户添加角色信息。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image16.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>添加权限</strong>。权限可分为数据管理权限（如对数据进行增删改查）以及权限管理权限（用户、角色的创建与删除，权限的赋予与撤销等）。选择&quot;<strong>数据库用户管理</strong>&quot;-&gt;&quot;<strong>数据管理权限</strong>&quot;-&gt;&quot;<strong>添加权限</strong>&quot;可为用户添加数据管理权限。在已添加的权限处可以选择&quot;<strong>编辑</strong>&quot;或&quot;<strong>删除</strong>&quot;以修改权限信息。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image17.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>弹出的界面可以选择权限作用的粒度以及具体权限内容。注意只有勾选【查询数据】权限和【查看用户】权限，其他权限才能在Workbench中生效查看。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image18.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>选择&quot;<strong>数据库用户管理</strong>&quot;-&gt;&quot;<strong>权限管理权限</strong>&quot;勾选信息窗格中具体的权限信息，点击&quot;保存&quot;可为用户添加权限管理权限。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image19.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>权限预览</strong>。选择&quot;<strong>数据库用户管理</strong>&quot;-&gt;&quot;<strong>数据权限预览</strong>&quot;可预览该用户名下所有的数据权限。注：该功能仅支持企业版。</p><h2 id="数据迁移" tabindex="-1"><a class="header-anchor" href="#数据迁移" aria-hidden="true">#</a> 数据迁移</h2><p>导入导出工具可将CSV格式的文件批量导入或导出IoTDB。</p><p><strong>批量导入</strong></p><p>批量导入功能仅在企业版中支持。在对象窗格中选择要操作的数据库，选择到设备节点，则右侧信息窗格将出现&quot;**设备结构&quot;**信息，点击&quot;<strong>导入物理量</strong>&quot;，下载模板填写物理量信息，再上传该CSV文件即可批量导入物理量。注：当前版本不支持导入对齐物理量。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image20.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>选择&quot;<strong>数据预览</strong>&quot;-&gt;&quot;<strong>批量导入</strong>&quot;则可将符合模板要求的CSV文件数据导入，当前支持导入对齐时间序列。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image21.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>批量导出</strong></p><p>批量导出功能仅在企业版中支持。在对象窗格中选择要操作的数据库，进入设备节点，选择&quot;<strong>设备结构</strong>&quot;-&gt;&quot;<strong>导出物理量</strong>&quot;即可批量导出该实体下的物理量元数据。搜索框内可输入名称/别名、标签名称、标签值进行过滤。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image22.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>选择&quot;<strong>数据预览</strong>&quot;-&gt;&quot;<strong>导出数据</strong>&quot;则可批量导出该实体下的数据。搜索框内可按时间范围、时间间隔和物理量进行过滤。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image23.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="数据预览" tabindex="-1"><a class="header-anchor" href="#数据预览" aria-hidden="true">#</a> 数据预览</h2><p>Workbench提供多层次的数据预览工具。</p><p><strong>数据模型</strong></p><p>在对象窗格中选择要预览的数据连接，点击操作列的&quot;<strong>数据模型</strong>&quot;即可预览数据模型，root被定义为LEVEL=0，Workbench中默认显示到LEVEL=1，点击&quot;<strong>查看更多</strong>&quot;可查看更多层级的数据模型信息。&quot;<strong>查看更多</strong>&quot;功能仅在企业版中支持。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image24.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>存储组信息</strong></p><p>点击操作列的&quot;<strong>存储组信息</strong>&quot;即可预览该数据连接的所有存储组信息，点击&quot;<strong>详情</strong>&quot;可查看该存储组下的实体详情，继续点击实体详情可查看物理量详情。点击&quot;<strong>编辑</strong>&quot;可编辑该存储组的TTL信息。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image25.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="查询" tabindex="-1"><a class="header-anchor" href="#查询" aria-hidden="true">#</a> 查询</h2><p>Workbench提供强大的查询工具，可直接编辑查询文本，保存查询，用于简化查询行任务。</p><p><strong>新建查询</strong></p><p>点击&quot;<strong>连接操作栏</strong>&quot;的&quot;<strong>查询</strong>&quot;，选择要进行操作的数据连接,即可进入查询编辑器。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image26.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>在查询编辑器界面可输入SQL语句，提示框会提示符合条件的关键字。右侧可按要求选择函数或数据进行计算。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image27.png" alt="" width="5.90625in" height="3.125in" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>输入SQL语句后，点击右上角可选择操作，分别是&quot;保存&quot;、&quot;运行&quot;、&quot;暂停&quot;和&quot;删除&quot;。运行结果显示10行每页，默认限制返回结果100行，也可选择取消限制全部展示。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image28.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>查看查询</strong></p><p>已保存的连接可在对象窗格中该数据连接下的&quot;<strong>查询</strong>&quot;下查看。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image29.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="集群管理" tabindex="-1"><a class="header-anchor" href="#集群管理" aria-hidden="true">#</a> 集群管理</h2><p><strong>拓扑管理</strong></p><p>Workbench提供对集群拓扑图的查看。选择&quot;<strong>数据库管理</strong>&quot;-&gt;&quot;<strong>节点管理</strong>&quot;&gt;&quot;<strong>拓扑管理</strong>&quot;可以查看拓扑图。&quot;拓扑管理&quot;功能仅在企业版中支持。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image30.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p>拓扑图显示节点IP、节点类型及端口。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image31.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>节点管理</strong></p><p>Workbench提供对集群节点的管理。选择&quot;<strong>数据库管理</strong>&quot;-&gt;&quot;<strong>节点管理</strong>&quot;可以查看节点状态。可按节点ID或节点类型进行查询。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image32.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>分区管理</strong></p><p>Workbench提供对集群分区的管理。选择&quot;<strong>数据库管理</strong>&quot;-&gt;&quot;<strong>分区管理</strong>&quot;可以查看分区状态。可按分区ID或分区类型进行查询。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image33.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="存储组管理" tabindex="-1"><a class="header-anchor" href="#存储组管理" aria-hidden="true">#</a> 存储组管理</h2><p><strong>新增存储组</strong></p><p>在对象窗格中选择要操作的数据库对象，点击&quot;<strong>新建存储组</strong>&quot;即可创建存储组，存储组名称为必填，存储组名称为必填，正常情况下只能输入字母、数字、下划线以及UNICODE 中文字符如果包含特殊字符，请使用反引号。存活时间选填。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image34.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>删除存储组</strong></p><p>在对象窗格中选择要操作的存储组，在操作列中选择&quot;<strong>编辑</strong>&quot;可修改存储组存活时间，选择&quot;<strong>删除</strong>&quot;可删除存储组。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image35.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="设备及物理量管理" tabindex="-1"><a class="header-anchor" href="#设备及物理量管理" aria-hidden="true">#</a> 设备及物理量管理</h2><p><strong>新建物理量</strong></p><p>在对象窗格中选择要操作的存储组，点击&quot;<strong>新建设备</strong>&quot;，按要求填写信息则可创建该存储组下的物理量。物理量名称名称为必填，正常情况下只能输入字母、数字、下划线以及UNICODE 中文字符如果包含特殊字符，请使用反引号。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image36.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>数据趋势预览</strong></p><p>&quot;数据趋势&quot;功能仅在企业版中支持。在对象窗格中选定存储组，&quot;<strong>数据趋势</strong>&quot;显示该存储组下的物理量趋势图表，单击图表显示详细信息，可选定时间范围查询该区间内的数据，并显示最小值等数据</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image37.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>修改、删除物理量</strong></p><p>在对象窗格中选择要操作的设备 ，点击右侧的&quot;<strong>编辑</strong>&quot;可修改该设备下的物理量信息（别名、标签和属性）。点击&quot;<strong>删除</strong>&quot;则可删除该设备。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image38.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="操作日志" tabindex="-1"><a class="header-anchor" href="#操作日志" aria-hidden="true">#</a> 操作日志</h2><p>&quot;操作日志&quot;提供所有在Workbench上进行的操作记录，可按IP、用户、数据连接、关键词和时间范围进行筛选。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image39.jpeg" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="监控管理" tabindex="-1"><a class="header-anchor" href="#监控管理" aria-hidden="true">#</a> 监控管理</h2><p>Workbench提供&quot;<strong>监控管理</strong>&quot;提供来查看已选择的服务器监控属性。从导航栏选择&quot;<strong>监控管理</strong>&quot;并选择你想要的监控类型。可选&quot;<strong>监控指标</strong>&quot;，&quot;<strong>连接信息</strong>&quot;，&quot;<strong>审计日志</strong>&quot;。</p><p><strong>监控指标</strong></p><p>监控指标可供查看CPU指标、内存指标和存储指标的最新信息。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image40.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>连接信息</strong></p><p>连接信息可供查看连接到Workbench的用户和服务器信息。&quot;连接信息&quot;功能仅在企业版中支持。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image41.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>审计日志</strong></p><p>审计日志显示所有在IoTDB执行的操作，Workbench提供查询接口，可按时间段或用户名进行查询。&quot;审计日志&quot;功能仅在企业版中支持。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image42.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="数据看板" tabindex="-1"><a class="header-anchor" href="#数据看板" aria-hidden="true">#</a> 数据看板</h2><p>数据看板可供创建数据库数据的直观表示，下图为挂载Grafana模板的仪表盘。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image43.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><p><strong>配置</strong></p><p><strong>文件配置</strong></p><p>在文件application-prod.properties中配置看板地址，找到配置项url.dashboard=<a href="https://grafana.com/%EF%BC%8C%E5%A1%AB%E5%86%99grafana" target="_blank" rel="noopener noreferrer">https://grafana.com/，填写grafana<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span></a> URL。</p><p>application-prod.properties源文件内容：</p><div class="language-plain line-numbers-mode" data-ext="plain"><pre class="language-plain"><code># Designate the log configuration file
logging.config=classpath:log4j2.xml

# Set port and context path
server.port=9090
server.servlet.context-path=/api

# The following data source configuration method will cause data loss after the project is repackaged.
# To facilitate testing during development, refer to the application-prod.properties file for configuration during actual project deployment
# sqlite
spring.datasource.url=jdbc:sqlite:./iotdb.db
spring.datasource.driver-class-name=org.sqlite.JDBC
# mysql
#spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#spring.datasource.url=jdbc:mysql://
#spring.datasource.username=
#spring.datasource.password=

# Enable the multipart uploading function
spring.servlet.multipart.enabled=true
spring.servlet.multipart.file-size-threshold=2KB
spring.servlet.multipart.max-file-size=200MB
spring.servlet.multipart.max-request-size=215MB

# All files generated during CSV import and export are stored in this folder
file.temp-dir=./tempFile

spring.messages.basename=messages

# enable open audit in iotdb
enableIotdbAudit = false
# enable open audit in workbench:
enableWorkbenchAudit = true
# timechodb  config server rpc port
configServerPort=8867
# dashboard url
url.dashboard=https://grafana.com/
</code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p><strong>URL获取</strong></p><p>登录Grafan面板，点击分享按钮，在弹出的窗口选择&quot;<strong>Link</strong>&quot;，复制&quot;<strong>Link URL</strong>&quot;即可。</p><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image44.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><h2 id="q-a" tabindex="-1"><a class="header-anchor" href="#q-a" aria-hidden="true">#</a> Q&amp;A</h2><ol><li>如果遇到以下情况，请尝试退出&quot;无痕模式&quot;或者更换浏览器。</li></ol><figure><img src="https://alioss.timecho.com/docs/img/UserGuide/Ecosystem-Integration/Workbench/image45.png" alt="" tabindex="0" loading="lazy"><figcaption></figcaption></figure><ol start="2"><li><p>如果看不到监控信息，需要开启IoTDB的Metric。</p></li><li><p>双活配置发生变化时需建议重新建立连接。</p></li></ol></div><!----><footer class="page-meta"><div class="meta-item edit-link"><a href="https://github.com/apache/iotdb/edit/master/docs/zh/UserGuide/Ecosystem-Integration/Workbench.md" rel="noopener noreferrer" target="_blank" aria-label="发现错误？在 GitHub 上编辑此页" class="nav-link label"><!--[--><svg xmlns="http://www.w3.org/2000/svg" class="icon edit-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="edit icon"><path d="M430.818 653.65a60.46 60.46 0 0 1-50.96-93.281l71.69-114.012 7.773-10.365L816.038 80.138A60.46 60.46 0 0 1 859.225 62a60.46 60.46 0 0 1 43.186 18.138l43.186 43.186a60.46 60.46 0 0 1 0 86.373L588.879 565.55l-8.637 8.637-117.466 68.234a60.46 60.46 0 0 1-31.958 11.229z"></path><path d="M728.802 962H252.891A190.883 190.883 0 0 1 62.008 771.98V296.934a190.883 190.883 0 0 1 190.883-192.61h267.754a60.46 60.46 0 0 1 0 120.92H252.891a69.962 69.962 0 0 0-69.098 69.099V771.98a69.962 69.962 0 0 0 69.098 69.098h475.911A69.962 69.962 0 0 0 797.9 771.98V503.363a60.46 60.46 0 1 1 120.922 0V771.98A190.883 190.883 0 0 1 728.802 962z"></path></svg><!--]-->发现错误？在 GitHub 上编辑此页<span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!----></a></div><div class="meta-item git-info"><!----><!----></div></footer><nav class="page-nav"><a href="/zh/UserGuide/Master/Ecosystem-Integration/NiFi-IoTDB.html" class="nav-link prev" aria-label="NiFi-IoTDB"><div class="hint"><span class="arrow start"></span>上一页</div><div class="link"><!---->NiFi-IoTDB</div></a><!----></nav><!----><!----><!--]--></main><!--]--><footer style="padding-bottom:2rem;"><span id="doc-version" style="display:none;">master</span><p style="text-align:center;color:#909399;font-size:12px;margin:0 30px;">Copyright © 2023 The Apache Software Foundation.<br> Apache and the Apache feather logo are trademarks of The Apache Software Foundation</p><p style="text-align:center;margin-top:10px;color:#909399;font-size:12px;margin:0 30px;"><strong>Have a question?</strong> Connect with us on QQ, WeChat, or Slack. <a href="https://github.com/apache/iotdb/issues/1995">Join the community</a> now.</p><p style="text-align:center;margin-top:10px;color:#909399;font-size:12px;margin:0 30px;"> We use <a href="https://analytics.google.com">Google Analytics</a> to collect anonymous, aggregated usage information. </p></footer></div><!--]--><!--]--><!----><!--]--></div>
    <script type="module" src="/assets/app-bf7ef9dd.js" defer></script>
  </body>
</html>