{"id":69,"date":"2024-09-20T22:18:14","date_gmt":"2024-09-20T14:18:14","guid":{"rendered":"https:\/\/www.erishen.cn\/wordpress\/?p=69"},"modified":"2024-09-20T22:18:14","modified_gmt":"2024-09-20T14:18:14","slug":"mac-brew-mysql-issue","status":"publish","type":"post","link":"https:\/\/erishen.cn\/?p=69","title":{"rendered":"Mac Brew Mysql Issue"},"content":{"rendered":"<ul>\n<li>ERROR 1524 (HY000): Plugin &#39;mysql_native_password&#39; is not loaded<\/li>\n<\/ul>\n<p><a href=\"https:\/\/github.com\/Homebrew\/homebrew-core\/issues\/180498\">https:\/\/github.com\/Homebrew\/homebrew-core\/issues\/180498<\/a><\/p>\n<p>MySQL 9 \u4e0d\u518d\u652f\u6301 <code>mysql_native_password<\/code> \u8ba4\u8bc1\u65b9\u6cd5\uff0c\u8fd9\u53ef\u80fd\u4f1a\u5f71\u54cd\u4ece MySQL 8.x \u5347\u7ea7\u5230 MySQL 9 \u7684\u7528\u6237\u3002\u4e3a\u4e86\u89e3\u51b3\u6b64\u95ee\u9898\uff0c\u60a8\u9700\u8981\u66f4\u65b0 MySQL \u7528\u6237\u8868\uff0c\u4f7f\u7528\u65b0\u7684\u8ba4\u8bc1\u65b9\u6cd5\u3002\u6309\u7167\u4ee5\u4e0b\u6b65\u9aa4\u64cd\u4f5c\uff1a<\/p>\n<p>1.- <strong>\u7981\u7528\u6743\u9650\u8868\uff1a<\/strong><br \/>\n\u7f16\u8f91 MySQL \u914d\u7f6e\u6587\u4ef6\uff0c\u901a\u5e38\u4f4d\u4e8e <code>\/opt\/homebrew\/etc\/my.cnf<\/code>\u3002\u5728 <code>[mysqld]<\/code> \u90e8\u5206\u4e0b\u6dfb\u52a0\u4ee5\u4e0b\u884c\u4ee5\u7981\u7528\u6743\u9650\u8868\uff1a<\/p>\n<div class=\"code-toolbar\"><pre data-toolbar-order=\"copy\" data-prismjs-copy><code>[mysqld]\nskip-grant-tables\n<\/code><\/pre><\/div>\n<p>2.- <strong>\u91cd\u542f MySQL\uff1a<\/strong><br \/>\n\u4f7f\u7528 Homebrew \u91cd\u542f MySQL\uff1a<\/p>\n<div class=\"code-toolbar\"><pre data-toolbar-order=\"copy\" data-prismjs-copy><code>brew services restart mysql\n<\/code><\/pre><\/div>\n<p>3.- <strong>\u4ee5 root \u7528\u6237\u8fde\u63a5 MySQL\uff1a<\/strong><\/p>\n<div class=\"code-toolbar\"><pre data-toolbar-order=\"copy\" data-prismjs-copy><code>mysql -uroot\n<\/code><\/pre><\/div>\n<p>4.- <strong>\u66f4\u65b0\u7528\u6237\u8ba4\u8bc1\u65b9\u6cd5\uff1a<\/strong><br \/>\n\u5237\u65b0\u6743\u9650\uff1a<\/p>\n<div class=\"code-toolbar\"><pre data-toolbar-order=\"copy\" data-prismjs-copy><code>FLUSH PRIVILEGES;\n<\/code><\/pre><\/div>\n<p>5.- <strong>\u68c0\u67e5\u4f7f\u7528 <code>mysql_native_password<\/code> \u63d2\u4ef6\u7684\u7528\u6237\uff1a<\/strong><\/p>\n<div class=\"code-toolbar\"><pre data-toolbar-order=\"copy\" data-prismjs-copy><code>SELECT User, Host, plugin FROM mysql.user WHERE plugin = &#39;mysql_native_password&#39;;\n<\/code><\/pre><\/div>\n<p>6.- <strong>\u5c06 root \u7528\u6237\u66f4\u65b0\u4e3a\u4f7f\u7528 <code>caching_sha2_password<\/code> \u63d2\u4ef6\uff1a<\/strong><\/p>\n<div class=\"code-toolbar\"><pre data-toolbar-order=\"copy\" data-prismjs-copy><code>ALTER USER &#39;root&#39;@&#39;localhost&#39; IDENTIFIED WITH caching_sha2_password BY &#39;new_password&#39;;\n<\/code><\/pre><\/div>\n<p>7.- <strong>\u91cd\u65b0\u542f\u7528\u6743\u9650\u8868\uff1a<\/strong><br \/>\n\u66f4\u65b0\u540e\uff0c\u5220\u9664\u6216\u6ce8\u91ca\u6389 MySQL \u914d\u7f6e\u6587\u4ef6\u4e2d\u7684 <code>skip-grant-tables<\/code> \u884c\u3002<\/p>\n<p>8.- <strong>\u91cd\u542f MySQL \u4ee5\u5e94\u7528\u66f4\u6539\uff1a<\/strong><\/p>\n<div class=\"code-toolbar\"><pre data-toolbar-order=\"copy\" data-prismjs-copy><code>brew services restart mysql\n<\/code><\/pre><\/div>\n<p>\u901a\u8fc7\u6267\u884c\u8fd9\u4e9b\u6b65\u9aa4\uff0c\u60a8\u5e94\u8be5\u80fd\u591f\u5728\u5347\u7ea7\u5230 MySQL 9 \u540e\u89e3\u51b3\u8ba4\u8bc1\u65b9\u6cd5\u95ee\u9898\u3002<\/p>\n<ul>\n<li>err_mysqlConnect:  Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client<\/li>\n<\/ul>\n<p><a href=\"https:\/\/stackoverflow.com\/questions\/50093144\/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server\">https:\/\/stackoverflow.com\/questions\/50093144\/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server<\/a><\/p>\n<p>\u4f7f\u7528 npm \u5b89\u88c5 mysql2\uff1a<br \/>\n<a href=\"https:\/\/github.com\/sidorares\/node-mysql2\">https:\/\/github.com\/sidorares\/node-mysql2<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ERROR 1524 (HY000): Plugin &#39;mysql_native_password&#038;# [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-69","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/erishen.cn\/index.php?rest_route=\/wp\/v2\/posts\/69","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erishen.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erishen.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erishen.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erishen.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69"}],"version-history":[{"count":0,"href":"https:\/\/erishen.cn\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions"}],"wp:attachment":[{"href":"https:\/\/erishen.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erishen.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erishen.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}