{"id":9321,"date":"2023-03-15T11:46:33","date_gmt":"2023-03-15T03:46:33","guid":{"rendered":"https:\/\/www.hefeiyu.com\/?p=9321"},"modified":"2023-03-15T11:46:33","modified_gmt":"2023-03-15T03:46:33","slug":"ubuntu%e4%b8%8b%e5%ae%89%e8%a3%85wiki%e8%bd%af%e4%bb%b6confluence%e6%b5%81%e7%a8%8b","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=9321","title":{"rendered":"Ubuntu\u4e0b\u5b89\u88c5WIKI\u8f6f\u4ef6confluence\u6d41\u7a0b"},"content":{"rendered":"<p>WIKI\u8f6f\u4ef6confluence\u5b89\u88c5\u6d41\u7a0b<\/p>\n<ul>\n<li>\u6d4b\u8bd5\u73af\u5883\uff0cUbuntu \u6d4b\u8bd5\u7248\u672c 20.10\u3002\u5f00\u59cb\u524d\uff0c\u5148\u66f4\u65b0\u8f6f\u4ef6\u5217\u8868\u3002<\/li>\n<\/ul>\n<ol>\n<li>sudo apt-get update \u8fd9\u4e2a\u547d\u4ee4\u4f1a\u8bbf\u95ee\u6e90\u5217\u8868\u4e2d\u7684\u6bcf\u4e2a\u7f51\u5740\uff0c\u5e76\u8bfb\u53d6\u8f6f\u4ef6\u5217\u8868<\/li>\n<li>sudo apt-get upgrade \u8fd9\u4e2a\u547d\u4ee4\u4f1a\u4e0e\u521a\u624d\u4e0b\u8f7d\u7684\u8f6f\u4ef6\u5217\u8868\u91cc\u9762\u7684\u8f6f\u4ef6\u8fdb\u884c\u5bf9\u6bd4\uff0c\u9700\u8981\u66f4\u65b0\u9ad8\u7248\u672c\u7684\u8f6f\u4ef6 \u5c31\u4f1a\u4e0b\u8f7d\u4e0e\u5b89\u88c5<\/li>\n<li>\u547d\u4ee4\u884c\u4e2d\u8f93\u5165java\uff0c\u5982\u679c\u6ca1\u6709\u5b89\u88c5\uff0c\u5373\u7cfb\u7edf\u4f1a\u63d0\u793a\u53ef\u5b89\u88c5\u5217\u8868<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"729\" height=\"325\" class=\"wp-image-9322\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file.png\" alt=\"\u6587\u672c\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" \/><\/li>\n<li>\u672c\u4f8b\u9009\u62e9java8\uff0c\u76f4\u63a5\u53ef\u4ee5\u590d\u5236\u56fe\u4e2djdk8\u7684\u90a3\u884c\u547d\u4ee4\u6267\u884c\u4e00\u6b21\u5c31\u884c\u3002<\/li>\n<li>\u5f53\u7136\u4f60\u4e5f\u53ef\u4ee5\u53bb\u522b\u7684\u5730\u65b9\u4e0b\u8f7d\u597dJDK\u4e0a\u4f20\u518d\u5b89\u88c5\u3002<\/li>\n<li>\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u9996\u5148 java -version , \u8f93\u51fa\u4fe1\u606f\u663e\u793a\u786e\u5b9e\u5df2\u7ecf\u5b89\u88c5\u4e86java<\/li>\n<li>\u914d\u7f6e\u4f7f\u7528\uff1a\u547d\u4ee4\u6253\u5f00\/etc\/profile\u6587\u4ef6sudo vim \/etc\/profile,\u5728\u672b\u5c3e\u6dfb\u52a0\u4ee5\u4e0b\u51e0\u884c\u6587\u5b57\uff1a<\/li>\n<\/ol>\n<p>#set java env<\/p>\n<p>export JAVA_HOME=\/usr\/lib\/jdk\/jdk1.8.0_202<\/p>\n<p>export JRE_HOME=${JAVA_HOME}\/jre<\/p>\n<p>export CLASSPATH=.:${JAVA_HOME}\/lib:${JRE_HOME}\/lib<\/p>\n<p>export PATH=${JAVA_HOME}\/bin:$PATH<\/p>\n<ol>\n<li>\u5176\u4e2d\u7684\/usr\/lib\/jdk\/jdk1.8.0_202 \u5c31\u662f\u4f60\u7684\u5b89\u88c5\u8def\u5f84\u3002\u5047\u5982\u4f60\u4e0d\u77e5\u9053\u5b89\u88c5\u8def\u5f84\uff0c\u53ef\u4ee5\u7528\u81ea\u884c\u767e\u5ea6Ubuntu JAVA\u5b89\u88c5\u8def\u5f84\u3002<\/li>\n<li>\u4f7f\u73af\u5883\u53d8\u91cf\u751f\u6548\uff1asource ~\/.bashrc<\/li>\n<\/ol>\n<ul>\n<li>\u7531\u4e8eConfluence\u4f9d\u8d56\u4e8eJava\uff0c\u6240\u4ee5\u8981\u4e8b\u5148\u5b89\u88c5Java \u548c \u6570\u636e\u5e93\uff0c\u8fd9\u91cc\u6570\u636e\u5e93\u91c7\u7528Mysql\u3002<\/li>\n<\/ul>\n<p>\u4e0a\u9762\u5df2\u7ecf\u5b89\u88c5\u4e86java\uff0c\u73b0\u5728\u5b89\u88c5Mysql\u3002<\/p>\n<ol>\n<li>sudo apt-get install mysql-server<\/li>\n<li>\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u8fdb\u5165mysql\uff1amysql -u root -p<\/li>\n<li>\u5982\u679c\u6b64\u5904\u767b\u9646\u4e0d\u4e86\uff0c\u5f88\u53ef\u80fd\u662f\u4f60\u5b89\u88c5\u7684MYSQL\u7248\u672c\u592a\u9ad8\u4e86\u3002\u6559\u7a0b\u6700\u540e\u9762\u6709\u8865\u5145\u89e3\u51b3\u65b9\u6848\u3002<\/li>\n<li>\u521b\u5efaConfluence\u5bf9\u5e94\u6570\u636e\u5e93\u5e76\u6388\u6743\uff1a<\/li>\n<\/ol>\n<p>mysql&gt; create database confluence character SET utf8 COLLATE utf8_bin;<\/p>\n<p>mysql&gt; SET GLOBAL tx_isolation=&#8217;READ-COMMITTED&#8217;; \/\/\u6709\u7684\u7248\u672c\u4e0d\u652f\u6301\u8fd9\u4e2a\u547d\u4ee4\uff0c\u6362\u8fd9\u4e2a\uff1aSET GLOBAL transaction_isolation=&#8217;READ-COMMITTED&#8217;;<\/p>\n<p>mysql&gt; create user &#8216;confluence&#8217;@&#8217;%&#8217; identified by &#8216;Qq123456&#8217;;<\/p>\n<p>mysql&gt; GRANT ALL PRIVILEGES ON confluence.* TO &#8216;confluence&#8217;@&#8217;%&#8217; WITH GRANT OPTION;<\/p>\n<p>mysql&gt; FLUSH PRIVILEGES;<\/p>\n<ol>\n<li>Mysql \u5b89\u88c5\u5b8c\u6210\u3002<\/li>\n<\/ol>\n<ul>\n<li>\u63a5\u4e0b\u6765\u5b89\u88c5confluence<\/li>\n<li>\u5230\u5b98\u7f51\u4e0b\u8f7dconfluence\uff1ahttps:\/\/www.atlassian.com\/software\/confluence\/download<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"1038\" height=\"738\" class=\"wp-image-9323\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/teams.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u5e94\u7528\u7a0b\u5e8f, Teams\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/teams.png 1038w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/teams-768x546.png 768w\" sizes=\"auto, (max-width: 1038px) 100vw, 1038px\" \/><\/li>\n<li>\u901a\u8fc7FTP\uff0cSSH\u7b49\u5de5\u5177\u4e0a\u4f20\u5230\u7279\u5b9a\u76ee\u5f55\u3002\u6bd4\u5982\/opt\u4e2d\uff0c\u518d\u8fdb\u5165\u76ee\u5f55\uff1acd \/opt<\/li>\n<li>\u6dfb\u52a0\u53ef\u6267\u884c\u6743\u9650\uff1asudo chmod +x atlassian-confluence-7.9.3-x64.bin<\/li>\n<li>\u5b89\u88c5\uff1asudo .\/atlassian-confluence-6.15.2-x64.bin<\/li>\n<li>\u5b89\u88c5\u8fc7\u7a0b <img loading=\"lazy\" decoding=\"async\" width=\"756\" height=\"741\" class=\"wp-image-9324\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-1.png\" alt=\"\u6587\u672c\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" \/><\/li>\n<li>\u6ce8\u610f\u8f93\u5165o\uff0c1\uff0ci Y\u4e09\u4e2a\u547d\u4ee4\u3002<\/li>\n<li>\u670d\u52a1\u542f\u52a8\u540e\u5728\u672c\u5730\u6d4f\u89c8\u5668\u901a\u8fc7localhost:8090\u53ef\u4ee5\u8bbf\u95eeConfluence<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"1162\" height=\"701\" class=\"wp-image-9325\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/teams-1.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u5e94\u7528\u7a0b\u5e8f, Teams\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/teams-1.png 1162w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/teams-1-768x463.png 768w\" sizes=\"auto, (max-width: 1162px) 100vw, 1162px\" \/><\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"1283\" height=\"590\" class=\"wp-image-9326\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-2.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u5e94\u7528\u7a0b\u5e8f\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-2.png 1283w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-2-768x353.png 768w\" sizes=\"auto, (max-width: 1283px) 100vw, 1283px\" \/><\/li>\n<li>\u5148\u8fdb\u5165\u76ee\u5f55 cd \/opt\/atlassian\/confluence\/bin\uff0c\u6267\u884c\u547d\u4ee4\uff1asudo .\/shutdown.sh \u5c06\u7cfb\u7edf\u5173\u95ed\u3002 <img loading=\"lazy\" decoding=\"async\" width=\"813\" height=\"190\" class=\"wp-image-9327\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-3.png\" alt=\"\u6587\u672c\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-3.png 813w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-3-768x179.png 768w\" sizes=\"auto, (max-width: 813px) 100vw, 813px\" \/><\/li>\n<li>\u8fdb\u5165\u5b89\u88c5\u76ee\u5f55\u4e0b\uff1acd \/opt\/atlassian\/confluence\/confluence\/WEB-INF\/lib\/\uff0c\u628a \u201catlassian-extras-decoder-v2-3.4.1.jar\u201d\u8fd9\u4e2a\u6587\u4ef6\uff08\u7248\u672c\u4e0d\u540c\uff0c\u540d\u5b57\u4e0d\u540c\uff0c\u683c\u5f0f\u662fatlassian-extras-decoder-vx.x.x.x.jar\uff09\u4e0b\u8f7d\u5230windows\u672c\u673a\u3002\u5e76\u5c06\u8fd9\u4e2a\u6587\u4ef6\u540d\u6539\u4e3a atlassian-extras-2.4.jar\u3002\u7834\u89e3\u5de5\u5177\u53ea\u8bc6\u522b\u8fd9\u4e2a\u6587\u4ef6\u540d<\/li>\n<li>\u4e0b\u8f7d\u7834\u89e3\u6587\u4ef6\uff0c\u5982\u679c\u94fe\u63a5\u5931\u6548\u4e86\u81ea\u884c\u767e\u5ea6 confluence \u7834\u89e3\u3002 http:\/\/wiki.wuyijun.cn\/download\/attachments\/2327034\/51CTO%E4%B8%8B%E8%BD%BD-Confluence.zip<\/li>\n<li>\u89e3\u538b\u7f29\u6b64\u6587\u4ef6\u5939\uff0cdos\u547d\u4ee4\u884c\u8fdb\u5165\u6b64\u6587\u4ef6\u5939\uff0c\u6bd4\u5982\u6211\u7684\u662fD:\\BaiduNetdiskDownload\\confluence\uff0c\u6267\u884c\u89e3\u538b\uff0c\u540c\u65f6\u5c06\u5df2\u7ecf\u6539\u540d\u6210atlassian-extras-2.4.jar\u7684\u6587\u4ef6\u4e5f\u590d\u5236\u8fdb\u6765\u3002\u89e3\u538b\u540e\u76ee\u5f55\u5982\u4e0b\uff1a<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"617\" height=\"302\" class=\"wp-image-9328\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-4.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" \/><\/li>\n<li>\u6253\u5f00CMD\u7684DOS\u753b\u9762\uff0c\u8fdb\u5165\u8fd9\u4e2a\u76ee\u5f55cd D: \u518dcd D:\\BaiduNetdiskDownload\\confluence \uff0c\u6267\u884c java -jar confluence_keygen.jar \u8fd0\u884c\u7834\u89e3\u6587\u4ef6<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"728\" height=\"248\" class=\"wp-image-9329\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-5.png\" alt=\"\u6587\u672c\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" \/><\/li>\n<li>\u5982\u679c\u4f60\u7684\u7cfb\u7edf\u62a5\u201c\u7cfb\u7edf\u627e\u4e0d\u5230\u6587\u4ef6\u201d \uff0c\u90a3\u4f60\u9700\u8981\u5728\u672c\u673a\u5b89\u88c5JDK\u3002\u5177\u4f53\u81ea\u884c\u767e\u5ea6<\/li>\n<li>\u6b63\u5e38\u8fd0\u884c\u540e\u51fa\u73b0\u4e0b\u56fe\uff1a<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"467\" height=\"341\" class=\"wp-image-9330\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-6.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f, \u7535\u5b50\u90ae\u4ef6\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" \/><\/li>\n<li>\u586b\u5165 name \uff0cserver id \u5904\u8f93\u5165confluence \u670d\u52a1\u5668ID\uff0c\u70b9\u51fb.patch\uff0c\u9009\u62e9\u521a\u624d\u6539\u540d\u5b57\u7684atlassian-extras-2.4.jar\u6587\u4ef6\uff0c\u70b9\u51fb \u201cgen\u201d \u751f\u6210key\u3002\u6ce8\u610f\uff1apath\u524d\u5148\u5220\u9664atlassian-extras-2.4.bak\u6587\u4ef6\u5426\u5219path\u5931\u8d25 <img loading=\"lazy\" decoding=\"async\" width=\"451\" height=\"362\" class=\"wp-image-9331\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-7.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f, \u7535\u5b50\u90ae\u4ef6\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" \/><\/li>\n<li>\u8bb0\u5f55\u4e0bKey\u503c\uff0c\u7b49\u4f1a\u7528\u5230\u3002<\/li>\n<li>\u4e0d\u8981\u5173\u6389\u7834\u89e3\u7684\u7a97\u53e3\uff0c\u5c06 \u201catlassian-extras-2.4.jar\u201d \u6587\u4ef6\u540d\u6539\u56de\u539f\u6765\u7684 \u201catlassian-extras-decoder-v2-3.4.1.jar\u201d<\/li>\n<li>\u5c06 \u201catlassian-extras-decoder-v2-3.4.1.jar\u201d \u6587\u4ef6\u4e0a\u4f20\u56de\u670d\u52a1\u5668\u539f\u4f4d\u7f6e\u3002\u4e0a\u4f20\u524d\u5148\u628a\u539f\u6587\u4ef6\u505a\u4e2a\u5907\u4efd\u3002<\/li>\n<li>sudo mv atlassian-extras-decoder-v2-3.4.1.jar atlassian-extras-decoder-v2-3.4.1.jar.bk<\/li>\n<li>\u4e0a\u4f20\u6587\u4ef6\u5230\/opt\/atlassian\/confluence\/confluence\/WEB-INF\/lib\/\u4e0b\u9762<\/li>\n<li>\u4e0b\u9762\u662f\u53e6\u5916\u4e00\u6b65\uff0c\u8981\u8fde\u63a5Mysql\uff0c\u9700\u8981\u4e0b\u8f7d\u4e00\u4e2a\u8fde\u63a5\u5668\u3002<\/li>\n<li>\u4e0b\u8f7d\u9a71\u52a8\uff1a<a href=\"https:\/\/confluence.atlassian.com\/doc\/database-jdbc-drivers-171742.html\">https:\/\/confluence.atlassian.com\/doc\/database-jdbc-drivers-171742.html<\/a><\/li>\n<li>\u6b64\u5904\u6709\u4e24\u4e2a\u9700\u8981\u6ce8\u610f\u7684\u70b9\uff1a<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"862\" height=\"579\" class=\"wp-image-9332\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/word.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f, Word\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/word.png 862w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/word-768x516.png 768w\" sizes=\"auto, (max-width: 862px) 100vw, 862px\" \/><\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"1150\" height=\"440\" class=\"wp-image-9333\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-8.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f, \u7535\u5b50\u90ae\u4ef6\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-8.png 1150w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-8-768x294.png 768w\" sizes=\"auto, (max-width: 1150px) 100vw, 1150px\" \/><\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"933\" height=\"564\" class=\"wp-image-9334\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-9.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f, \u7535\u5b50\u90ae\u4ef6, \u7f51\u7ad9\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-9.png 933w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-9-768x464.png 768w\" sizes=\"auto, (max-width: 933px) 100vw, 933px\" \/><\/li>\n<li>\u89e3\u538b\u540e\u5c06mysql-connector-java-5.1.48-bin.jar\u62f7\u8d1d\u5230\/opt\/atlassian\/confluence\/confluence\/WEB-INF\/lib\u6587\u4ef6\u5939\u4e0b<\/li>\n<li>\u51c6\u5907\u5b8c\u6bd5\uff0c\u5f00\u59cb\u542f\u52a8\u7cfb\u7edf\u3002\u8fdb\u5165\u76ee\u5f55 cd \/opt\/atlassian\/confluence\/bin\uff0c\u6267\u884c\u547d\u4ee4\uff1asudo .\/ startup.sh \u5c06\u7cfb\u7edf\u6253\u5f00\u3002<\/li>\n<li>\u6d4f\u89c8\u5668\u8bbf\u95eehttp:\/\/ip:8090\/\u5f00\u59cb\u5b89\u88c5<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"861\" height=\"673\" class=\"wp-image-9335\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-10.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f, \u7535\u5b50\u90ae\u4ef6\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-10.png 861w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-10-768x600.png 768w\" sizes=\"auto, (max-width: 861px) 100vw, 861px\" \/><\/li>\n<li>Key\u586b\u4e0a<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"365\" class=\"wp-image-9336\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-11.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f, \u7535\u5b50\u90ae\u4ef6\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-11.png 827w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-11-768x339.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/li>\n<li><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"613\" class=\"wp-image-9337\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-12.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f, \u7535\u5b50\u90ae\u4ef6\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" \/><\/li>\n<li>\u6570\u636e\u94fe\u63a5URL \u53ef\u4ee5\u6539\u6210\uff1amysql:\/\/localhost:3306\/confluence?sessionVariables=tx_isolation=&#8217;READ-COMMITTED&#8217;&amp;useUnicode=true&amp;characterEncoding=utf8<\/li>\n<li>\u62a5\u9519\u5c31\u6539\u6210\uff1a<\/li>\n<li>mysql:\/\/localhost:3306\/confluence?sessionVariables=transaction_isolation=&#8217;READ-COMMITTED&#8217;&amp;useUnicode=true&amp;characterEncoding=utf8<\/li>\n<li>\u6216\u8005\u8fd9\u6837\uff1ajdbc:mysql:\/\/localhost:3306\/confluence?serverTimezone=UTC&amp;sessionVariables=transaction_isolation=&#8217;READ-COMMITTED&#8217;&amp;useUnicode=true&amp;characterEncoding=utf8<\/li>\n<li>\u6216jdbc:mysql:\/\/localhost:3306\/confluence?serverTimezone=UTC&amp;&amp;sessionVariables=transaction_isolation=&#8217;READ-COMMITTED&#8217;<\/li>\n<li>\u5982\u679c\u4f60\u7684mysql-server8.0\u4ee5\u4e0a\u7684\u7248\u672c\uff0c\u53ef\u80fd\u4f1a\u8fde\u63a5\u4e0d\u6210\u529f\uff0c\u63d0\u793aaccess denied for user \u2018root\u2019@&#8217;localhost \u7528\u6237\u8bbf\u95ee\u88ab\u62d2\u7edd\uff0c\u53ef\u6309\u4e0b\u9762\u7684\u64cd\u4f5c\u3002\u6ce8\u610f\uff0c\u53ea\u9488\u5bf9mysql-server8.0\u4ee5\u4e0a\u7684\u7248\u672c\uff018.0\u4ee5\u4e0a\uff018.0\u4ee5\u4e0a\uff01<\/li>\n<\/ul>\n<p>1.\u5b89\u88c5\u8fc7\u7a0b\u6211\u5c31\u4e0d\u8be6\u7ec6\u8bb0\u5f55\u4e86\uff0c\u5b8c\u6210\u4e4b\u540e\u767b\u5f55mysql\u51fa\u73b0\u5982\u4e0b\u95ee\u9898\uff1a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"732\" height=\"100\" class=\"wp-image-9338\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-13.png\" alt=\"\u6587\u672c\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" \/><\/p>\n<p>access denied for user \u2018root\u2019@&#8217;localhost \u7528\u6237\u8bbf\u95ee\u88ab\u62d2\u7edd<\/p>\n<p>2.\u56e0\u4e3a\u5728\u5b89\u88c5\u8fc7\u7a0b\u4e2d\u6ca1\u6709\u63d0\u793a\u7528\u6237\u8bbe\u7f6e\u5bc6\u7801\uff0c\u6240\u4ee5\u9700\u8981\u4f7f\u7528mysql\u81ea\u52a8\u521b\u5efa\u7684\u7528\u6237\u8fdb\u884c\u767b\u5f55\uff1a<\/p>\n<p>\u67e5\u770bdebian\u7528\u6237\u540d\u53ca\u5bc6\u7801\uff1a<\/p>\n<p>kangel@tm1701:~$ sudo apt cat \/etc\/mysql\/debian.cnf<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"839\" height=\"339\" class=\"wp-image-9339\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-14.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u7f51\u7ad9\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-14.png 839w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-14-768x310.png 768w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/p>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u6709\u4e00\u4e2a\u540d\u4e3a debian-sys-maint \u7684\u7528\u6237,password\u5c31\u662f\u5b83\u5bf9\u5e94\u7684\u5bc6\u7801\uff0c\u7136\u540e\u6211\u4eec\u4f7f\u7528\u8fd9\u4e2a\u7528\u6237\u5bc6\u7801\u8fdb\u884c\u767b\u5f55\uff1a<\/p>\n<p>kangel@tm1701:~$ mysql -u debian-sys-maint -p<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"841\" height=\"280\" class=\"wp-image-9340\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-15.png\" alt=\"\u6587\u672c\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-15.png 841w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-15-768x256.png 768w\" sizes=\"auto, (max-width: 841px) 100vw, 841px\" \/><\/p>\n<p>ok\uff0cmysql\u767b\u5f55\u8fdb\u6765\u4e86\uff0c\u63a5\u4e0b\u6765\u5c31\u8981\u4fee\u6539root\u7684\u5bc6\u7801\u53ca\u6743\u9650\u3002<\/p>\n<p>3.\u4fee\u6539root\u7528\u6237<\/p>\n<p>\u9996\u5148\u5207\u6362\u5230mysql\u6570\u636e\u5e93\uff0c\u67e5\u770buser\u8868\u4e2droot\u7528\u6237\u7684\u6743\u9650\u53ca\u5bc6\u7801\uff1a<\/p>\n<p>mysql&gt; use mysql<\/p>\n<p>mysql&gt; select Host,user,authentication_string,plugin from user;<\/p>\n<p>\u67e5\u770b\u7528\u6237\u7684\u6743\u9650\uff0c\u662f\u5426\u662fmysql_native_password\uff0c\u5982\u679c\u4e0d\u662f\uff0c\u5219\u5c06auth_sock\u6539\u4e3amysql_native_password\u3002<\/p>\n<p>mysql&gt; ALTER USER \u2018root\u2019@\u2019localhost\u2019 IDENTIFIED WITH mysql_native_password BY \u2018\u4f60\u7684\u5bc6\u7801\u2019;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"934\" height=\"73\" class=\"wp-image-9341\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/word-image-9321-20.png\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/word-image-9321-20.png 934w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/word-image-9321-20-768x60.png 768w\" sizes=\"auto, (max-width: 934px) 100vw, 934px\" \/><\/p>\n<p>OK\uff0c\u4fee\u6539\u6743\u9650\uff0c\u5bc6\u7801\u4e00\u6b65\u5230\u4f4d\u3002<\/p>\n<p>\u7f51\u4e0a\u6709\u5f88\u591a\u5e16\u5b50\u4fee\u6539\u5bc6\u7801\u4f7f\u7528 _update user set password=password(\u2018\u4f60\u7684\u5bc6\u7801\u2019) where user=\u2018root\u2019 and host=\u2018localhost\u2019;_\u8fd9\u79cd\u7684\uff0c\u56e0\u4e3amysql 8.0+ \u7248\u672c password \u5b57\u6bb5\u66f4\u6539\u4e86, \u91c7\u7528\u539f\u6765\u7684 password = password(\u201cXXX\u201d) \u8bed\u53e5\u4f1a\u62a5\u8bed\u6cd5\u9519\u8bef\uff0c\u6240\u4ee5\u8981\u4f7f\u7528ALTER\u8bed\u53e5\u8fdb\u884c\u4fee\u6539<\/p>\n<p>4.quit\u9000\u51fa\uff0c\u91cd\u65b0\u767b\u5f55<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"891\" height=\"315\" class=\"wp-image-9342\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-16.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762\n\n\u4f4e\u53ef\u4fe1\u5ea6\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-16.png 891w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-16-768x272.png 768w\" sizes=\"auto, (max-width: 891px) 100vw, 891px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1172\" height=\"210\" class=\"wp-image-9343\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-17.png\" alt=\"\u56fe\u5f62\u7528\u6237\u754c\u9762, \u6587\u672c, \u5e94\u7528\u7a0b\u5e8f\n\n\u63cf\u8ff0\u5df2\u81ea\u52a8\u751f\u6210\" srcset=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-17.png 1172w, https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2023\/03\/unnamed-file-17-768x138.png 768w\" sizes=\"auto, (max-width: 1172px) 100vw, 1172px\" \/><\/p>\n<p>\u53ef\u4ee5\u770b\u5230root\u7528\u6237\u5df2\u7ecf\u53ef\u4ee5\u767b\u5f55\uff0c\u6743\u9650\uff0c\u5bc6\u7801\u4e5f\u5df2\u7ecf\u8bbe\u7f6e\u6210\u529f\u3002<\/p>\n<ul>\n<li>\u81f3\u6b64\u5b89\u88c5\u5168\u90e8\u5b8c\u6210\u3002\u5177\u4f53\u4f7f\u7528\u540e\u9762\u518d\u8bf4<\/li>\n<\/ul>\n<p>\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a<a href=\"https:\/\/www.hefeiyu.com\">\u8d6b\u975e\u57df<\/a> &raquo; <a href=\"https:\/\/www.hefeiyu.com\/?p=9321\">Ubuntu\u4e0b\u5b89\u88c5WIKI\u8f6f\u4ef6confluence\u6d41\u7a0b<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>WIKI\u8f6f\u4ef6confluence\u5b89\u88c5\u6d41\u7a0b \u6d4b\u8bd5\u73af\u5883\uff0cUbuntu \u6d4b\u8bd5\u7248\u672c 20.10\u3002\u5f00\u59cb\u524d\uff0c\u5148\u66f4\u65b0\u8f6f\u4ef6\u5217\u8868\u3002 sudo apt-get update \u8fd9\u4e2a\u547d\u4ee4\u4f1a\u8bbf\u95ee\u6e90\u5217\u8868\u4e2d\u7684\u6bcf\u4e2a\u7f51\u5740\uff0c\u5e76\u8bfb\u53d6\u8f6f\u4ef6\u5217\u8868 sudo apt-get upgrade \u8fd9\u4e2a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[1093,110,462],"class_list":["post-9321","post","type-post","status-publish","format-standard","hentry","category-soft_install","tag-1093","tag-110","tag-462"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/9321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9321"}],"version-history":[{"count":1,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/9321\/revisions"}],"predecessor-version":[{"id":9344,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/9321\/revisions\/9344"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}