{"id":291,"date":"2022-05-08T22:24:47","date_gmt":"2022-05-08T14:24:47","guid":{"rendered":"http:\/\/nas.hepcloud.top:7000\/?p=291"},"modified":"2022-11-01T23:11:27","modified_gmt":"2022-11-01T15:11:27","slug":"%e5%9b%9b%e3%80%81docker%e5%ae%89%e8%a3%85%e6%9c%80%e6%96%b0%e7%89%88mysql8-0-29%e6%9c%8d%e5%8a%a1%e5%99%a8","status":"publish","type":"post","link":"http:\/\/www.huerpu.cc:7000\/?p=291","title":{"rendered":"\u56db\u3001docker\u5b89\u88c5\u6700\u65b0\u7248mysql8.0.29\u670d\u52a1\u5668"},"content":{"rendered":"

\u56db\u3001docker\u5b89\u88c5\u6700\u65b0\u7248mysql8.0.29\u670d\u52a1\u5668<\/h3>\n

\u6211\u4eec\u7684\u76ee\u7684\u662f\u521b\u5efa\u4e00\u4e2a\u5f00\u7bb1\u5373\u7528\u7684\u6700\u65b0\u7248mysql8\u670d\u52a1\u5668\u7cfb\u7edf\uff0c\u7136\u540e\u53ef\u4ee5\u5728\u4efb\u4f55\u5730\u65b9\u8fdc\u7a0b\u8fde\u63a5\u5b83\uff0c\u8fd9\u6837\u5c31\u53ef\u4ee5\u628adocker\u51fa\u7684\u8fd9\u53f0mysql8\u5f53\u505a\u6570\u636e\u5e93\u670d\u52a1\u5668\u4f7f\u7528\u4e86\u3002\u524d\u9762\u4e24\u4e2a\u5bb9\u5668ubuntu\u548ccentos\u7684\u521b\u5efa\u6211\u4eec\u90fd\u76f4\u63a5\u4f7f\u7528\u547d\u4ee4docker run\u8fdb\u884c\u521b\u5efa\u7684\uff0c\u8fd9\u79cd\u65b9\u5f0f\u521b\u5efa\u7684\u5bb9\u5668\uff0c\u56e0\u4e3a\u6ca1\u6709\u589e\u52a0volume\u8fdb\u884c\u5b58\u50a8\uff0c\u6bcf\u6b21\u91cd\u542f\u5bb9\u5668\uff0c\u91cc\u9762\u5b89\u88c5\u7684\u8f6f\u4ef6\u6216\u8005\u65e5\u5fd7\u4fe1\u606f\u90fd\u4f1a\u4e22\u5931\u3002<\/p>\n

\u5c1d\u8bd5\u4f7f\u7528dockerfile\u6765\u521b\u5efa\u5bb9\u5668\uff0c\u8fd9\u79cd\u521b\u5efa\u5bb9\u5668\u7684\u65b9\u5f0f\uff0c\u53ef\u4ee5\u5728\u91cc\u9762\u5199\u547d\u4ee4\uff0c\u53ea\u8981dockerfile\u7f16\u5199\u5b8c\u6210\uff0c\u540e\u9762\u53ef\u4ee5\u4e00\u952e\u8fd0\u884c\uff0c\u800c\u4e0d\u7528\u62c5\u5fc3\u91cc\u9762\u5199\u7684apt install\u7684\u8f6f\u4ef6\u6ca1\u6709\u4e86\u3002\u6211\u4eec\u8fd8\u8bbe\u7f6e\u6302\u8f7dvolume\uff0c\u91cd\u542fmysql\u5bb9\u5668\u540e\u91cc\u9762\u66f4\u6539\u8fc7\u7684\u6570\u636e\u5e93\u6570\u636e\u90fd\u8fd8\u5728\uff0c\u4e0d\u4f1a\u56e0\u4e3a\u91cd\u542f\u5bb9\u5668\u800c\u91cd\u65b0\u8fdb\u884c\u521d\u59cb\u5316\u9020\u6210\u6570\u636e\u7684\u4e22\u5931\u3002<\/p>\n

1\u3001\u62c9\u53d6mysql8\u955c\u50cf\u5e76\u542f\u52a8<\/h3>\n

\u6700\u7b80\u5355\u7684\u4e00\u79cd\u65b9\u5f0f\uff1a<\/p>\n

#\u62c9\u53d6\u6700\u65b0\u955c\u50cf\ndocker pull mysql:latest\n\n#\u6267\u884cmysql\ndocker run -it --name mysql8  -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456  mysql:latest<\/code><\/pre>\n
\u5728Navicat\u7b49\u8f6f\u4ef6\u4e2d\uff0c\u8f93\u5165\u5bbf\u4e3b\u673a\u7684IP\u5730\u5740\u52a0\u4e0a3306\u5373\u53ef\u8fde\u63a5\uff0c\u8fd9\u91cc\u662f192.168.31.226:3306<\/code><\/p>\n
2\u3001\u4f7f\u7528dockfile\u521b\u5efamysql<\/h3>\n
\u6839\u636e\u4e0a\u9762\u8fd9\u4e2a\u57fa\u7840\u955c\u50cf\uff0c\u8fd9\u4e2a\u57fa\u7840\u955c\u50cf\u662f\u57fa\u4e8eDebian\u7684\uff0c\u6211\u4eec\u5199\u4e86\u4e00\u4e2adockerfile\u6587\u4ef6\u3002<\/p>\n
# \u57fa\u7840\u666f\u8c61\nFROM mysql:latest    \n# \u955c\u50cf\u5236\u4f5c\u4fe1\u606f                 \nLABEL maintainer="JingLisen" \n# \u5b89\u88c5\u66f4\u65b0\u7cfb\u7edf\u5e76\u5b89\u88c5\u4e00\u4e9b\u5e38\u7528\u7684\u8f6f\u4ef6\nRUN apt-get update && apt-get install -y --no-install-recommends \\                           # \u5b89\u88c5openssl\n    openssl \\     \n    #\u5b89\u88c5vim\n    vim \\\n    #\u5b89\u88c5ssh\n    openssh-server \\\n    #\u5b89\u88c5net-tools\n    net-tools \\\n    #\u5b89\u88c5ufw\n    ufw\n\n# \u5f00\u653e\u7aef\u53e3                                                           \nEXPOSE 3306 <\/code><\/pre>\n
\u8f93\u5165\u4e0b\u9762\u547d\u4ee4\u6267\u884c\uff1a<\/p>\n
#\u6267\u884cmysql\u955c\u50cf\ndocker run -itd --name mysql8  -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456  mysql8\n\n#\u8fdb\u5165\u5bb9\u5668\ndocker exec -it mysql8 \/bin\/bash\n\n#\u67e5\u770b3306\u7aef\u53e3\nnetstat -nltp | grep 3306<\/code><\/pre>\n
\u5728Navicat\u7b49\u8f6f\u4ef6\u4e2d\uff0c\u8f93\u5165\u5bbf\u4e3b\u673a\u7684IP\u5730\u5740\u7aef\u53e3\u4f7f\u75283306\u5373\u53ef\u8fde\u63a5\u3002<\/p>\n
3\u3001\u589e\u52a0\u4e00\u4e2a22\u7aef\u53e3<\/h3>\n
\u589e\u52a0\u4e00\u4e2a\u542f\u52a8\u811a\u672csetup.sh\uff0c\u8be5\u811a\u672c\u548cDockerfile\u5728\u540c\u4e00\u76ee\u5f55\u4e0b\u3002\u542f\u52a8\u811a\u672c\u91cc\u8bbe\u7f6e\u5141\u8bb8root\u7528\u6237\u767b\u5f55\u548c\u8bbe\u7f6essh\u5f00\u673a\u81ea\u542f\u52a8\u3002<\/p>\n
# \u57fa\u7840\u666f\u8c61\nFROM mysql:latest    \n# \u955c\u50cf\u5236\u4f5c\u4fe1\u606f                 \nLABEL maintainer="JingLisen" \n# \u5b89\u88c5\u66f4\u65b0\u7cfb\u7edf\u5e76\u5b89\u88c5\u4e00\u4e9b\u5e38\u7528\u7684\u8f6f\u4ef6\nRUN apt-get update && apt-get install -y --no-install-recommends \\                           # \u5b89\u88c5openssl\n    openssl \\     \n    #\u5b89\u88c5vim\n    vim \\\n    #\u5b89\u88c5ssh\n    openssh-server \\\n    net-tools \\\n    ufw\n\n#\u628asetup.sh\u6587\u4ef6\u62f7\u8d1d\u5230\u5bb9\u5668\u4e2d\uff0c\u5e76\u8d4b\u4e88\u53ef\u6267\u884c\u6743\u9650\nCOPY .\/setup.sh \/\nRUN chmod a+x \/setup.sh\n\n#\u4f7f\u7528root\u7528\u6237\nUSER root\n\n# \u5f00\u653e\u7aef\u53e3                                                           \nEXPOSE 3306 22\n\n#\u6267\u884csetup.sh\u8fd9\u4e2a\u811a\u672c\nRUN \/bin\/bash -c "source \/setup.sh"<\/code><\/pre>\n
setup.sh\u6587\u4ef6\u5185\u5bb9\u662f\u8bbe\u7f6e\u5141\u8bb8root\u7528\u6237\u767b\u5f55\u548c\u8bbe\u7f6essh\u5f00\u673a\u81ea\u542f\u52a8\u3002#!\/bin\/bash<\/code>    \u7279\u6b8a\u7684\u811a\u672c\u58f0\u660e\uff0c\u8868\u793a\u6b64\u884c\u4ee5\u540e\u7684\u8bed\u53e5\u901a\u8fc7\/bin\/bash<\/code>\u7a0b\u5e8f\u6765\u89e3\u91ca\u6267\u884c\u3002<\/p>\n
#!\/bin\/bash\n#\u8bbe\u7f6e\u5141\u8bb8root\u7528\u6237\u767b\u5f55\necho PermitRootLogin yes >> \/etc\/ssh\/sshd_config;\n\n#\u8bbe\u7f6essh\u5f00\u673a\u81ea\u542f\u52a8\necho service ssh start >> \/root\/.bashrc;<\/code><\/pre>\n
\u8f93\u5165\u4e0b\u9762\u547d\u4ee4\u6267\u884c\uff1a<\/p>\n
#\u6267\u884cmysql\u955c\u50cf\ndocker run -itd --name mysql8  -p 3306:3306 -p 3070:22 -e MYSQL_ROOT_PASSWORD=123456  mysql8\n\n#\u8fdb\u5165\u5bb9\u5668\ndocker exec -it mysql8 \/bin\/bash\n\n#\u67e5\u770b3306\u7aef\u53e3\nnetstat -nltp | grep 3306\n\n#\u67e5\u770b22\u7aef\u53e3\nnetstat -nltp | grep 22<\/code><\/pre>\n
\u5728\u5bbf\u4e3b\u673a\u5f00\u653e3070\u7aef\u53e3\uff0c\u4f7f\u7528ufw allow 3070<\/code>\u3002\u5728\u5bb9\u5668\u91cc\u5f00\u653e22\u7aef\u53e3\uff0c\u67e5\u770bPermitRootLogin\u7684\u503c\u662f\u5426\u6539\u4e3ayes\u3002\u7406\u8bba\u4e0a\u6211\u4eec\u53ef\u4ee5\u76f4\u63a5ssh\u767b\u9646\u7684\u3002<\/p>\n
#\u5c06PermitRootLogin\u7684\u503c\u6539\u4e3ayes\uff0c\/\u641c\u7d22\u5373\u53ef\uff0c\u8d85\u7ea7\u7b80\u5355\nvim \/etc\/ssh\/sshd_config\n\n#\u5f00\u542f22\u7aef\u53e3\nufw allow 22\n\n#\u91cd\u542fssh\u670d\u52a1\nservice ssh restart\n\n#\u4fee\u6539root\u5bc6\u7801\uff0c\u8f93\u5165\u547d\u4ee4passwd\uff0c\u7136\u540e\u8f93\u5165\u5bc6\u7801\u5c31\u884c\u4e86\npasswd<\/code><\/pre>\n
\u6211\u7684\u5bbf\u4e3b\u673aIP\u4e3a192.168.31.226<\/code>\uff0c\u53ef\u4ee5\u7528\u522b\u7684\u7535\u8111\u8fdb\u884cssh\u767b\u9646\u3002<\/p>\n
 ssh -p 3070 root@192.168.31.226<\/code><\/pre>\n
\u8fd9\u5c31\u76f8\u5f53\u4e8e\u6211\u4eec\u8fd9\u53f0docker\u51fa\u6765\u7684mysql8\u65e2\u53ef\u4ee5\u901a\u8fc73306\u8fdb\u884c\u6570\u636e\u5e93\u7684\u8fde\u63a5\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc722\u7aef\u53e3\u8fdb\u884c\u8fdc\u7a0b\u8bbf\u95ee\u5566\u3002<\/p>\n
4\u3001\u8bbe\u7f6e\u521d\u59cb\u5316sql\u811a\u672c\uff0c\u53ef\u4ee5\u6709\u591a\u4e2a<\/h3>\n
mysql8\u7684\u5b98\u65b9\u955c\u50cf\u4e2d\uff0c\u6709\u4e00\u4e2a\/docker-entrypoint-initdb.d<\/code> \u76ee\u5f55\uff0c\u8fd9\u4e2a\u76ee\u5f55\u5c31\u662f\u7528\u4e8e\u521d\u59cb\u5316\u811a\u672c\u7684\u6267\u884c\u7684\u3002\u5bb9\u5668\u542f\u52a8\u4f1a\u68c0\u67e5\/var\/lib\/mysql<\/code> \u76ee\u5f55\u4e0b\u662f\u5426\u6709\u6570\u636e\uff0c\u5982\u679c\u6ca1\u6709\u6570\u636e<\/code>\u624d\u4f1a\u6267\u884c\/docker-entrypoint-initdb.d<\/code> \u76ee\u5f55\u4e0b\u7684\u811a\u672c\u3002\u811a\u672c\u7684\u6267\u884c\u987a\u5e8f\u65f6\u5b89\u88c5\u5b57\u6bcd\u7684\u6392\u5e8f\u6765\u6267\u884c\u7684\u3002\u56e0\u4e3a\u6211\u4eec\u6ca1\u6709\u6620\u5c04\u5377\u5230\u672c\u5730\u78c1\u76d8(\u4e3b\u8981\u770bdocker run\u547d\u4ee4\u662f\u5426\u589e\u52a0\u4e86-v\u53c2\u6570\uff0c\u5e76\u6620\u5c04\u4e86\/var\/lib\/mysql<\/code>)\uff0c\u6240\u4ee5\u8fd9\u4e2a\u76ee\u5f55\u80af\u5b9a\u6ca1\u6709\u6570\u636e\uff0c\u4e5f\u5c31\u662f\u8bf4sql\u811a\u672c\u80af\u5b9a\u4f1a\u6267\u884c\u7684\uff0c\u8bf7\u5c0f\u4f19\u4f34\u6309\u7167\u6211\u5199\u7684\u547d\u4ee4\u8fdb\u884c\u64cd\u4f5c\u54c8\u3002\u540e\u9762\u4f1a\u6709\u589e\u52a0\u53c2\u6570-v\u6765\u5c55\u793a\u3002sql\u811a\u672c\u548cDockerfile\u5728\u540c\u4e00\u76ee\u5f55\u4e0b\uff0c\u5e76\u4e14sql\u811a\u672c\u7684\u6587\u4ef6\u540d\u53ef\u4ee5\u968f\u4fbf\u8d77\uff0c\u800c\u4e14\u53ef\u4ee5\u5199\u591a\u4e2asql\u811a\u672c\uff0c\u53ea\u8981\u90fd\u662f\u4ee5sql\u540e\u7f00\u7ed3\u5c3e\u7684\u6587\u4ef6\u5c31\u884c\u3002<\/p>\n
\u5728dockerfile\u4e2d\u589e\u52a0sql\u811a\u672c\u7684\u62f7\u8d1d\u64cd\u4f5c\uff1a<\/p>\n
# \u57fa\u7840\u666f\u8c61\nFROM mysql:latest    \n# \u955c\u50cf\u5236\u4f5c\u4fe1\u606f                 \nLABEL maintainer="JingLisen" \n# \u5b89\u88c5\u66f4\u65b0\u7cfb\u7edf\nRUN apt-get update && apt-get install -y --no-install-recommends \\                           # \u5b89\u88c5openssl\n    openssl \\     \n    #\u5b89\u88c5vim\n    vim \\\n    #\u5b89\u88c5ssh\n    openssh-server \\\n    net-tools \\\n    ufw\n\n#\u628asetup.sh\u6587\u4ef6\u62f7\u8d1d\u5230\u5bb9\u5668\u4e2d\uff0c\u5e76\u8d4b\u4e88\u53ef\u6267\u884c\u6743\u9650\nCOPY .\/setup.sh \/\nRUN chmod a+x \/setup.sh\n\n#\u521d\u59cb\u5316mysql\u811a\u672c,\u53ef\u4ee5\u5199\u591a\u4e2a\nCOPY .\/*.sql \/docker-entrypoint-initdb.d\/\n\n#\u4f7f\u7528root\u7528\u6237\nUSER root\n\n# \u5f00\u653e\u7aef\u53e3                                                           \nEXPOSE 3306 22\n\n#\u6267\u884csetup.sh\u8fd9\u4e2a\u811a\u672c\nRUN \/bin\/bash -c "source \/setup.sh"<\/code><\/pre>\n
mysqlSetup.sql\u811a\u672c\u4e3a\uff1a<\/p>\n
SET NAMES utf8;\nCREATE DATABASE If Not Exists hep Character Set utf8;\n\nUSE hep;\n-- ----------------------------\n-- Table structure for hep_cs_university\n-- ----------------------------\nDROP TABLE IF EXISTS `hep_cs_university`;\nCREATE TABLE `hep_cs_university` (\n  `hep_cs_university_id` int(11) NOT NULL COMMENT '\u4e3b\u952e',\n  `hep_cs_university_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '\u5b66\u6821\u540d\u79f0',\n  `hep_cs_university_college` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '\u5b66\u9662\u540d\u79f0',\n  `hep_cs_university_exam_basic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '\u8ba1\u7b97\u673a\u8003\u7814\u516c\u5171\u57fa\u7840\u8bfe',\n  `hep_cs_university_exam_cs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '\u8ba1\u7b97\u673a\u8003\u7814\u4e13\u4e1a\u8bfe',\n  `hep_cs_university_exam_interview` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '\u8ba1\u7b97\u673a\u8003\u7814\u590d\u8bd5\u5185\u5bb9',\n  `hep_cs_university_major_direction` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '\u8ba1\u7b97\u673a\u4e3b\u4fee\u7814\u7a76\u65b9\u5411',\n  `hep_cs_university_coefficient_difficulty` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '\u8003\u7814\u96be\u5ea6\u7cfb\u6570',\n  `hep_cs_university_academic_professional` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '\u5b66\u7855\u8fd8\u662f\u4e13\u7855',\n  `hep_cs_university_study_period` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '\u7814\u7a76\u751f\u5b66\u4e60\u5e74\u9650(2\u5e74\u30013\u5e74\u8fd8\u662f2.5\u5e74)',\n  `hep_cs_university_rank` int(11) DEFAULT NULL COMMENT '\u5927\u5b66\u7efc\u5408\u6392\u540d',\n  `hep_cs_university_cs_rank` int(11) DEFAULT NULL COMMENT '\u5927\u5b66\u8ba1\u7b97\u673a\u4e13\u4e1a\u6392\u540d',\n  PRIMARY KEY (`hep_cs_university_id`) USING BTREE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='\u5b66\u6821\u4fe1\u606f';\n\n-- ----------------------------\n-- Records of hep_cs_university\n-- ----------------------------\nBEGIN;\nINSERT INTO `hep_cs_university` VALUES (1, '\u5317\u4eac\u5927\u5b66', '\u5317\u4eac\u5927\u5b66\u4fe1\u606f\u79d1\u5b66\u6280\u672f\u5b66\u9662', '\u2460 101 \u601d\u60f3\u653f\u6cbb\u7406\u8bba  \u2461 201 \u82f1\u8bed\u4e00  \u2462 301 \u6570\u5b66\u4e00\\n1\\n0\\n1\\n\u601d\\n\u60f3\\n\u653f\\n\u6cbb\\n\u7406\\n\u8bba', '801 \u8ba1\u7b97\u673a\u4e13\u4e1a\u57fa\u7840\\n8\\n0\\n1\\n\u8ba1\\n\u7b97\\n\u673a\\n\u4e13\\n\u4e1a\\n\u57fa\\n\u7840', '\u590d\u8bd5\u5185\u5bb9: 1. \u4e0a\u673a\u8003\u8bd5\uff1b2.\u9762\u8bd5', '081201 \u8ba1\u7b97\u673a\u7cfb\u7edf\u7ed3\u6784\uff1b081202 \u8ba1\u7b97\u673a\u8f6f\u4ef6\u4e0e\u7406\u8bba\uff1b 081203 \u8ba1\u7b97\u673a\u5e94\u7528\u6280\u672f', '\u96be\u5ea6\u7cfb\u6570: \u4e94\u9897\u661f', NULL, '3', NULL, NULL);\nINSERT INTO `hep_cs_university` VALUES (2, '\u5317\u4eac\u5927\u5b66', '\u5317\u4eac\u5927\u5b66\u6df1\u5733\u7814\u7a76\u751f\u9662', '\u2460 101 \u601d\u60f3\u653f\u6cbb\u7406\u8bba  \u2461 201 \u82f1\u8bed\u4e00  \u2462 301 \u6570\u5b66\u4e00\\n1\\n0\\n1\\n\u601d\\n\u60f3\\n\u653f\\n\u6cbb\\n\u7406\\n\u8bba', '801 \u8ba1\u7b97\u673a\u4e13\u4e1a\u57fa\u7840\\n8\\n0\\n1\\n\u8ba1\\n\u7b97\\n\u673a\\n\u4e13\\n\u4e1a\\n\u57fa\\n\u7840', '\u590d\u8bd5\u5185\u5bb9: 1. \u4e0a\u673a\u8003\u8bd5\uff1b2.\u9762\u8bd5', '081203 \u8ba1\u7b97\u673a\u5e94\u7528\u6280\u672f', '\u96be\u5ea6\u7cfb\u6570: \u4e94\u9897\u661f', NULL, '3', NULL, NULL);\nINSERT INTO `hep_cs_university` VALUES (3, '\u5317\u4eac\u5927\u5b66', '\u5317\u4eac\u5927\u5b66\u8f6f\u4ef6\u4e0e\u5fae\u7535\u5b50\u5b66\u9662', '\u2460 101 \u601d\u60f3\u653f\u6cbb\u7406\u8bba  \u2461 201 \u82f1\u8bed\u4e00  \u2462 301 \u6570\u5b66\u4e00\\n1\\n0\\n1\\n\u601d\\n\u60f3\\n\u653f\\n\u6cbb\\n\u7406\\n\u8bba', '869 \u8ba1\u7b97\u673a\u57fa\u7840\u7efc\u5408(\u8f6f\u4ef6\u5de5\u7a0b) \/ 622 \u8ba1\u7b97\u673a\u5e94\u7528\u57fa\u7840(\u8ba1\u7b97\u673a\u6280\u672f)', '\u590d\u8bd5\u5185\u5bb9: 1. \u4e0a\u673a\u8003\u8bd5\uff1b2.\u9762\u8bd5', '085400 \u7535\u5b50\u4fe1\u606f', '\u96be\u5ea6\u7cfb\u6570: \u56db\u9897\u661f', NULL, '3', NULL, NULL);\nINSERT INTO `hep_cs_university` VALUES (4, '\u6e05\u534e\u5927\u5b66', '\u6e05\u534e\u5927\u5b66\u8ba1\u7b97\u673a\u79d1\u5b66\u4e0e\u6280\u672f\u7cfb', '\u2460 101 \u601d\u60f3\u653f\u6cbb\u7406\u8bba  \u2461 201 \u82f1\u8bed\u4e00  \u2462 301 \u6570\u5b66\u4e00\\n1\\n0\\n1\\n\u601d\\n\u60f3\\n\u653f\\n\u6cbb\\n\u7406\\n\u8bba', '912 \u8ba1\u7b97\u673a\u4e13\u4e1a\u57fa\u7840\u7efc\u5408', '01\u8ba1\u7b97\u673a\u7cfb\u7edf\u7ed3\u6784:\u590d\u8bd5\u65f6\u4e13\u4e1a\u7efc\u5408\u8003\u8bd5\u5185\u5bb9\uff1a\u8ba1\u7b97\u673a\u7cfb\u7edf\u7ed3\u6784,\u7f16\u8bd1\u539f\u7406; 02\u8ba1\u7b97\u673a\u8f6f\u4ef6\u4e0e\u7406\u8bba:\u590d\u8bd5\u65f6\u4e13\u4e1a\u7efc\u5408\u8003\u8bd5\u5185\u5bb9\uff1a\u7f16\u8bd1\u539f\u7406,\u6570\u636e\u5e93\u539f\u7406; 03\u8ba1\u7b97\u673a\u5e94\u7528\u6280\u672f:\u590d\u8bd5\u65f6\u4e13\u4e1a\u7efc\u5408\u8003\u8bd5\u5185\u5bb9\uff1a\u4eba\u5de5\u667a\u80fd,\u591a\u5a92\u4f53\u6280\u672f', '081200 \u8ba1\u7b97\u673a\u79d1\u5b66\u4e0e\u6280\u672f', '\u96be\u5ea6\u7cfb\u6570: \u4e94\u9897\u661f', NULL, '3', NULL, NULL);\nINSERT INTO `hep_cs_university` VALUES (5, '\u6e05\u534e\u5927\u5b66', '\u6e05\u534e\u5927\u5b66\u8f6f\u4ef6\u5b66\u9662', '\u2460 101 \u601d\u60f3\u653f\u6cbb\u7406\u8bba  \u2461 201 \u82f1\u8bed\u4e00  \u2462 301 \u6570\u5b66\u4e00\\n1\\n0\\n1\\n\u601d\\n\u60f3\\n\u653f\\n\u6cbb\\n\u7406\\n\u8bba', '912 \u8ba1\u7b97\u673a\u4e13\u4e1a\u57fa\u7840\u7efc\u5408', '\u590d\u8bd5\u65f6\u4e13\u4e1a\u7efc\u5408\u8003\u8bd5\u5185\u5bb9\uff1a\u7f16\u8bd1\u539f\u7406\u3001\u6570\u636e\u5e93\u539f\u7406', '083500 \u8f6f\u4ef6\u5de5\u7a0b', '\u96be\u5ea6\u7cfb\u6570: \u4e94\u9897\u661f', NULL, '3', NULL, NULL);\nINSERT INTO `hep_cs_university` VALUES (6, '\u6e05\u534e\u5927\u5b66', '\u6e05\u534e\u5927\u5b66\u6df1\u5733\u56fd\u9645\u7814\u7a76\u751f\u9662', '\u2460 101 \u601d\u60f3\u653f\u6cbb\u7406\u8bba  \u2461 201 \u82f1\u8bed\u4e00  \u2462 301 \u6570\u5b66\u4e00\\n1\\n0\\n1\\n\u601d\\n\u60f3\\n\u653f\\n\u6cbb\\n\u7406\\n\u8bba', '912 \u8ba1\u7b97\u673a\u4e13\u4e1a\u57fa\u7840\u7efc\u5408', '\u590d\u8bd5\u5730\u70b9\uff1a\u6821\u672c\u90e8(\u5317\u4eac)\u3002\u590d\u8bd5\u65f6\u4e13\u4e1a\u7efc\u5408\u8003\u8bd5\u5185\u5bb9\uff1a\u8ba1\u7b97\u673a\u7cfb\u7edf\u7ed3\u6784\u3001\u8f6f\u4ef6\u5de5\u7a0b(\u4e8c\u9009\u4e00)\u3002', '085400 \u7535\u5b50\u4fe1\u606f', '\u96be\u5ea6\u7cfb\u6570: \u4e94\u9897\u661f', NULL, '3', NULL, NULL);\nCOMMIT;<\/code><\/pre>\n
\u8f93\u5165\u4e0b\u9762\u547d\u4ee4\u6267\u884c\uff1a<\/p>\n
#\u6267\u884cmysql\u955c\u50cf\ndocker run -itd --name mysql8  -p 3306:3306 -p 3070:22 -e MYSQL_ROOT_PASSWORD=123456  mysql8\n\n#\u8fdb\u5165\u5bb9\u5668\ndocker exec -it mysql8 \/bin\/bash\n\n#\u67e5\u770b3306\u7aef\u53e3\nnetstat -nltp | grep 3306\n\n#\u67e5\u770b22\u7aef\u53e3\nnetstat -nltp | grep 22<\/code><\/pre>\n
\u7528Navicat\u8fde\u63a5\u4e00\u4e0b\uff0c\u53ef\u4ee5\u770b\u5230\u521d\u59cb\u5316\u7684\u6570\u636e\u3002<\/p>\n
\"docker-009.png\"<\/p>\n
5\u3001\u52a0\u8f7d\u4e00\u4e2avolume\u5377\u8fdb\u884c\u6570\u636e\u5b58\u50a8\uff0c\u4fdd\u8bc1\u6570\u636e\u64cd\u4f5c\u4e0d\u4e22\u5931<\/h3>\n
\u6211\u4eec\u5728\u5bbf\u4e3b\u673a\u6709\u4e00\u4e2a\u76ee\u5f55\/home\/jason\/Desktop\/mysql8\/data<\/code>\uff0c\u628a\u8fd9\u4e2a\u76ee\u5f55\u6302\u8f7d\u6620\u5c04\u5230\u5bb9\u5668\u7684\/var\/lib\/mysql<\/code>\u76ee\u5f55\uff0c\u589e\u52a0\u4e00\u4e2a\u53c2\u6570-v \/home\/jason\/Desktop\/mysql8\/data:\/var\/lib\/mysql <\/code>\u3002\u8fd9\u6837\u5b50\u91cd\u542f\u5bb9\u5668\u6570\u636e\u662f\u4e0d\u4f1a\u4e22\u5931\u7684\uff0c\u53ea\u8981\/home\/jason\/Desktop\/mysql8\/data<\/code>\u8fd9\u4e2a\u5bbf\u4e3b\u673a\u76ee\u5f55\u7684\u6570\u636e\u6ca1\u6709\u4e22\u5931\uff0c\u91cd\u542fmysql\u5bb9\u5668\u539f\u6765\u7684\u6570\u636e\u90fd\u8fd8\u5728\u3002<\/p>\n
#\u6267\u884cmysql\u955c\u50cf\ndocker run -itd --name mysql8 -v \/home\/jason\/Desktop\/mysql8\/data:\/var\/lib\/mysql  -p 3306:3306 -p 3070:22 -e MYSQL_ROOT_PASSWORD=123456  mysql8\n\n#\u8fdb\u5165\u5bb9\u5668\ndocker exec -it mysql8 \/bin\/bash<\/code><\/pre>\n
\u770b\u4e00\u4e0b\u6211\u4eec\u6709\u64cd\u4f5c\u8fc7\u7684\u6570\u636e\uff0c\u91cd\u542fmysql\u5bb9\u5668\u4e4b\u540e\uff0c\u539f\u6709\u7684\u6570\u636e\u90fd\u8fd8\u5728\u6ca1\u6709\u4e22\u5931\u3002\u8fd9\u624d\u6709\u70b9\u50cf\u6a21\u50cf\u6837\u5730\u5f53\u505amysql\u670d\u52a1\u5668\u4f7f\u7528\u4e86\u3002<\/p>\n
\"docker-009.png\"<\/p>\n
\"docker-011.png\"<\/p>\n
6\u3001\u8fdc\u7a0b\u8fde\u63a5\u8bbe\u7f6e<\/h3>\n
\u60f3\u8981\u8fdc\u7a0b\u767b\u9646\u5230\u5bb9\u5668\uff0c\u5fc5\u987b\u628a\u5bb6\u91cc\u7684\u8fd9\u53f0\u673a\u5668\u66b4\u9732\u5230\u4e92\u8054\u7f51\u4e2d\u3002\u8bbf\u95ee\u8def\u5f84\u662f\uff1a\u4e92\u8054\u7f51\u4efb\u4f55\u5730\u65b9\u7684\u7f51\u7edc\u2192\u5bb6\u5ead\u5bbd\u5e26\u5149\u732b\u2192\u5bb6\u5ead\u8def\u7531\u5668\u2192\u5bb6\u5ead\u4ea4\u6362\u673a(\u5982\u679c\u6709\u7684\u8bdd)\u2192\u5c40\u57df\u7f51\u5bbf\u4e3b\u673a\u2192\u5bb9\u5668\u3002<\/p>\n
\u9996\u5148\u5bb6\u91cc\u7684\u5bbd\u5e26\u5fc5\u987b\u6865\u63a5\uff0c\u5fc5\u987b\u7533\u8bf7\u516c\u7f51IP\uff0c\u5149\u732b\u7684\u7ba1\u7406\u6743\u4ea4\u7ed9\u8def\u7531\u5668\uff0c\u8def\u7531\u5668\u5f00\u653e\u7279\u5b9a\u673a\u5668\u7684\u7279\u5b9a\u7aef\u53e3\u53f7\u3002\u901a\u8fc7\u5c0f\u7c73\u8def\u7531\u5668\u8bbe\u7f6e\uff0c\u628a\u5bb6\u91cc\u7684docker\u5bbf\u4e3b\u673a\u76843306\u7aef\u53e3\u53f7\u66b4\u9732\u5230\u4e92\u8054\u7f51\uff0c\u66b4\u9732\u7684\u7aef\u53e3\u53f7\u4e3a6033\u3002<\/p>\n
\"docker-012.png\"<\/p>\n
\u6211\u5bb6\u7684\u516c\u7f51IP\u73b0\u5728\u662f58.246.143.76<\/code>\uff0c\u53ef\u4ee5\u901a\u8fc7\u767e\u5ea6IP\u8fdb\u884c\u67e5\u770b\uff0c\u73b0\u5728\u5c31\u53ef\u4ee5\u901a\u8fc7\u8fd9\u4e2aIP\u8fdb\u884c\u767b\u5f55\u5230mysql8\u5bb9\u5668\u4e86\u3002\u7f51\u7edc\u7684\u6d41\u7a0b\u4e3a:\u516c\u7f51IP58.246.143.76:6033<\/code>\u2192\u5bbf\u4e3b\u673a192.168.31.226<\/code>\u2192\u5bb9\u5668:3306<\/code>\u3002\u8fd9\u4e2a\u8fd0\u8425\u5546\u5206\u914d\u7684\u516c\u7f51IP\u662f\u7ecf\u5e38\u53d8\u5316\u7684\uff0c\u6240\u4ee5\u6211\u8fdb\u884c\u4e86DDNS\u89e3\u6790\uff0c\u4e5f\u5c31\u4e0d\u6015\u516c\u7f51IP\u968f\u65f6\u53d8\u5316\u4e86\uff0c\u516c\u5171\u57df\u540d\u540c\u6837\u53ef\u4ee5\u767b\u5f55\u3002<\/p>\n
\"docker-012.png\"<\/p>\n
\u5927\u529f\u544a\u6210\uff0cenjoy it\u3002<\/p>\n
7\u3001\u8bf4\u660e<\/h3>\n
\u5176\u4ed6\u53ef\u80fd\u7528\u5230\u7684docker\u547d\u4ee4\uff1a<\/p>\n
#\u67e5\u770b\u65e5\u5fd7docker logs -f ContainerID\u6216\u540d\u79f0\ndocker logs -f mysql8\n\n#\u6267\u884c\u811a\u672csetup.sh\nCMD["\/bin\/bash","\/setup.sh"]\n\n#\u6267\u884c\u811a\u672csetup.sh\nENTRYPOINT .\/setup.sh\n\n#\u67e5\u770bmysql\u8fd0\u884c\u72b6\u6001\nservice mysql status\n\n#\u9000\u51fa\u5bb9\u5668\uff0c\u5728\u547d\u4ee4\u884c\u8f93\u5165exit\nexit\n\n#\u5173\u95ed\u5bb9\u5668\uff0c docker stop + \u5bb9\u5668ID\ndocker stop mysql8\n\n# \u67e5\u8be2\u6240\u6709\u7684\u5bb9\u5668\uff0c\u5305\u62ec\u6ca1\u6709\u8fd0\u884c\u7684\ndocker ps -a\n\n#\u67e5\u770b\u6240\u6709\u8fd0\u884c\u4e2d\u7684\u5bb9\u5668\ndocker ps\n\n#\u5f00\u542f\u5bb9\u5668docker start + \u5bb9\u5668ID\u6216\u8005\u5bb9\u5668\u540d\ndocker start mysql8\n\n#\u8fdb\u5165\u5bb9\u5668 docker attach + \u5bb9\u5668\u7684ID\u6216\u8005\u5bb9\u5668\u7684\u540d\u79f0\ndocker attach mysql8\n\n#\u5f3a\u5236\u5220\u9664\u5bb9\u5668docker rm -f + \u5bb9\u5668\u540d\ndocker rm -f mysql8<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u56db\u3001docker\u5b89\u88c5\u6700\u65b0\u7248mysql8.0.29\u670d\u52a1\u5668 \u6211\u4eec\u7684\u76ee\u7684\u662f\u521b\u5efa\u4e00\u4e2a\u5f00\u7bb1\u5373\u7528\u7684\u6700\u65b0\u7248mysql8\u670d\u52a1\u5668 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-291","post","type-post","status-publish","format-standard","hentry","category-docker"],"_links":{"self":[{"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/posts\/291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=291"}],"version-history":[{"count":1,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/posts\/291\/revisions"}],"predecessor-version":[{"id":480,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/posts\/291\/revisions\/480"}],"wp:attachment":[{"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}