{"id":10008253,"date":"2023-09-08T11:30:24","date_gmt":"2023-09-08T03:30:24","guid":{"rendered":"https:\/\/blog.itmax.cn\/?p=10008253"},"modified":"2023-09-08T11:30:24","modified_gmt":"2023-09-08T03:30:24","slug":"%e5%86%8d%e8%a7%81-mysql-5-7-%ef%bc%81%ef%bc%81%ef%bc%81","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10008253","title":{"rendered":"\u518d\u89c1 MySQL 5.7 \uff01\uff01\uff01"},"content":{"rendered":"<p>\u5bf9\u4ece\u4e8b\u4e92\u8054\u7f51 IT \u6280\u672f\u5c97\u4f4d\u7684\u6765\u8bf4\uff0c\u6570\u636e\u5e93\u4e5f\u662f\u6211\u4eec\u65e5\u5e38\u5fc5\u5907\u7684\u6280\u80fd\u4e4b\u4e00\uff0c\u800c MySQL \u6570\u636e\u5e93\u66f4\u662f\u5e38\u89c1\u3001\u5e38\u7528\u7684\u6570\u636e\u5e93\u4e4b\u4e00\u3002<\/p>\n<p><img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044194428\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\"><\/p>\n<p>\u6839\u636e DB-Engines \u7684\u6570\u636e\u663e\u793a\uff0cMySQL \u662f\u5168\u7403\u6700\u6d41\u884c\u7684\u5f00\u6e90\u6570\u636e\u5e93\uff0c\u5e76\u4e14\u5728\u8fc7\u53bb\u5341\u591a\u5e74\u4e2d\u4e00\u76f4\u6392\u540d\u7b2c\u4e8c\u3002<img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044194429\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\" loading=\"lazy\">\u6570\u636e\u6765\u6e90\uff1aDB-Engines \u5b98\u65b9\u7f51\u7ad9\u622a\u56fe\uff0c\u8be6\u7ec6\u6570\u636e\uff1a<a target=\"_blank\" href=\"https:\/\/link.segmentfault.com\/?enc=U109MOYE7N5ZSo1zEfULIQ%3D%3D.4b%2BoLWpABBDPuVUQlVI4Ls29tA%2FulQ1yjunMbmxvhrU4RnyQLmVggsNwt3autDcp\" rel=\"noopener noreferrer\">https:\/\/db-engines.com\/en\/ranking<\/a><\/p>\n<h2>MySQL \u7684\u53d1\u5c55\u53f2<\/h2>\n<p>MySQL \u7684\u5386\u53f2\u53ef\u4ee5\u8ffd\u6eaf\u52301979\u5e74\uff0c\u5b83\u7684\u521b\u59cb\u4eba\u53eb\u4f5cMichael Widenius\uff0c\u4ed6\u5728\u5f00\u53d1\u4e00\u4e2a\u62a5\u8868\u5de5\u5177\u7684\u65f6\u5019\uff0c\u8bbe\u8ba1\u4e86\u4e00\u5957API\uff0c\u540e\u6765\u4ed6\u7684\u5ba2\u6237\u8981\u6c42\u4ed6\u7684API\u652f\u6301sql\u8bed\u53e5\uff0c\u4ed6\u76f4\u63a5\u501f\u52a9\u4e8e mSQL \u7684\u4ee3\u7801\uff0c\u5c06\u5b83\u96c6\u6210\u5230\u81ea\u5df1\u7684\u5b58\u50a8\u5f15\u64ce\u4e2d\u3002\u4f46\u662f\u4ed6\u603b\u662f\u611f\u89c9\u4e0d\u6ee1\u610f\uff0c\u6545\u840c\u751f\u4e86\u8981\u81ea\u5df1\u505a\u4e00\u5957\u6570\u636e\u5e93\u7684\u60f3\u6cd5\u3002<img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044194430\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\" loading=\"lazy\">1996 \u5e74 MySQL 1.0\u53d1\u5e03\uff0c\u540c\u5e74 10 \u6708 MySQL 3.11.1 \u53d1\u5e03\u4e86 Solaris \u7684\u7248\u672c\uff0c\u4e00\u4e2a\u6708\u540e\uff0cLinux \u7248\u672c\u53d1\u5e03\uff0c\u4ece\u90a3\u65f6\u5019\u5f00\u59cb\uff0cMySQL \u6162\u6162\u7684\u88ab\u5927\u4f17\u6240\u63a5\u53d7\u3002<\/p>\n<p>1999 \u5e74\uff0cMichael Widenius \u6210\u7acb\u4e86 MySQL AB \u516c\u53f8\uff0cMySQL \u7531\u4e2a\u4eba\u5f00\u53d1\u8f6c\u53d8\u4e3a\u56e2\u961f\u5f00\u53d1\uff0c2000 \u5e74\u4f7f\u7528 GPL \u534f\u8bae\u5f00\u6e90\u3002<\/p>\n<p>2010 \u5e74 12 \u6708\uff0cMySQL 5.5 \u53d1\u5e03\uff0cOracle \u4e5f\u628a InnoDB \u505a\u6210\u4e86 MySQL \u9ed8\u8ba4\u7684\u5b58\u50a8\u5f15\u64ce\uff0cMySQL \u4ece\u6b64\u8fdb\u5165\u4e86\u8f89\u714c\u53d1\u5c55\u7684\u65f6\u671f\u3002<\/p>\n<p>2015\u5e7410\u6708\uff0cMySQL 5.7 \u7248\u672c\u53d1\u5e03\uff0c\u5b83\u5e26\u6765\u5f88\u591a\u65b0\u7684\u7279\u6027\uff0c\u6bd4\u5982\uff1a\u9ed8\u8ba4\u5f15\u64ce\u6539\u6210\u4e86InnoDB\uff0c\u66f4\u65b0\u4e86\u5b89\u5168\u7b56\u7565\uff0c\u6027\u80fd\u65b9\u9762\u7684\u63d0\u5347\uff0c\u65b0\u589eJSON\u6570\u636e\u7c7b\u578b\uff0c\u589e\u5f3a\u4e86sql\u6a21\u5f0f\u53ca\u7528\u6237\u6743\u9650\u7b49\u7b49\u5f3a\u5927\u7684\u529f\u80fd\u3002\u56e0\u6b64\uff0c\u8fd9\u4e2a\u7248\u672c\u81ea\u4ece\u53d1\u5e03\u4e4b\u540e\u4e00\u76f4\u53d7\u5230\u4e1a\u754c\u7684\u6b22\u8fce\uff0c\u4e5f\u6210\u4e3a\u4e86\u4f17\u591a\u5f00\u53d1\u8005\u7684\u9996\u9009\u6570\u636e\u5e93\u7248\u672c\u3002<\/p>\n<p>2018\u5e744\u6708\uff0cMySQL 8.0 \u6b63\u5f0f\u53d1\u5e03\u3002  <\/p>\n<p>\u4e0b\u9762\u6211\u4eec\u4e00\u540c\u56de\u987e\u4e00\u4e0b\u5404\u5927\u7248\u672c\u7684\u751f\u547d\u5468\u671f\uff0c\u91cd\u6e29\u4e00\u4e0b\u8fd9\u4e9b\u7ecf\u5178\u7684\u7248\u672c\u3002<\/p>\n<h2>MySQL \u5927\u7248\u672c\u751f\u547d\u5468\u671f<\/h2>\n<p>\u4e0b\u9762\u662f\u5404\u4e2a\u7248\u672c\u7684\u751f\u547d\u5468\u671f\u65f6\u95f4\u8303\u56f4\uff1a<\/p>\n<pre><code>Release\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Release\u00a0Date\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0End\u00a0of\u00a0life\u00a0\u00a0MySQL\u00a08.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0April\u00a019,\u00a02018\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MySQL\u00a05.7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0October\u00a021,\u00a02015\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0October\u00a021,\u00a02023\u00a0\u00a0MySQL\u00a05.6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0February\u00a05,\u00a02013\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0February\u00a05,\u00a02021\u00a0\u00a0MySQL\u00a05.5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0December\u00a03,\u00a02010\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0December\u00a03,\u00a02018\u00a0\u00a0MySQL\u00a05.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0November\u00a014,\u00a02008\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0December\u00a031,\u00a02013\u00a0MySQL\u00a05.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0January\u00a09,\u00a02012<\/code><\/pre>\n<p>\u4e0b\u9762\u662f\u6765\u81ea\u5b98\u65b9\u7ed9\u51fa\u7684\u4e00\u4efd\u751f\u547d\u5468\u671f\u6570\u636e\uff1a<img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044194431\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\" loading=\"lazy\">\u5728 2023 \u5e74 10 \u6708 21 \u65e5\uff0cMySQL 5.7 \u5c06\u8fbe\u5230\u5176\u751f\u547d\u5468\u671f\u7684\u7ec8\u70b9\uff08EOL,End of Life\uff09\u3002\u8fd9\u610f\u5473\u7740 Oracle \u5c06\u4e0d\u518d\u4e3a MySQL 5.7 \u63d0\u4f9b\u5b98\u65b9\u66f4\u65b0\u3001\u9519\u8bef\u4fee\u590d\u6216\u5b89\u5168\u8865\u4e01\u3002<\/p>\n<p>\u56e0\u6b64\uff0c\u968f\u7740 MySQL 5.7 EOL \u5230\u6765\uff0c\u6211\u4eec\u5347\u7ea7\u5230\u4e00\u4e2a\u66f4\u9ad8\u7684\u65b0\u7248\u672c\uff0c\u8fd9\u6837\u4fbf\u4e8e\u5f97\u5230\u5b98\u65b9\u66f4\u597d\u7684\u66f4\u65b0\u652f\u6301\uff0c\u5e94\u8be5\u6765\u8bf4\u662f\u4e00\u4e2a\u6700\u7b80\u5355\u3001\u6700\u76f4\u63a5\u7684\u65b9\u6848\u3002<\/p>\n<p>\u4f46\u662f\uff0c\u6211\u4eec\u662f\u5426\u6709\u5176\u4ed6\u9009\u62e9\u5462\uff1f\u53ef\u4ee5\u5bfb\u627e\u4e00\u4e2a\u66f4\u52a0\u5b8c\u7f8e\u7684\u66ff\u4ee3\u65b9\u6848\u5462\uff1f\u6211\u60f3\uff0c\u8fd8\u662f\u9700\u8981\u53bb\u5b9e\u9645\u7684\u751f\u4ea7\u9700\u6c42\u51fa\u53d1\uff0c\u5bf9\u4e8e\u6570\u636e\u5e93\u6765\u8bf4\uff0c\u5b89\u5168\u662f\u7b2c\u4e00\u8981\u52a1\u3002\u4e0d\u80fd\u56e0\u4e3a\u8fc1\u79fb\u5bfc\u81f4\u6570\u636e\u5b89\u5168\u4e8b\u6545\uff0c\u8fd9\u5c31\u5f97\u4e0d\u507f\u5931\u4e86\u3002<\/p>\n<h4>MySQL \u5404\u4e2a\u7248\u672c\u4f7f\u7528\u5360\u6bd4<\/h4>\n<p><img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044194432\" alt=\"\u56fe\u7247\" title=\"\u56fe\u7247\" loading=\"lazy\"><\/p>\n<p>\u60f3\u5b66\u4e60\u66f4\u591a\u7684MySQL\u6570\u636e\u5e93\u7684\u77e5\u8bc6\u4f53\u7cfb\u53ef\u4ee5\u6765\u4e13\u680f\uff1a<a target=\"_blank\" href=\"https:\/\/link.segmentfault.com\/?enc=svq3aYUe5nE5nzk1ixsTYQ%3D%3D.uKjQnK9HsTW9c8sC6EHwAfaqB8HgD5wAHZdr6QxxgsYkNTs2dH5QxXmDzj9tW3Uaxrl2W19nEIrVNXb2Rdqzvvt3RZ0UVRL7RARJNUJLspwYiWVXSQd7%2B5cwfzSLBYR6sjndDBmzm85a3bL%2FjLjBLBRwudtl3L%2FXE9vKRVWOyy5ndM7kKCbAwFWz5bh2XRBklYpNQv1ww1ImKD5esUTPiY5JY4x46xXf3F3mvEheCQ94GU37oZ5ia1%2FKpDJrnwNeVFYEmJRoDR%2BrLnd6Qgv9LXGXiuFmitKABDo6DA513oIGE2plGn8j5j8qU9FZQIRZTM96IDjSyoh1doOUIpf0aA%3D%3D\" rel=\"noopener noreferrer\">MySQL \u6253\u602a\u5347\u7ea7\u8fdb\u9636\u6210\u795e\u4e4b\u8def\uff082023 \u6700\u65b0\u7248\uff09<\/a>\uff01\u4ece\u7b2c\u4e00\u7bc7\u6587\u7ae0\u5f00\u59cb\uff0c\u6211\u4eec\u9010\u6b65\u8be6\u7ec6\u4ecb\u7ecd\u4e86 MySQL \u6570\u636e\u5e93\u7684\u57fa\u7840\u77e5\u8bc6\uff0c\u5982\uff1a\u6570\u636e\u7c7b\u578b\u3001\u5b58\u50a8\u5f15\u64ce\u3001\u6027\u80fd\u4f18\u5316\uff08\u8f6f\u3001\u786c\u53casql\u8bed\u53e5\uff09\uff0cMySQL \u6570\u636e\u5e93\u7684\u9ad8\u53ef\u7528\u67b6\u6784\u7684\u90e8\u5206\uff0c\u5982\uff1a\u4e3b\u4ece\u540c\u6b65\u3001\u8bfb\u5199\u5206\u79bb\u7684\u539f\u7406\u4e0e\u5b9e\u8df5\u3001\u8de8\u57ce\u5bb9\u707e\u3001\u6570\u636e\u7684\u5907\u4efd\u4e0e\u6062\u590d\u7b49\uff0c\u7136\u540e\u4ecb\u7ecd\u4e86 MySQL \u7684\u7ba1\u7406\u547d\u4ee4\u3001\u6570\u636e\u5e93\u8bed\u8a00\u7684\u547d\u4ee4\u3001\u5e93\u4e0e\u8868\u7684\u7ba1\u7406\u5de5\u5177\u3001\u6027\u80fd\u5206\u6790\u4e0e\u5de5\u5177\u7684\u4f7f\u7528\u3001MySQL \u6570\u636e\u5e93\u670d\u52a1\u5668\u7684\u786c\u4ef6\u9009\u578b\u3001\u6027\u80fd\u76d1\u63a7\u3001\u5f00\u53d1\u8bbe\u8ba1\u89c4\u8303\u7b49\u77e5\u8bc6\u3002<\/p>\n<h2>\u5347\u7ea7 Or \u8fc1\u79fb\uff1f<\/h2>\n<h4>\u5347\u7ea7\u52308.0\u7248\u672c<\/h4>\n<p>\u4e0a\u9762\u4e5f\u63d0\u5230\u4e86\uff0c\u8fd9\u662f\u6700\u76f4\u63a5\u3001\u6700\u5b89\u5168\u3001\u6700\u65b9\u4fbf\u7684\u4e00\u79cd\u65b9\u6848\u3002\u5347\u7ea7\u4e4b\u524d\u60f3\u8981\u4e86\u89e38.0\u7248\u672c\u7279\u6027\u7684\u53ef\u4ee5\u53c2\u9605\uff1a<a target=\"_blank\" href=\"https:\/\/link.segmentfault.com\/?enc=zmjPImL%2FoHScPNui39Gc6w%3D%3D.i0yGdXUGpX5KoYKlcNlIumefhSZfy5QB8ma7shxWGC0efCkbPgV2DBp7tU4LlQHhJ4A1be6hLZGgeuu42MFz6WqL0ARqKmbw4uUG9MN5sIcsuwlhwgHFjZUJ8DONn9ufZlsIq0sgLzmzeQ6IxVM%2Fe7Lk6fummh0UxgFVNU%2BsPbi5FBwDRcUTgh1lDcdi%2Bj5Xz5wnemhDeS%2FoY6zjk2AlMQav0lOMieMdBOIaMGCDtb9dBqc6%2Fi5ziuiHP1IMogaIvWnLJW91rWRxOVTXHILcJL7MD7D2YyLKiz6WqwzUQfcJIBv0T29C8j%2BZXr8UwttegD6LrulUvVgYdODZVcmU5Q%3D%3D\" rel=\"noopener noreferrer\">MySQL 8.0 \u7684 5 \u4e2a\u65b0\u7279\u6027\uff0c\u592a\u5b9e\u7528\u4e86<\/a>\uff01MySQL \u4ece\u7248\u672c 5.7 \u5f00\u59cb\u63d0\u4f9b\u4e86 NoSQL \u5b58\u50a8\u7684\u529f\u80fd\uff0c\u5728 8.0 \u4e2d\u8fd9\u90e8\u5206\u529f\u80fd\u4e5f\u5f97\u5230\u4e86\u4e00\u4e9b\u6539\u8fdb\uff08<a target=\"_blank\" href=\"https:\/\/link.segmentfault.com\/?enc=HaOp3NlqFjUcv7UjwrbU1A%3D%3D.fDOXbPhhO0dJ544m1ruf42EstgNazn4zmilIk2oGODUwYh7k3ConyTy1VotCDXeUKKbhGkwecDqAWFg4ZWPJckgACkqcQXpdZbg5wy1GkmSbm7M%2BZdWYBQFyth%2Ban%2Bt0qMegvgmoPn4spiTNZA2uezJ0u2Pta29VdUYMl%2F7mudVzAkzE8SfyaVrMGOhu%2FZT974Nhureulr3LH8AYF7nSh1HopfEYceGu%2B7j4WSJtB4XijhQTZD7C2S1R1wfBZWLtk5TVj%2F2uBoiONxG%2F7CC%2Fpd9GtyngvsuxIjHiVJ0Tqz8%3D\" rel=\"noopener noreferrer\">MySQL 5.7 vs 8.0\uff0c\u54ea\u4e2a\u6027\u80fd\u66f4\u725b\uff1f<\/a>\uff09\u3002<\/p>\n<p>\u5347\u7ea7\u8fc7\u7a0b\u5927\u6982\u5982\u4e0b\uff1a<\/p>\n<h6>\u4e0b\u8f7d\u5b89\u88c5\u5305<\/h6>\n<p>\u4e0b\u8f7d\u5730\u5740\uff1a<a target=\"_blank\" href=\"https:\/\/link.segmentfault.com\/?enc=c6cuO62Lv8U7I1IQSYn%2BXg%3D%3D.3jiWACxeWJE8y7C7t%2BvokugQBR%2FKgfpo%2BFUs0UKk4WgymNvdf%2BoY3FFIFs7yxnix\" rel=\"noopener noreferrer\">https:\/\/downloads.mysql.com\/archives\/community\/<\/a>\uff0c\u6ce8\uff1a\u5982\u679c\u662f\u96c6\u7fa4\u9ad8\u53ef\u7528\u67b6\u6784\uff0c\u5148\u5347\u7ea7\u4ece\u5e93\u3002<\/p>\n<h6>\u5907\u4efd\u6570\u636e<\/h6>\n<p>\u8fd9\u662f\u5fc5\u987b\u8981\u505a\u7684\uff0c\u4e00\u5b9a\u8981\u5907\u4efd\u6570\u636e\uff0c\u5907\u4efd\u5b8c\u6210\u540e\u4e00\u5b9a\u8981\u68c0\u67e5\u6570\u636e\u7684\u5b8c\u6574\u6027\u3002<\/p>\n<h6>\u5347\u7ea7<\/h6>\n<p>\u5efa\u8bae\u5148\u5728\u6d4b\u8bd5\u73af\u5883\u8fdb\u884c\u5347\u7ea7\u7248\u672c\u6d4b\u8bd5\uff0c\u6d4b\u8bd5\u5b8c\u6210\u4e4b\u540e\u518d\u8fdb\u884c\u751f\u4ea7\u73af\u5883\u7684\u7248\u672c\u5347\u7ea7\u64cd\u4f5c\u3002<\/p>\n<pre><code>#\u4e0b\u8f7d\u5b89\u88c5\u5305\n[root@localhost] wget https:\/\/downloads.mysql.com\/archives\/get\/p\/23\/file\/mysql-8.0.30-1.el7.x86_64.rpm-bundle.tar\n \n#\u89e3\u538b\u6587\u4ef6\n[root@localhost] tar zxvf mysql-8.0.30-el7-x86_64.tar.gz -C \/usr\/local\/mysql8.0\/\n \n#\u66f4\u6539\u76ee\u5f55\u5c5e\u6027\n[root@localhost] chown -R mysql.mysql \/usr\/local\/mysql8.0\/<\/code><\/pre>\n<p>\u4fee\u6539\u914d\u7f6e\u6587\u4ef6<\/p>\n<pre><code># \u7f16\u8f91\u914d\u7f6e\u6587\u4ef6\n[root@localhost] vim \/etc\/my.cnf\n \n[client]\nport=3306\nsocket=\/tmp\/mysql.sock\n \n[mysqld]\nlog-bin=mysql-bin\nserver-id=100\ncharacter_set_server=utf8\ninit_connect='SET NAMES utf8'\nsocket=\/tmp\/mysql.sock\nlog-error=\/var\/log\/mysqld.log\npid-file=\/run\/mysqld\/mysqld.pid\n#\u4e0d\u533a\u5206\u5927\u5c0f\u5199\nlower_case_table_names =1\n \nsql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION\n \nmax_connections=5000\ndefault-time_zone = '+8:00'\nmax_allowed_packet = 32M\n \n#mysql8.0\ncollation-server=utf8_general_ci\nbasedir=\/usr\/local\/mysql8.0\ndatadir=\/usr\/local\/mysql\/data\nskip_ssl\ndefault_authentication_plugin=mysql_native_password<\/code><\/pre>\n<p>\u5347\u7ea7<\/p>\n<pre><code>#\u767b\u5f55\u65e7\u7248\u672c\u7684\u6570\u636e\u5e93\n[root@localhost] mysql -uroot -p'123456'\n \n#\u67e5\u770bmysql\u7248\u672c\nmysql&gt; select version();\n+------------+\n| version()  |\n+------------+\n| 5.7.23-log |\n+------------+\n1 row in set (0.00 sec)\n \nmysql&gt; show variables like 'innodb_fast_shutdown';\n+----------------------+-------+\n| Variable_name        | Value |\n+----------------------+-------+\n| innodb_fast_shutdown | 1     |\n+----------------------+-------+\n1 row in set (0.00 sec)\n \n#\u786e\u4fdd\u6570\u636e\u90fd\u5237\u5230\u786c\u76d8\u4e0a\uff0c\u66f4\u6539\u62100\nmysql&gt; set global innodb_fast_shutdown=0;\nQuery OK, 0 rows affected (0.00 sec)\n \nmysql&gt; shutdown;\nQuery OK, 0 rows affected (0.00 sec)\nmysql&gt; exit;\nBye<\/code><\/pre>\n<p>\u4f7f\u7528\u5b89\u5168\u6a21\u5f0f\u542f\u52a8MySQL 8.0<\/p>\n<pre><code>#\u542f\u52a8\u65b0\u7248\u672c\u6570\u636e\u5e93\n[root@localhost] \/usr\/local\/mysql8\/bin\/mysqld_safe --defaults-file=\/etc\/my.cnf --user=mysql &amp;\n \n#\u767b\u5f55\u65b0\u7248\u672c\u6570\u636e\u5e93\n[root@localhost] mysql -uroot -p'123456'\nmysql&gt; select version();\n+-----------+\n| version() |\n+-----------+\n| 8.0.33    |\n+-----------+\n1 row in set (0.00 sec)\n \nmysql&gt; exit;\nBye<\/code><\/pre>\n<p>\u914d\u7f6e\u73af\u5883\u53d8\u91cf<\/p>\n<pre><code>[root@localhost]\u00a0vim\u00a0\/etc\/profile\n#\u589e\u52a0\u4e0b\u9762\u7684\u5185\u5199export\u00a0PATH=$PATH:\/usr\/local\/mysql8\/bin\n[root@localhost]\u00a0source\u00a0\/etc\/profile<\/code><\/pre>\n<p>\u67e5\u770b\u5ba2\u6237\u7aef\u7248\u672c<\/p>\n<pre><code>[root@localhost] which mysql\n\/usr\/local\/mysql8\/bin\/mysql\n[root@localhost] mysql -V\nmysql  Ver 8.0.33 for Linux on x86_64 (MySQL Community Server - GPL)<\/code><\/pre>\n<p>\u5347\u7ea7\u8fc7\u7a0b\u4e2d\u80af\u5b9a\u4f1a\u51fa\u73b0\u4e00\u4e9b\u9519\u8bef\uff0c\u9047\u5230\u9519\u8bef\u5c31\u6839\u636e\u63d0\u793a\u6765\u89e3\u51b3\u5c31\u53ef\u4ee5\u3002\u6bcf\u4e00\u6b21\u7684\u5b89\u88c5\u3001\u5347\u7ea7\u90fd\u662f\u4e00\u4e2a\u5b66\u4e60\u8fdb\u6b65\u7684\u8fc7\u7a0b\u3002\u5347\u7ea7\u5b8c\u6210\u4e4b\u540e\uff0c\u5bfc\u5165\u6570\u636e\uff0c\u8bb0\u5f97\u4fee\u6539\u6570\u636e\u5e93\u7684\u5bc6\u7801\u3002<\/p>\n<pre><code>mysql&gt;\u00a0ALTER\u00a0USER\u00a0'root'@'localhost'\u00a0IDENTIFIED\u00a0WITH\u00a0MYSQL_NATIVE_PASSWORD\u00a0BY\u00a0'xxxxx';<\/code><\/pre>\n<h4>\u8fc1\u79fb<\/h4>\n<p>\u8fd1\u6b64\u5e74\u6765\uff0c\u8d8a\u6765\u8d8a\u591a\u7684\u5f00\u53d1\u4eba\u5458\u503e\u5411\u4e8e\u4e3a\u4ed6\u4eec\u6b63\u5728\u5f00\u53d1\u7684\u5e94\u7528\u7a0b\u5e8f\u9009\u62e9 PostgreSQL\u3002\u4ece\u76f8\u5173\u7684\u6570\u636e\u6765\u770b\uff0cPostgreSQL \u4ece 2014 \u5e74\u5f00\u59cb\u8fdb\u5165\u9ad8\u901f\u589e\u957f\u72b6\u6001\uff0c\u800c MySQL \u81ea 2016 \u5e74\u4ee5\u6765\u5f00\u59cb\u7f13\u6162\u4e0b\u964d\u3002<\/p>\n<p>\u76ee\u524d PostgreSQL \u53ef\u4ee5\u8fd0\u884c\u5728\u6240\u6709\u4e3b\u6d41\u64cd\u4f5c\u7cfb\u7edf\u4e0a\uff0c\u5305\u62ec Linux\u3001Unix \u548c Windows\u3002\u6240\u4ee5\uff0c\u6709\u4e0d\u5c11\u4f01\u4e1a\u4f1a\u9009\u62e9\u5c06 MySQL \u8fc1\u79fb\u5230 PostgreSQL \u3002<\/p>\n<p>\u76f8\u8f83\u4e8e MySQL\uff0cPostgreSQL \u8fd8\u6709\u4e00\u4e9b\u660e\u663e\u7684\u7279\u70b9\uff0c\u6bd4\u5982\uff0c\u652f\u6301\u66f4\u5e7f\u6cdb\u7684\u9ad8\u7ea7\u6570\u636e\u7c7b\u578b\uff0c\u66f4\u7cbe\u7ec6\u7684\u7d22\u5f15\u7cfb\u7edf\uff0c\u652f\u6301\u7528\u5404\u79cd\u8bed\u8a00\u7f16\u5199\u7684\u5b58\u50a8\u8fc7\u7a0b\uff0c\u4e5f\u786e\u5b9e\u80fd\u591f\u6ee1\u8db3\u7edd\u5927\u591a\u6570\u4f01\u4e1a\u7ea7\u5e94\u7528\u7684\u9700\u6c42\u3002<\/p>\n<p>MySQL \u4e0e PostgreSQL \u6bd4\u8f83\uff0c<a target=\"_blank\" href=\"https:\/\/link.segmentfault.com\/?enc=eQ2Ym1IPZDg48r7BH6Viow%3D%3D.HzFit9%2F4kuqhx9cHIyIFTxbRZxxUlm0PJ1t7461IVmyPKklzxNI6ZvqHYFu85A18rEADdXOKUvFuivYv9trizfOsYq%2BznW8C15teTwM6s0Z17bOIZnDIzKmDXwMFLByPhafHFqWi40QHNdAOeEA14T3T%2Bz%2Bp45fTcstLjxSBP9ayd9JgbUFes35vxxj%2Fby1%2BOdLl5%2FCxCXzEulb7QR63w1HmQtxqK6hMchhsj%2FmYCXw5L0YvtWFrBrZ83CU8jWXdn0ZsexLJSDKsU%2FnnBa3umLZv9ehVOrh2yUXRH%2FrGBKyv03c0BXh2XG0sxhBjFLNMQUcB4hCfSnuBqvw3P8xjMw%3D%3D\" rel=\"noopener noreferrer\">\u54ea\u4e2a\u66f4\u597d\u3001\u6211\u4eec\u8be5\u9009\u7528\u54ea\u4e2a<\/a>\uff1f\u53ef\u4ee5\u53c2\u9605\u8fd9\u7bc7\u4e4b\u524d\u63a8\u9001\u8fc7\u7684\u6587\u7ae0\u3002\u540c\u6837 PostgreSQ \u4e5f\u6709\u5b83\u4e0d\u9002\u7528\u7684\u573a\u666f\uff0c\u6240\u4ee5\uff0c\u662f\u5426\u80fd\u591f\u6ee1\u8db3\u4f60\u7684\u8fc1\u79fb\u9700\u6c42\uff0c\u4e0d\u80fd\u4e00\u6982\u800c\u8bba\uff0c\u800c\u662f\u8981\u4ece\u5b9e\u9645\u7684\u4e1a\u52a1\u573a\u666f\u51fa\u53d1\u3002<\/p>\n<p>\u66f4\u591a\u5173\u4e8e PostgreSQL \u7cfb\u5217\u7684\u5b66\u4e60\u6587\u7ae0\uff0c\u8bf7\u53c2\u9605\uff1a<a target=\"_blank\" href=\"https:\/\/link.segmentfault.com\/?enc=RmA1FphLB%2FdjBnS4T7q1Fg%3D%3D.n%2BggmdhriYN7SRHraqU2hDfTQdV3NxjI0C9IpZ3U6HaQU%2FmwgGXwdqMSrdtfnqxfs%2BfFYhkpsMQvDGAIQUzp925iv41DI2pgrcS%2FdWb%2BMQ9wx5Kxov71R0yjDozBwjzgdR%2F7DZKgYVksmOPvV4Ca%2BMewsJ%2FWTxPV4eD8QhzdP1U%3D\" rel=\"noopener noreferrer\">PostgreSQL \u6570\u636e\u5e93<\/a> \u8fd9\u4e2a\u4e13\u680f\u3002\u5b98\u7f51\u5730\u5740: <a target=\"_blank\" href=\"https:\/\/link.segmentfault.com\/?enc=fdqQQt27VfxMdkfmaiDq8g%3D%3D.eCFM9CRMgwVS5VES5aWttYG0a%2BZ6UFK6q8wnQ9HyY9I%3D\" rel=\"noopener noreferrer\">https:\/\/www.postgresql.org<\/a>\u3002<\/p>\n<p>\u65e0\u8bba\u4f60\u6700\u7ec8\u662f\u9009\u62e9\u5347\u7ea7\u7248\u672c\uff0c\u8fd8\u662f\u5bfb\u6c42\u66ff\u4ee3\u65b9\u6848\uff0c\u6211\u4e0d\u5f97\u4e0d\u518d\u6b21\u63d0\u9192\u4f60\uff0cMySQL5.7 \u5728 2023 \u5e74 10 \u6708\u5c06\u7ed3\u675f\u652f\u6301\uff0c\u4e4b\u540e\u5b98\u65b9\u5c06\u4e0d\u4f1a\u63d0\u4f9b\u4efb\u4f55\u8865\u4e01\u66f4\u65b0\uff0c\u4e3a\u4e86\u6570\u636e\u5b89\u5168\u4e0e\u6570\u636e\u5e93\u7684\u7a33\u5b9a\uff0c\u8bf7\u63d0\u524d\u505a\u597d\u9884\u5907\u65b9\u6848\u3002<\/p>\n<p>\u6211\u4eec\u4e5f<strong>\u662f\u65f6\u5019\u548c MySQL 5.7 \u8bf4\u518d\u89c1\u4e86\uff01\uff01\uff01\uff01<\/strong><\/p>\n<p><a href=\"https:\/\/segmentfault.com\/a\/1190000044194426\">https:\/\/segmentfault.com\/a\/1190000044194426<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5bf9\u4ece\u4e8b\u4e92\u8054\u7f51 IT \u6280\u672f\u5c97\u4f4d\u7684\u6765\u8bf4\uff0c\u6570\u636e\u5e93\u4e5f\u662f\u6211\u4eec\u65e5\u5e38\u5fc5\u5907\u7684\u6280\u80fd\u4e4b\u4e00\uff0c\u800c MySQL \u6570\u636e\u5e93\u66f4\u662f\u5e38\u89c1\u3001\u5e38\u7528\u7684\u6570 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10008253","post","type-post","status-publish","format-standard","hentry","category-share"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10008253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10008253"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10008253\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10008253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10008253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10008253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}