{"rsdb":{"rid":"309147","subhead":"","postdate":"0","aid":"224309","fid":"119","uid":"1","topic":"1","content":"<div id=\"article_content\" class=\"article_content clearfix csdn-tracking-statistics\" data-pid=\"blog\" data-mod=\"popu_307\" data-dsm=\"post\">\n            <link rel=\"stylesheet\" href=\"https:\/\/csdnimg.cn\/release\/phoenix\/template\/css\/ck_htmledit_views-f57960eb32.css\">\n                              <div id=\"content_views\" class=\"markdown_views prism-atom-one-dark\">\n            <!-- flowchart \u7bad\u5934\u56fe\u6807 \u52ff\u5220 -->\n            <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"display: none;\">\n              <path stroke-linecap=\"round\" d=\"M5,0 0,2.5 5,5z\" id=\"raphael-marker-block\" style=\"-webkit-tap-highlight-color: rgba(0, 0, 0, 0);\"><\/path>\n            <\/svg>\n            <h4 id=\"1\u5728\u7528mysql-80-\u7248\u672c\u65f6\u8fde\u63a5\u6570\u636e\u5e93\u9047\u5230\u95ee\u9898\u63d0\u793a\u5982\u4e0b\">1.\u5728\u7528mysql 8.0 \u7248\u672c\u65f6\u8fde\u63a5\u6570\u636e\u5e93\u9047\u5230\u95ee\u9898\uff0c\u63d0\u793a\u5982\u4e0b<\/h4>\n\n\n\n<pre class=\"prettyprint\"><code class=\" hljs ruby\"><span class=\"hljs-constant\">Authentication<\/span> plugin <span class=\"hljs-string\">'caching_sha2_password'<\/span> cannot be <span class=\"hljs-symbol\">loaded:<\/span> dlopen(<span class=\"hljs-regexp\">\/usr\/local<\/span><span class=\"hljs-regexp\">\/mysql\/lib<\/span><span class=\"hljs-regexp\">\/plugin\/caching<\/span>_sha2_password.so, <span class=\"hljs-number\">2<\/span>)<span class=\"hljs-symbol\">:<\/span> image <span class=\"hljs-keyword\">not<\/span> found<\/code><\/pre>\n\n<p>\u5b57\u9762\u610f\u601d\u770b\u8d77\u6765\u4f3c\u4e4e\u662f\u8ba4\u8bc1\u63d2\u4ef6\u65e0\u6cd5\u52a0\u8f7d\uff0c\u521a\u5f00\u59cb\u4ee5\u4e3a\u662f\u8f6f\u4ef6\u7684\u95ee\u9898\uff0c\u91cd\u65b0\u4e0b\u8f7d\u4e86\u6700\u65b0\u7248\u7684\uff0c\u4ecd\u7136\u6ca1\u6709\u89e3\u51b3\u95ee\u9898\uff0c\u6700\u7ec8\u5728<a href=\"https:\/\/stackoverflow.com\/\" rel=\"nofollow\">stackoverflow<\/a>\u627e\u5230\u89e3\u51b3\u65b9\u6848\uff0c<a href=\"https:\/\/stackoverflow.com\/questions\/49194719\/authentication-plugin-caching-sha2-password-cannot-be-loaded\" rel=\"nofollow\">\u539f\u7248\u5728\u8fd9\u91cc<\/a><\/p>\n\n<p>\u3010\u89e3\u51b3\u65b9\u6848\u3011 <br>\n- 1.\u4ece\u7cfb\u7edf\u504f\u597d\u8bbe\u7f6e\u91cc\u8fb9\u6253\u5f00mysql. <br>\n- 2.\u70b9\u51fb\u201dInitialize Database\u201d  <br>\n- 3.\u8bbe\u7f6e\u5bc6\u7801\uff0c\u9009\u62e9\u201dUse legacy password\u201d\uff0c-&gt;OK <br>\n- 4.\u91cd\u542fmysql,\u6253\u5f00navicate ,\u91cd\u65b0\u8fde\u63a5\u6570\u636e\u5e93\u3002<\/p>\n\n<p><img src=\"http:\/\/ok7mrfi5x.bkt.clouddn.com\/QQ20180502-103137@2x.png\" alt=\"image\" title=\"\"><\/p>\n\n<p><img src=\"http:\/\/ok7mrfi5x.bkt.clouddn.com\/QQ20180502-103211@2x.png\" alt=\"image\" title=\"\"><\/p>          <\/div>\n          <link href=\"https:\/\/csdnimg.cn\/release\/phoenix\/mdeditor\/markdown_views-258a4616f7.css\" rel=\"stylesheet\">\n                  <\/div>","orderid":"0","title":"Authentication plugin &#39;caching_sha2_password&#39; cannot be loaded","smalltitle":"","mid":"0","fname":"Flume","special_id":"0","bak_id":"0","info":"0","hits":"259","pages":"1","comments":"0","posttime":"2019-05-16 02:08:41","list":"1557943721","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"http:\/\/ok7mrfi5x.bkt.clouddn.com\/QQ20180502-103137@2x.png","ispic":"1","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"<A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=Authentication' target=_blank>Authentication<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=plugin' target=_blank>plugin<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%26%2339' target=_blank>&#39<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=caching_sha2_password%26%2339' target=_blank>caching_sha2_password&#39<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=cannot' target=_blank>cannot<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=loaded' target=_blank>loaded<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";s:4:\"head\";s:0:\"\";}","target":"0","ip":"47.106.78.186","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"                                                                                                        1.\u5728\u7528mysql 8.0 \u7248\u672c\u65f6\u8fde\u63a5\u6570\u636e\u5e93\u9047\u5230\u95ee\u9898\uff0c\u63d0\u793a\u5982\u4e0bAuthentication plugin 'caching_sha2_password' cannot be loaded: dlopen(\/usr\/local\/mysql\/lib\/p..","lastview":"1696027461","digg_num":"28","digg_time":"1695979819","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}