| "use strict";(self.webpackChunkhertzbeat=self.webpackChunkhertzbeat||[]).push([[94395],{15680:(e,t,r)=>{r.d(t,{xA:()=>s,yg:()=>d});var a=r(96540);function n(e,t,r){return t in e?Object.defineProperty(e,t,{value:r,enumerable:!0,configurable:!0,writable:!0}):e[t]=r,e}function l(e,t){var r=Object.keys(e);if(Object.getOwnPropertySymbols){var a=Object.getOwnPropertySymbols(e);t&&(a=a.filter((function(t){return Object.getOwnPropertyDescriptor(e,t).enumerable}))),r.push.apply(r,a)}return r}function o(e){for(var t=1;t<arguments.length;t++){var r=null!=arguments[t]?arguments[t]:{};t%2?l(Object(r),!0).forEach((function(t){n(e,t,r[t])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(r)):l(Object(r)).forEach((function(t){Object.defineProperty(e,t,Object.getOwnPropertyDescriptor(r,t))}))}return e}function i(e,t){if(null==e)return{};var r,a,n=function(e,t){if(null==e)return{};var r,a,n={},l=Object.keys(e);for(a=0;a<l.length;a++)r=l[a],t.indexOf(r)>=0||(n[r]=e[r]);return n}(e,t);if(Object.getOwnPropertySymbols){var l=Object.getOwnPropertySymbols(e);for(a=0;a<l.length;a++)r=l[a],t.indexOf(r)>=0||Object.prototype.propertyIsEnumerable.call(e,r)&&(n[r]=e[r])}return n}var c=a.createContext({}),p=function(e){var t=a.useContext(c),r=t;return e&&(r="function"==typeof e?e(t):o(o({},t),e)),r},s=function(e){var t=p(e.components);return a.createElement(c.Provider,{value:t},e.children)},y={inlineCode:"code",wrapper:function(e){var t=e.children;return a.createElement(a.Fragment,{},t)}},m=a.forwardRef((function(e,t){var r=e.components,n=e.mdxType,l=e.originalType,c=e.parentName,s=i(e,["components","mdxType","originalType","parentName"]),m=p(r),d=n,g=m["".concat(c,".").concat(d)]||m[d]||y[d]||l;return r?a.createElement(g,o(o({ref:t},s),{},{components:r})):a.createElement(g,o({ref:t},s))}));function d(e,t){var r=arguments,n=t&&t.mdxType;if("string"==typeof e||n){var l=r.length,o=new Array(l);o[0]=m;var i={};for(var c in t)hasOwnProperty.call(t,c)&&(i[c]=t[c]);i.originalType=e,i.mdxType="string"==typeof e?e:n,o[1]=i;for(var p=2;p<l;p++)o[p]=r[p];return a.createElement.apply(null,o)}return a.createElement.apply(null,r)}m.displayName="MDXCreateElement"},71581:(e,t,r)=>{r.r(t),r.d(t,{assets:()=>c,contentTitle:()=>o,default:()=>y,frontMatter:()=>l,metadata:()=>i,toc:()=>p});var a=r(58168),n=(r(96540),r(15680));const l={id:"mysql-change",title:"\u4f9d\u8d56\u7684\u5173\u7cfb\u578b\u6570\u636e\u5e93 H2 \u5207\u6362 \u4e3aMYSQL",sidebar_label:"\u4f7f\u7528Mysql\u66ff\u6362\u5185\u7f6eH2\u6570\u636e\u5e93(\u53ef\u9009)"},o=void 0,i={unversionedId:"start/mysql-change",id:"version-v1.1.x/start/mysql-change",title:"\u4f9d\u8d56\u7684\u5173\u7cfb\u578b\u6570\u636e\u5e93 H2 \u5207\u6362 \u4e3aMYSQL",description:"MYSQL\u662f\u4e00\u6b3e\u503c\u5f97\u4fe1\u8d56\u7684\u5173\u7cfb\u578b\u6570\u636e\u5e93\uff0cHertzBeat\u9664\u4e86\u652f\u6301\u4f7f\u7528\u9ed8\u8ba4\u5185\u7f6e\u7684H2\u6570\u636e\u5e93\u5916\uff0c\u8fd8\u53ef\u4ee5\u5207\u6362\u4e3a\u4f7f\u7528MYSQL\u5b58\u50a8\u76d1\u63a7\u4fe1\u606f\uff0c\u544a\u8b66\u4fe1\u606f\uff0c\u914d\u7f6e\u4fe1\u606f\u7b49\u7ed3\u6784\u5316\u5173\u7cfb\u6570\u636e\u3002",source:"@site/versioned_docs/version-v1.1.x/start/mysql-change.md",sourceDirName:"start",slug:"/start/mysql-change",permalink:"/zh-cn/docs/v1.1.x/start/mysql-change",draft:!1,editUrl:"https://github.com/apache/hertzbeat/edit/master/home/versioned_docs/version-v1.1.x/start/mysql-change.md",tags:[],version:"v1.1.x",frontMatter:{id:"mysql-change",title:"\u4f9d\u8d56\u7684\u5173\u7cfb\u578b\u6570\u636e\u5e93 H2 \u5207\u6362 \u4e3aMYSQL",sidebar_label:"\u4f7f\u7528Mysql\u66ff\u6362\u5185\u7f6eH2\u6570\u636e\u5e93(\u53ef\u9009)"},sidebar:"docs",previous:{title:"\u4f7f\u7528TDengine\u5b58\u50a8\u6307\u6807\u6570\u636e(\u53ef\u9009)",permalink:"/zh-cn/docs/v1.1.x/start/tdengine-init"},next:{title:"\u914d\u7f6e\u4fee\u6539\u8d26\u6237\u5bc6\u7801(\u53ef\u9009)",permalink:"/zh-cn/docs/v1.1.x/start/account-modify"}},c={},p=[{value:"\u901a\u8fc7Docker\u65b9\u5f0f\u5b89\u88c5MYSQL",id:"\u901a\u8fc7docker\u65b9\u5f0f\u5b89\u88c5mysql",level:3},{value:"\u6570\u636e\u5e93\u521b\u5efa",id:"\u6570\u636e\u5e93\u521b\u5efa",level:3},{value:"\u4fee\u6539hertzbeat\u7684\u914d\u7f6e\u6587\u4ef6application.yml\u5207\u6362\u6570\u636e\u6e90",id:"\u4fee\u6539hertzbeat\u7684\u914d\u7f6e\u6587\u4ef6applicationyml\u5207\u6362\u6570\u636e\u6e90",level:3}],s={toc:p};function y(e){let{components:t,...r}=e;return(0,n.yg)("wrapper",(0,a.A)({},s,r,{components:t,mdxType:"MDXLayout"}),(0,n.yg)("p",null,"MYSQL\u662f\u4e00\u6b3e\u503c\u5f97\u4fe1\u8d56\u7684\u5173\u7cfb\u578b\u6570\u636e\u5e93\uff0cHertzBeat\u9664\u4e86\u652f\u6301\u4f7f\u7528\u9ed8\u8ba4\u5185\u7f6e\u7684H2\u6570\u636e\u5e93\u5916\uff0c\u8fd8\u53ef\u4ee5\u5207\u6362\u4e3a\u4f7f\u7528MYSQL\u5b58\u50a8\u76d1\u63a7\u4fe1\u606f\uff0c\u544a\u8b66\u4fe1\u606f\uff0c\u914d\u7f6e\u4fe1\u606f\u7b49\u7ed3\u6784\u5316\u5173\u7cfb\u6570\u636e\u3002 "),(0,n.yg)("p",null,"\u6ce8\u610f\u26a0\ufe0f \u4f7f\u7528\u5916\u7f6eMysql\u6570\u636e\u5e93\u66ff\u6362\u5185\u7f6eH2\u6570\u636e\u5e93\u4e3a\u53ef\u9009\u9879\uff0c\u4f46\u5efa\u8bae\u751f\u4ea7\u73af\u5883\u914d\u7f6e\uff0c\u4ee5\u63d0\u4f9b\u66f4\u597d\u7684\u6027\u80fd"),(0,n.yg)("blockquote",null,(0,n.yg)("p",{parentName:"blockquote"},"\u5982\u679c\u60a8\u5df2\u6709MYSQL\u73af\u5883\uff0c\u53ef\u76f4\u63a5\u8df3\u5230\u6570\u636e\u5e93\u521b\u5efa\u90a3\u4e00\u6b65\u3002 ")),(0,n.yg)("h3",{id:"\u901a\u8fc7docker\u65b9\u5f0f\u5b89\u88c5mysql"},"\u901a\u8fc7Docker\u65b9\u5f0f\u5b89\u88c5MYSQL"),(0,n.yg)("ol",null,(0,n.yg)("li",{parentName:"ol"},"\u4e0b\u8f7d\u5b89\u88c5Docker\u73af\u5883",(0,n.yg)("br",{parentName:"li"}),"Docker \u5de5\u5177\u81ea\u8eab\u7684\u4e0b\u8f7d\u8bf7\u53c2\u8003 ",(0,n.yg)("a",{parentName:"li",href:"https://docs.docker.com/get-docker/"},"Docker\u5b98\u7f51\u6587\u6863"),"\u3002\n\u5b89\u88c5\u5b8c\u6bd5\u540e\u7ec8\u7aef\u67e5\u770bDocker\u7248\u672c\u662f\u5426\u6b63\u5e38\u8f93\u51fa\u3002 ",(0,n.yg)("pre",{parentName:"li"},(0,n.yg)("code",{parentName:"pre"},"$ docker -v\nDocker version 20.10.12, build e91ed57\n"))),(0,n.yg)("li",{parentName:"ol"},"Docker\u5b89\u88c5MYSQl ",(0,n.yg)("pre",{parentName:"li"},(0,n.yg)("code",{parentName:"pre"},"$ docker run -d --name mysql \\\n-p 3306:3306 \\\n-v /opt/data:/var/lib/mysql \\\n-e MYSQL_ROOT_PASSWORD=123456 \\\n--restart=always \\\nmysql:5.7\n")),(0,n.yg)("inlineCode",{parentName:"li"},"-v /opt/data:/var/lib/mysql")," \u4e3amysql\u6570\u636e\u76ee\u5f55\u672c\u5730\u6301\u4e45\u5316\u6302\u8f7d\uff0c\u9700\u5c06",(0,n.yg)("inlineCode",{parentName:"li"},"/opt/data"),"\u66ff\u6362\u4e3a\u5b9e\u9645\u672c\u5730\u5b58\u5728\u7684\u76ee\u5f55",(0,n.yg)("br",{parentName:"li"}),"\u4f7f\u7528",(0,n.yg)("inlineCode",{parentName:"li"},"$ docker ps"),"\u67e5\u770b\u6570\u636e\u5e93\u662f\u5426\u542f\u52a8\u6210\u529f")),(0,n.yg)("h3",{id:"\u6570\u636e\u5e93\u521b\u5efa"},"\u6570\u636e\u5e93\u521b\u5efa"),(0,n.yg)("ol",null,(0,n.yg)("li",{parentName:"ol"},"\u8fdb\u5165MYSQL\u6216\u4f7f\u7528\u5ba2\u6237\u7aef\u8fde\u63a5MYSQL\u670d\u52a1",(0,n.yg)("br",{parentName:"li"}),(0,n.yg)("inlineCode",{parentName:"li"},"mysql -uroot -p123456")," "),(0,n.yg)("li",{parentName:"ol"},"\u521b\u5efa\u540d\u79f0\u4e3ahertzbeat\u7684\u6570\u636e\u5e93",(0,n.yg)("br",{parentName:"li"}),(0,n.yg)("inlineCode",{parentName:"li"},"create database hertzbeat default charset utf8mb4 collate utf8mb4_general_ci;")),(0,n.yg)("li",{parentName:"ol"},"\u67e5\u770bhertzbeat\u6570\u636e\u5e93\u662f\u5426\u521b\u5efa\u6210\u529f\n",(0,n.yg)("inlineCode",{parentName:"li"},"show databases;"))),(0,n.yg)("h3",{id:"\u4fee\u6539hertzbeat\u7684\u914d\u7f6e\u6587\u4ef6applicationyml\u5207\u6362\u6570\u636e\u6e90"},"\u4fee\u6539hertzbeat\u7684\u914d\u7f6e\u6587\u4ef6application.yml\u5207\u6362\u6570\u636e\u6e90"),(0,n.yg)("ol",null,(0,n.yg)("li",{parentName:"ol"},"\u914d\u7f6eHertzBeat\u7684\u914d\u7f6e\u6587\u4ef6\n\u4fee\u6539\u4f4d\u4e8e ",(0,n.yg)("inlineCode",{parentName:"li"},"hertzbeat/config/application.yml")," \u7684\u914d\u7f6e\u6587\u4ef6",(0,n.yg)("br",{parentName:"li"}),"\u6ce8\u610f\u26a0\ufe0fdocker\u5bb9\u5668\u65b9\u5f0f\u9700\u8981\u5c06application.yml\u6587\u4ef6\u6302\u8f7d\u5230\u4e3b\u673a\u672c\u5730,\u5b89\u88c5\u5305\u65b9\u5f0f\u89e3\u538b\u4fee\u6539\u4f4d\u4e8e ",(0,n.yg)("inlineCode",{parentName:"li"},"hertzbeat/config/application.yml")," \u5373\u53ef\n\u66ff\u6362\u91cc\u9762\u7684",(0,n.yg)("inlineCode",{parentName:"li"},"spring.database"),"\u6570\u636e\u6e90\u53c2\u6570\uff0cIP\u7aef\u53e3\u8d26\u6237\u5bc6\u7801\u9a71\u52a8",(0,n.yg)("br",{parentName:"li"}),"\u26a0\ufe0f\u6ce8\u610f",(0,n.yg)("inlineCode",{parentName:"li"},"application.yml"),"\u6587\u4ef6\u5185\u5bb9\u9700\u5b8c\u6574\uff0c\u9664\u4e0b\u65b9\u4fee\u6539\u5185\u5bb9\u5916\u5176\u4ed6\u53c2\u6570\u9700\u4fdd\u7559\uff0c\u5b8c\u6574\u5185\u5bb9\u89c1",(0,n.yg)("a",{parentName:"li",href:"https://gitee.com/dromara/hertzbeat/raw/master/script/application.yml"},"/script/application.yml")," ")),(0,n.yg)("p",null,"\u9700\u4fee\u6539\u90e8\u5206\u539f\u53c2\u6570: "),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre",className:"language-yaml"},"spring:\n datasource:\n driver-class-name: org.h2.Driver\n username: sa\n password: 123456\n url: jdbc:h2:./data/hertzbeat;MODE=MYSQL\n")),(0,n.yg)("p",null,"\u5177\u4f53\u66ff\u6362\u53c2\u6570\u5982\u4e0b,\u9700\u6839\u636emysql\u73af\u5883\u914d\u7f6e\u8d26\u6237\u5bc6\u7801IP: "),(0,n.yg)("pre",null,(0,n.yg)("code",{parentName:"pre",className:"language-yaml"},"spring:\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n username: root\n password: 123456\n url: jdbc:mysql://localhost:3306/hertzbeat?useUnicode=true&characterEncoding=utf-8&useSSL=false\n")),(0,n.yg)("p",null,(0,n.yg)("strong",{parentName:"p"},"\u542f\u52a8 HertzBeat \u6d4f\u89c8\u5668\u8bbf\u95ee http://ip:1157/ \u5f00\u59cb\u4f7f\u7528HertzBeat\u8fdb\u884c\u76d1\u63a7\u544a\u8b66\uff0c\u9ed8\u8ba4\u8d26\u6237\u5bc6\u7801 admin/hertzbeat")))}y.isMDXComponent=!0}}]); |