{"id":299,"date":"2021-05-13T20:12:07","date_gmt":"2021-05-13T12:12:07","guid":{"rendered":"https:\/\/blog.zhouhonghe.com\/?p=299"},"modified":"2023-10-02T09:48:50","modified_gmt":"2023-10-02T01:48:50","slug":"windows%e4%b8%8b%e5%ae%89%e8%a3%85mysql8-0%e5%b9%b6%e8%ae%be%e7%bd%ae%e5%8f%8c%e6%9c%ba%e7%83%ad%e5%a4%87","status":"publish","type":"post","link":"https:\/\/blog.zhouhonghe.com\/?p=299","title":{"rendered":"Windows\u4e0b\u5b89\u88c5MySQL8.0\u5e76\u8bbe\u7f6e\u53cc\u673a\u70ed\u5907"},"content":{"rendered":"<p>\u521d\u59cb\u5316\uff1a<br \/>\n<code>mysqld --initialize-insecure --user=mysql<\/code><\/p>\n<p>\u5b89\u88c5\u670d\u52a1\uff1a<br \/>\n<code>mysqld -install <em><strong>MySQL-8.0.25<\/strong><\/em><\/code><\/p>\n<p>\u542f\u52a8\uff1a<br \/>\n<code>net start <em><strong>MySQL-8.0.25<\/strong><\/em><\/code><\/p>\n<p>\u767b\u5f55\uff1a<br \/>\n<code>mysql -uroot -p<\/code><\/p>\n<p>\u4fee\u6539root\u5bc6\u7801\uff1a<br \/>\n<code>alter user 'root'@'localhost' identified by '<strong><em>PWD<\/em><\/strong>';<\/code><\/p>\n<p>\u521b\u5efa\u6570\u636e\u5e93\uff1a<br \/>\n<code>create database <strong><em>DBNAME<\/em><\/strong>;<\/code><\/p>\n<p>\u521b\u5efa\u666e\u901a\u6570\u636e\u5e93\u7528\u6237\uff1a<br \/>\n<code>create user '<em><strong>USER<\/strong><\/em>'@'<em>localhost<\/em>' identified by '<em><strong>PWD<\/strong><\/em>';<\/code><\/p>\n<p>\u6388\u4e88\u6743\u9650\uff1a<br \/>\n<code>grant all privileges on <em><strong>DBNAME<\/strong><\/em>.* to '<em><strong>USER<\/strong><\/em>'@'<em>localhost<\/em>';<\/code><\/p>\n<p>\u521b\u5efa\u53cc\u673a\u540c\u6b65\u7528\u6237\uff1a<br \/>\n<code>create user '<em>replicate<\/em>'@'<em><strong>REMOTE_HOST<\/strong><\/em>' identified BY '<strong><em>PWD<\/em><\/strong>';<\/code><\/p>\n<p>\u6388\u4e88\u540c\u6b65\u6743\u9650\uff1a<br \/>\n<code>grant replication slave on *.* to '<em>replicate<\/em>'@'<em><strong>REMOTE_HOST<\/strong><\/em>';<\/code><\/p>\n<p>\u4f7f\u751f\u6548\uff1a<br \/>\n<code>flush privileges;<\/code><\/p>\n<p>\u663e\u793a\u4e3b\u5e93\u4fe1\u606f\uff1a<br \/>\n<code>show master status\\G<\/code><\/p>\n<p>\u505c\u6b62\u4ece\u5e93\uff1a<br \/>\n<code>stop slave;<\/code><\/p>\n<p>\u8bbe\u7f6e\u4e3b\u5e93\u4fe1\u606f\uff1a<br \/>\n<code>change master to master_host='<em><strong>REMOTE_HOST<\/strong><\/em>',master_port=<em><strong>3306<\/strong><\/em>,master_user='<em>replicate<\/em>',master_password='<strong><em>PWD<\/em><\/strong>',master_auto_position=1,GET_MASTER_PUBLIC_KEY=1;<\/code><\/p>\n<p>\u542f\u52a8\u4ece\u5e93\uff1a<br \/>\n<code>start slave;<\/code><\/p>\n<p>\u663e\u793a\u4ece\u5e93\u4fe1\u606f\uff1a<br \/>\n<code>show slave status\\G<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u521d\u59cb\u5316\uff1a mysqld --initialize-insecure --user=mysql \u5b89\u88c5\u670d\u52a1\uff1a my [&hellip;]<\/p>... ","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-299","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts\/299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=299"}],"version-history":[{"count":9,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts\/299\/revisions"}],"predecessor-version":[{"id":479,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=\/wp\/v2\/posts\/299\/revisions\/479"}],"wp:attachment":[{"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.zhouhonghe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}