{"id":31,"date":"2024-03-29T13:45:06","date_gmt":"2024-03-29T05:45:06","guid":{"rendered":"http:\/\/www.shifengzhi.asia\/?p=31"},"modified":"2024-03-29T13:45:25","modified_gmt":"2024-03-29T05:45:25","slug":"all%e6%8a%a5%e9%94%99%e8%a7%a3%e5%86%b3%e6%b1%87%e6%80%bb","status":"publish","type":"post","link":"https:\/\/boki.shifengzhi.top\/?p=31","title":{"rendered":"ALL\u62a5\u9519\u89e3\u51b3\u6c47\u603b"},"content":{"rendered":"<h3>\u8fdc\u7a0b\u8fde\u63a5MySQL\u62a5\u9519<\/h3>\n<p>\u62a5\u9519\u5185\u5bb9\uff1a<code>Client does not support authentication protocol requested by server; consider upgrading MySQL client<\/code><\/p>\n<p>\u62a5\u9519\u539f\u56e0\uff1aMySQL8.0\u4ee5\u540e\u7684\u7248\u672c\u52a0\u5bc6\u65b9\u5f0f\u4e0e\u4e4b\u524d\u4e0d\u540c\uff0c8.0.11\u6362\u4e86\u65b0\u7684\u8eab\u4efd\u9a8c\u8bc1\u63d2\u4ef6\uff1a<code>caching_sha2_password<\/code>\uff0c\u4ee5\u524d\u7684\u4e3a<code>mysql_native_password<\/code><\/p>\n<p>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/p>\n<pre><code>            1. \u767b\u5f55\u6570\u636e\u5e93\u540e\uff0c\u67e5\u770b'root'\u7528\u6237\u8eab\u4efd\u9a8c\u8bc1\u63d2\u4ef6\uff1a\n   * <code>use mysql;<\/code>\n   * <code>select user,plugin,host from user where user=&#039;root&#039;;<\/code>\n            2. \u6539\u53d8\u8eab\u4efd\u9a8c\u8bc1\u63d2\u4ef6(\u52a0\u5bc6\u65b9\u5f0f)\n   - <code>alter user &#039;root&#039;@&#039;localhost&#039; identified with mysql_native_password by &#039;277882&#039;;<\/code>\n            3. \u6700\u540e\u91cd\u65b0\u67e5\u770b\u52a0\u5bc6\u65b9\u5f0f(\u8eab\u4efd\u9a8c\u8bc1\u63d2\u4ef6)\n   - <code>select user,plugin from user where user=&#039;root&#039;;<\/code><\/code><\/pre>\n<hr \/>\n<h2>node-express\u62a5\u9519<\/h2>\n<p>\u62a5\u9519\u5185\u5bb9\uff1a<code>expressJWT is not a function<\/code><\/p>\n<p>\u62a5\u9519\u539f\u56e0\uff1aexpress\u9ad8\u7248\u672c\u4ee3\u7801\u4e66\u5199\u4e0e\u8fc7\u53bb\u4f4e\u7248\u672c\u4e0d\u540c\uff0c\u65b0\u7248\u9700\u8981\u914d\u7f6ealgorithms\u7b97\u6cd5\uff0c\u4e00\u822c\u9ed8\u8ba4\u503c\u4e3aHS256<\/p>\n<p>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/p>\n<ul>\n<li>\u4ee3\u7801\u6539\u6210\uff1a<\/li>\n<\/ul>\n<pre><code class=\"language-javascript\">app.use(expressJWT.expressjwt({ secret: secretKey, algorithms: [&quot;HS256&quot;] }).unless({ path: [\/^\\\/api\\\/\/] }))<\/code><\/pre>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>\u8fdc\u7a0b\u8fde\u63a5MySQL\u62a5\u9519 \u62a5\u9519\u5185\u5bb9\uff1aClient does not support authentication [&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-31","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=\/wp\/v2\/posts\/31","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=31"}],"version-history":[{"count":2,"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":33,"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=\/wp\/v2\/posts\/31\/revisions\/33"}],"wp:attachment":[{"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/boki.shifengzhi.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}