{"id":1818,"date":"2025-02-23T21:02:36","date_gmt":"2025-02-23T13:02:36","guid":{"rendered":"https:\/\/www.vmsvr.com\/wordpress\/?p=1818"},"modified":"2025-02-23T21:02:36","modified_gmt":"2025-02-23T13:02:36","slug":"mysql-windows%e5%8e%8b%e7%bc%a9%e5%8c%85%e5%ae%89%e8%a3%85","status":"publish","type":"post","link":"https:\/\/www.vmsvr.com\/wordpress\/network\/2025\/02\/23\/1818.html","title":{"rendered":"Mysql windows\u538b\u7f29\u5305\u5b89\u88c5"},"content":{"rendered":"<p>\u5c06\u5b98\u7f51\u4e0b\u8f7d\u7684MySQL\u538b\u7f29\u5305\uff08\u4e0b\u8f7d\u5730\u5740\uff1a<a href=\"https:\/\/dev.mysql.com\/downloads\/mysql\/\">https:\/\/dev.mysql.com\/downloads\/mysql\/<\/a>\uff09\u89e3\u538b\uff1a<br \/>\n\u4ee5\u7ba1\u7406\u5458\u8eab\u4efd\u8fd0\u884c cmd\uff1a<br \/>\n<code>cd \/d D:\\mysql-8.4.4-winx64\\bin<\/code><br \/>\n\u521d\u59cb\u5316MySQL<br \/>\n<code>mysqld --initialize --console<\/code><br \/>\n\u521d\u59cb\u5316\u65f6\u4f1a\u5728\u5c4f\u5e55\u663e\u793aroot\u7684\u5bc6\u7801\uff0c<br \/>\n\u5b89\u88c5MySQL\u670d\u52a1<br \/>\n<code>mysqld --install<\/code><br \/>\n\u540e\u7eed\u5373\u53ef\u5f00\u673a\u81ea\u52a8\u542f\u52a8<\/p>\n<p>\u5982\u679c\u63d0\u793aERROR 1524 (HY000): Plugin &#8216;mysql_native_password&#8217; is not loaded<br \/>\nMySQL\u542f\u52a8\u53c2\u6570\u53ef\u4ee5\u52a0\u4e0a\uff1a<br \/>\n<code>mysqld --mysql-native-password=ON<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5c06\u5b98\u7f51\u4e0b\u8f7d\u7684MySQL\u538b\u7f29\u5305\uff08\u4e0b\u8f7d\u5730\u5740\uff1a<a href=\"https:\/\/dev.mysql.co\">https:\/\/dev.mysql.co<\/a> &hellip; <a href=\"https:\/\/www.vmsvr.com\/wordpress\/network\/2025\/02\/23\/1818.html\">\u7ee7\u7eed\u9605\u8bfb <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83],"tags":[77,1032],"class_list":["post-1818","post","type-post","status-publish","format-standard","hentry","category-network","tag-mysql","tag-mysql-"],"views":124,"_links":{"self":[{"href":"https:\/\/www.vmsvr.com\/wordpress\/wp-json\/wp\/v2\/posts\/1818","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vmsvr.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vmsvr.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vmsvr.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vmsvr.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1818"}],"version-history":[{"count":0,"href":"https:\/\/www.vmsvr.com\/wordpress\/wp-json\/wp\/v2\/posts\/1818\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.vmsvr.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vmsvr.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vmsvr.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}