{"id":910,"date":"2019-07-28T15:59:00","date_gmt":"2019-07-28T07:59:00","guid":{"rendered":"http:\/\/www.langmanezhuang.com\/index.php\/2019\/07\/28\/nacicat%e8%bf%9e%e6%8e%a5mysql8%e5%8f%8ajdbc%e8%bf%9e%e6%8e%a5mysql8%e6%8a%a5%e9%94%99%e8%a7%a3%e5%86%b3\/"},"modified":"2019-07-28T15:59:00","modified_gmt":"2019-07-28T07:59:00","slug":"nacicat%e8%bf%9e%e6%8e%a5mysql8%e5%8f%8ajdbc%e8%bf%9e%e6%8e%a5mysql8%e6%8a%a5%e9%94%99%e8%a7%a3%e5%86%b3","status":"publish","type":"post","link":"http:\/\/blog.langmanezhuang.com\/index.php\/2019\/07\/28\/nacicat%e8%bf%9e%e6%8e%a5mysql8%e5%8f%8ajdbc%e8%bf%9e%e6%8e%a5mysql8%e6%8a%a5%e9%94%99%e8%a7%a3%e5%86%b3\/","title":{"rendered":"nacicat\u8fde\u63a5mysql8\u53caJDBC\u8fde\u63a5mysql8\u62a5\u9519\u89e3\u51b3"},"content":{"rendered":"

\u6700\u8fd1\u6362\u7535\u8111\u5b89\u88c5\u4e86mysql8\uff0c\u4f7f\u7528 nacicat\u8fde\u63a5\u53d1\u73b0\u62a5\u95191251- Client does not support authentication protocol \u9519\u8bef<\/p>\n

\u4ece\u7f51\u4e0a\u767e\u5ea6\u5230\u539f\u6765mysql8 \u4e4b\u524d\u7684\u7248\u672c\u4e2d\u52a0\u5bc6\u89c4\u5219\u662fmysql_native_password,\u800c\u5728mysql8\u4e4b\u540e,\u52a0\u5bc6\u89c4\u5219\u662fcaching_sha2_password, <\/p>\n

\u89e3\u51b3\u95ee\u9898\u65b9\u6cd5\u6709\u4e24\u79cd\uff1a<\/p>\n

\u65b9\u6cd51.\u5347\u7ea7navicat\u9a71\u52a8\uff1b<\/p>\n

\u65b9\u6cd52.\u628amysql\u7528\u6237\u767b\u5f55\u5bc6\u7801\u52a0\u5bc6\u89c4\u5219\u8fd8\u539f\u6210mysql_native_password. <\/p>\n

\u8fd9\u91cc\u91c7\u7528\u65b9\u6cd52\u89e3\u51b3\uff0c\u5177\u4f53\u64cd\u4f5c\u6b65\u9aa4\u5982\u4e0b\uff1a<\/p>\n

1.\u6253\u5f00\u547d\u4ee4\u884c\u5c0f\u9ed1\u5c4f\uff0c\u8fdb\u5165MySQL\u7684bin\u76ee\u5f55\uff0c\u7136\u540e\u8f93\u5165mysql -u root -p\uff0c\u8f93\u5165\u5bc6\u7801<\/p>\n

2.\u7136\u540e\u8f93\u5165<\/p>\n

ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; #\u4fee\u6539\u52a0\u5bc6\u89c4\u5219<\/p>\n

ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; #\u66f4\u65b0\u4e00\u4e0b\u7528\u6237\u7684\u5bc6\u7801 <\/p>\n

FLUSH PRIVILEGES; #\u5237\u65b0\u6743\u9650<\/p>\n

3.\u8f93\u5165\u4fee\u6539\u7684\u5bc6\u7801\uff0c\u518d\u6b21\u6d4b\u8bd5\u8fde\u63a5\uff0c\u53d1\u73b0\u8fde\u63a5\u6210\u529f
\"\"<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u6700\u8fd1\u6362\u7535\u8111\u5b89\u88c5\u4e86mysql8\uff0c\u4f7f\u7528 nacicat\u8fde\u63a5\u53d1\u73b0\u62a5\u95191251- Client does n … \u7ee7\u7eed\u9605\u8bfb nacicat\u8fde\u63a5mysql8\u53caJDBC\u8fde\u63a5mysql8\u62a5\u9519\u89e3\u51b3<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/910"}],"collection":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/comments?post=910"}],"version-history":[{"count":0,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/910\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/media?parent=910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/categories?post=910"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/tags?post=910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}