{"id":101,"date":"2022-10-23T19:31:53","date_gmt":"2022-10-23T11:31:53","guid":{"rendered":"https:\/\/www.muxuetianyin.cn\/?p=101"},"modified":"2024-04-14T23:30:32","modified_gmt":"2024-04-14T15:30:32","slug":"%e8%bd%af%e4%bb%b6%e5%ae%89%e8%a3%85mysql","status":"publish","type":"post","link":"https:\/\/www.muxuetianyin.cn\/?p=101","title":{"rendered":"\u8f6f\u4ef6\u5b89\u88c5MYSQL"},"content":{"rendered":"\n<p class=\"has-large-font-size\">MYSQL<\/p>\n\n\n\n<p>\u8fdb\u5165\u5b98\u7f51<\/p>\n\n\n\n<p><a href=\"https:\/\/www.mysql.com\/\"><code>https:\/\/www.mysql.com\/<\/code><\/a><\/p>\n\n\n\n<p>\u9009\u62e9downloads<\/p>\n\n\n\n<p>\u8fdb\u5165\u4e0b\u8f7d\u9875\u9762 \u9009\u62e9\u4f01\u4e1a\u7248\u548c\u793e\u533a\u7248\u672c,\u4e00\u822c\u90fd\u662f\u9009\u62e9\u793e\u533a\u514d\u8d39<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-13-1024x808.png'><img loading=\"lazy\" width=\"1024\" height=\"808\" src=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-13-1024x808.png\" alt=\"\" class=\"wp-image-588\" srcset=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-13-1024x808.png 1024w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-13-300x237.png 300w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-13-768x606.png 768w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-13.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-14-1024x712.png'><img loading=\"lazy\" width=\"1024\" height=\"712\" src=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-14-1024x712.png\" alt=\"\" class=\"wp-image-589\" srcset=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-14-1024x712.png 1024w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-14-300x209.png 300w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-14-768x534.png 768w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-14.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-15-1024x644.png'><img loading=\"lazy\" width=\"1024\" height=\"644\" src=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-15-1024x644.png\" alt=\"\" class=\"wp-image-590\" srcset=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-15-1024x644.png 1024w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-15-300x189.png 300w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-15-768x483.png 768w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-15.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>nothanks \u4e0d\u9700\u8981\u767b\u5f55<\/p>\n\n\n\n<p>\u4e0b\u8f7d\u5b8c\u6bd5\u5f00\u59cb\u5b89\u88c5<\/p>\n\n\n\n<p>1,\u63a5\u53d7\u534f\u8bae\u8fdb\u884c\u4e0b\u4e00\u6b65<\/p>\n\n\n\n<p>2.\u9009\u62e9\u9ed8\u8ba4\u5b89\u88c5<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-16-1024x760.png'><img loading=\"lazy\" width=\"1024\" height=\"760\" src=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-16-1024x760.png\" alt=\"\" class=\"wp-image-591\" srcset=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-16-1024x760.png 1024w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-16-300x223.png 300w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-16-768x570.png 768w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-16.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>\u9009\u62e9\u4e0b\u4e00\u6b65\u5c31\u53ef\u4ee5<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-18-1024x805.png'><img loading=\"lazy\" width=\"1024\" height=\"805\" src=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-18-1024x805.png\" alt=\"\" class=\"wp-image-593\" srcset=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-18-1024x805.png 1024w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-18-300x236.png 300w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-18-768x603.png 768w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-18.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>\u4e00\u822c\u9ed8\u8ba4\u8bd5\u7528\u5f3a\u7684\u5bc6\u7801\u9a8c\u8bc1<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-19-1024x792.png'><img loading=\"lazy\" width=\"1024\" height=\"792\" src=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-19-1024x792.png\" alt=\"\" class=\"wp-image-594\" srcset=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-19-1024x792.png 1024w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-19-300x232.png 300w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-19-768x594.png 768w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-19.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-20-1024x780.png'><img loading=\"lazy\" width=\"1024\" height=\"780\" src=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-20-1024x780.png\" alt=\"\" class=\"wp-image-595\" srcset=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-20-1024x780.png 1024w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-20-300x228.png 300w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-20-768x585.png 768w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-20.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<p>\u8fd9\u662f\u6700\u65b0\u7248\u7684\uff0c\u4e5f\u53ef\u4ee5\u9009\u62e9\u5b89\u88c55.7\u7248\uff08\u5f88\u591a\u4f01\u4e1a\u7684\u9009\u62e9\uff09<\/p>\n\n\n\n<p>\u4e0b\u8f7d<\/p>\n\n\n\n<p><a href=\"https:\/\/downloads.mysql.com\/archives\/community\/\">https:\/\/downloads.mysql.com\/archives\/community\/<\/a><\/p>\n\n\n\n<p>\u70b9\u5f00\u4e0a\u9762\u7684\u94fe\u63a5\u5c31\u80fd\u770b\u5230\u5982\u4e0b\u754c\u9762<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><div class='fancybox-wrapper' data-fancybox='post-images' href='https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-17-1024x470.png'><img loading=\"lazy\" width=\"1024\" height=\"470\" src=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-17-1024x470.png\" alt=\"\" class=\"wp-image-592\" srcset=\"https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-17-1024x470.png 1024w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-17-300x138.png 300w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-17-768x352.png 768w, https:\/\/www.muxuetianyin.cn\/wp-content\/uploads\/2024\/03\/image-17.png 1153w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/div><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">\u5b89\u88c5(\u89e3\u538b)<\/h4>\n\n\n\n<p>\u4e0b\u8f7d\u5b8c\u6210\u540e\u6211\u4eec\u5f97\u5230\u7684\u662f\u4e00\u4e2a\u538b\u7f29\u5305\uff0c\u5c06\u5176\u89e3\u538b\uff0c\u6211\u4eec\u5c31\u53ef\u4ee5\u5f97\u5230MySQL 5.7.24\u7684\u8f6f\u4ef6\u672c\u4f53\u4e86(\u5c31\u662f\u4e00\u4e2a\u6587\u4ef6\u5939)\uff0c\u6211\u4eec\u53ef\u4ee5\u628a\u5b83\u653e\u5728\u4f60\u60f3\u5b89\u88c5\u7684\u4f4d\u7f6e<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL\u5378\u8f7d<\/h3>\n\n\n\n<p>\u5982\u679c\u4f60\u60f3\u5378\u8f7dMySQL\uff0c\u4e5f\u5f88\u7b80\u5355\u3002<\/p>\n\n\n\n<p>\u53f3\u952e\u5f00\u59cb\u83dc\u5355\uff0c\u9009\u62e9<code>\u547d\u4ee4\u63d0\u793a\u7b26(\u7ba1\u7406\u5458)<\/code>\uff0c\u6253\u5f00\u9ed1\u6846<\/p>\n\n\n\n<ol>\n<li>\u6572\u5165<code>net stop mysql<\/code>\uff0c\u56de\u8f66\u3002<\/li>\n\n\n\n<li>\u518d\u6572\u5165<code>mysqld -remove mysql<\/code>\uff0c\u56de\u8f66<\/li>\n\n\n\n<li>\u6700\u540e\u5220\u9664MySQL\u76ee\u5f55\u53ca\u76f8\u5173\u7684\u73af\u5883\u53d8\u91cf<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n\n\n\n<p>\u914d\u7f6e\u73af\u5883\u53d8\u91cf<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MYSQL_HOME\nC:\\Program Files\\MySQL\\MySQL Server 8.0\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>%MYSQL_HOME%\\bin<\/code><\/pre>\n\n\n\n<p>\u8fdb\u884c\u9a8c\u8bc1 \u4f60\u53ef\u4ee5\u91cd\u542f\u7535\u8111\u5728\u8fdb\u884c\u9a8c\u8bc1<\/p>\n\n\n\n<p>\u4fdd\u8bc1\u4e25\u8c28<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql --version\n\nmysql -u root -p\n\n5.7\u7248\u672c\u521d\u59cb\u5316MySQL\n\n\u5728\u521a\u624d\u7684\u9ed1\u6846\u4e2d\u6572\u5165`mysqld --initialize-insecure`\uff0c\u56de\u8f66\uff0c\u7a0d\u5fae\u7b49\u5f85\u4e00\u4f1a\uff0c\u5982\u679c\u51fa\u73b0\u6ca1\u6709\u51fa\u73b0\u62a5\u9519\u4fe1\u606f(\u5982\u4e0b\u56fe)\u5219\u8bc1\u660edata\u76ee\u5f55\u521d\u59cb\u5316\u6ca1\u6709\u95ee\u9898\uff0c\u6b64\u65f6\u518d\u67e5\u770bMySQL\u76ee\u5f55\u4e0b\u5df2\u7ecf\u6709data\u76ee\u5f55\u751f\u6210\u3002\n\u6ce8\u518cMySQL\u670d\u52a1\n\u5728\u9ed1\u6846\u91cc\u6572\u5165`mysqld -install`\uff0c\u56de\u8f66\u3002<\/code><\/pre>\n\n\n\n<p>\u542f\u52a8MySQL\u670d\u52a1<\/p>\n\n\n\n<p>\u5728\u9ed1\u6846\u91cc\u6572\u5165<code>net start mysql<\/code>\uff0c\u56de\u8f66\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>net start mysql  \/\/ \u542f\u52a8mysql\u670d\u52a1\r\n    \r\nnet stop mysql  \/\/ \u505c\u6b62mysql\u670d\u52a1<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u4fee\u6539\u9ed8\u8ba4\u8d26\u6237\u5bc6\u7801<\/h4>\n\n\n\n<p>\u5728\u9ed1\u6846\u91cc\u6572\u5165<code>mysqladmin -u root password 1234<\/code>\uff0c\u8fd9\u91cc\u7684<code>1234<\/code>\u5c31\u662f\u6307\u9ed8\u8ba4\u7ba1\u7406\u5458(\u5373root\u8d26\u6237)\u7684\u5bc6\u7801\uff0c\u53ef\u4ee5\u81ea\u884c\u4fee\u6539\u6210\u4f60\u559c\u6b22\u7684\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqladmin -u root password abcdef<\/code><\/pre>\n\n\n\n<p><strong>\u81f3\u6b64\uff0cMySQL 5.7 \u89e3\u538b\u7248\u5b89\u88c5\u5b8c\u6bd5\uff01<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MYSQL \u8fdb\u5165\u5b98\u7f51 https:\/\/www.mysql.com\/ \u9009\u62e9downloads \u8fdb\u5165\u4e0b\u8f7d\u9875\u9762 \u9009\u62e9 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[18,13],"tags":[20],"_links":{"self":[{"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=\/wp\/v2\/posts\/101"}],"collection":[{"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=101"}],"version-history":[{"count":3,"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=\/wp\/v2\/posts\/101\/revisions"}],"predecessor-version":[{"id":596,"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=\/wp\/v2\/posts\/101\/revisions\/596"}],"wp:attachment":[{"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muxuetianyin.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}