{"rsdb":{"rid":"309147","subhead":"","postdate":"0","aid":"224309","fid":"119","uid":"1","topic":"1","content":"
\n \n
\n \n \n <\/path>\n <\/svg>\n

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
Authentication<\/span> plugin 'caching_sha2_password'<\/span> cannot be loaded:<\/span> dlopen(\/usr\/local<\/span>\/mysql\/lib<\/span>\/plugin\/caching<\/span>_sha2_password.so, 2<\/span>):<\/span> image not<\/span> found<\/code><\/pre>\n\n

\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\u5728stackoverflow<\/a>\u627e\u5230\u89e3\u51b3\u65b9\u6848\uff0c\u539f\u7248\u5728\u8fd9\u91cc<\/a><\/p>\n\n

\u3010\u89e3\u51b3\u65b9\u6848\u3011
\n- 1.\u4ece\u7cfb\u7edf\u504f\u597d\u8bbe\u7f6e\u91cc\u8fb9\u6253\u5f00mysql.
\n- 2.\u70b9\u51fb\u201dInitialize Database\u201d
\n- 3.\u8bbe\u7f6e\u5bc6\u7801\uff0c\u9009\u62e9\u201dUse legacy password\u201d\uff0c->OK
\n- 4.\u91cd\u542fmysql,\u6253\u5f00navicate ,\u91cd\u65b0\u8fde\u63a5\u6570\u636e\u5e93\u3002<\/p>\n\n

\"image\"<\/p>\n\n

\"image\"<\/p> <\/div>\n \n <\/div>","orderid":"0","title":"Authentication plugin 'caching_sha2_password' cannot be loaded","smalltitle":"","mid":"0","fname":"Flume","special_id":"0","bak_id":"0","info":"0","hits":"789","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":"Authentication<\/A> plugin<\/A> '<\/A> caching_sha2_password'<\/A> cannot<\/A> 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":"1719085621","digg_num":"682","digg_time":"1718867084","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}