{"id":624,"date":"2022-09-11T19:19:31","date_gmt":"2022-09-11T11:19:31","guid":{"rendered":"https:\/\/blog.lijiajia.top\/?p=624"},"modified":"2026-06-19T17:52:05","modified_gmt":"2026-06-19T09:52:05","slug":"win10%e5%88%b6%e4%bd%9c%e5%85%8d%e5%ae%89%e8%a3%85%e7%9a%84mysql5-7","status":"publish","type":"post","link":"https:\/\/blog.ttwow.top\/?p=624","title":{"rendered":"Win10\u5236\u4f5c\u514d\u5b89\u88c5\u7684mysql5.7"},"content":{"rendered":"<p>mysql\uff1amysql-5.7.36-winx64<\/p>\n<h2>1.\u89e3\u538b<\/h2>\n<p>\u5728bin\u76ee\u5f55\u6267\u884c\uff1a<\/p>\n<pre><code class=\"language-shell\">mysqld --initialize<\/code><\/pre>\n<p>\u751f\u6210data\u76ee\u5f55<\/p>\n<p>2.\u4e3b\u76ee\u5f55\u65b0\u589emy.ini\u914d\u7f6e\u6587\u4ef6<\/p>\n<pre><code class=\"language-shell\">[mysql]\n\n# \u8bbe\u7f6emysql\u5ba2\u6237\u7aef\u9ed8\u8ba4\u5b57\u7b26\u96c6\n\ndefault-character-set=utf8\n\n[mysqld]\n\n#\u8bbe\u7f6e3306\u7aef\u53e3\n\nport = 3306\n\n# \u8bbe\u7f6emysql\u7684\u5b89\u88c5\u76ee\u5f55\n\n#basedir=D:\\\\softnew\\\\MYSQL\\\\mysql-5.7.20-winx64\n\n# \u5141\u8bb8\u6700\u5927\u8fde\u63a5\u6570\n\nmax_connections=200\n\n# \u670d\u52a1\u7aef\u4f7f\u7528\u7684\u5b57\u7b26\u96c6\u9ed8\u8ba4\u4e3a8\u6bd4\u7279\u7f16\u7801\u7684latin1\u5b57\u7b26\u96c6\n\ncharacter-set-server=utf8\n\n# \u521b\u5efa\u65b0\u8868\u65f6\u5c06\u4f7f\u7528\u7684\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\n\ndefault-storage-engine=INNODB\n\n[mysqld]\nskip-grant-tables <\/code><\/pre>\n<p>\u8df3\u8fc7\u5bc6\u7801\u767b\u5f55<\/p>\n<h2>3.bat\u542f\u52a8<\/h2>\n<pre><code class=\"language-bash\">@echo off\n@color A\necho.\necho.\necho \u6570\u636e\u5e93\u542f\u52a8\u7a0b\u5e8f\necho.\necho.\necho \u6b63\u5728\u542f\u52a8\u6570\u636e\u5e93...\nmysql57\\bin\\mysqld.exe --console --max_allowed_packet=128M<\/code><\/pre>\n<h2>4.\u91cd\u7f6e\u5bc6\u7801<\/h2>\n<p>\u5728MySQL 5.7 password\u5b57\u6bb5\u5df2\u4ecemysql.user\u8868\u4e2d\u5220\u9664\uff0c\u65b0\u7684\u5b57\u6bb5\u540d\u662f\u201cauthenticalion_string\u201d.<br \/>\n\u9009\u62e9\u6570\u636e\u5e93\uff1a<\/p>\n<pre><code class=\"language-sql\">use mysql;<\/code><\/pre>\n<p>\u66f4\u65b0root\u7684\u5bc6\u7801\uff1a<\/p>\n<pre><code class=\"language-sql\">update user set authentication_string=password(&#039;\u65b0\u5bc6\u7801&#039;) where user=&#039;root&#039; and Host=&#039;localhost&#039;;<\/code><\/pre>\n<p>\u5237\u65b0\u6743\u9650\uff1a<\/p>\n<pre><code class=\"language-sql\">flush privileges;<\/code><\/pre>\n<h2>5.navicat\u767b\u5f55\u6570\u636e\u5e93\uff0c\u53ef\u80fd\u9700\u8981\u8bbe\u7f6e\u65b0\u5bc6\u7801<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>mysql\uff1amysql-5.7.36-winx64 1.\u89e3\u538b \u5728bin\u76ee\u5f55\u6267\u884c\uff1a mysqld &#8211;initi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[127],"tags":[58,148],"class_list":["post-624","post","type-post","status-publish","format-standard","hentry","category-database-sql","tag-mysql","tag-148"],"_links":{"self":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts\/624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=624"}],"version-history":[{"count":1,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts\/624\/revisions"}],"predecessor-version":[{"id":2021,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts\/624\/revisions\/2021"}],"wp:attachment":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}