{"id":191942,"date":"2020-10-30T03:07:35","date_gmt":"2020-10-29T19:07:35","guid":{"rendered":"http:\/\/4563.org\/?p=191942"},"modified":"2020-10-30T03:07:35","modified_gmt":"2020-10-29T19:07:35","slug":"mysql8-0-%e9%bb%98%e8%ae%a4-plugin-%e4%b8%ba-caching_sha2_password%ef%bc%8c%e6%9c%89%e5%ae%a2%e6%88%b7%e7%ab%af%e6%94%af%e6%8c%81%e5%90%97%ef%bc%9f-navicat%ef%bc%8c-php-php7-4-%e5%be%85%e7%a1%ae","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=191942","title":{"rendered":"mysql8.0 \u9ed8\u8ba4 plugin \u4e3a caching_sha2_password\uff0c\u6709\u5ba2\u6237\u7aef\u652f\u6301\u5417\uff1f navicat\uff0c PHP (php7.4 \u5f85\u786e\u8ba4\uff09, MySQL Workbench \u90fd\u4e0d\u652f\u6301\u554a"},"content":{"rendered":"
\n
\n
\n

mysql8.0 \u9ed8\u8ba4 plugin \u4e3a caching_sha2_password\uff0c\u6709\u5ba2\u6237\u7aef\u652f\u6301\u5417\uff1f navicat\uff0c PHP (php7.4 \u5f85\u786e\u8ba4\uff09, MySQL Workbench \u90fd\u4e0d\u652f\u6301\u554a <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : pinews <\/span> <\/i> 5<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\u81ea\u5bb6\u7684\u5ba2\u6237\u7aef\u90fd\u4e0d\u652f\u6301\uff0c\u8fd9\u4e2a\u9ed8\u8ba4\u7684\u610f\u4e49\u4f55\u5728\uff1f <\/div>\n
\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (13<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : a719114136 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4f60 Workbench \u4e0d\u662f\u6700\u65b0\u7248\u5427\uff0c\u6700\u65b0\u7248\u662f\u652f\u6301\u7684\u3002<\/p>\n

    \u5176\u4ed6\u5ba2\u6237\u7aef\u5e94\u8be5\u90fd\u652f\u6301\u4e86\uff0c\u6bd5\u7adf\u5df2\u7ecf\u51fa\u4e86\u597d\u51e0\u5e74\u4e86\uff0c\u4e0d\u652f\u6301\u5e94\u8be5\u662f\u7248\u672c\u95ee\u9898\u3002\u6211\u7528 datagrip \u662f ok \u7684 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : orchid9210 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u540c\u4e0a\uff0cdatagrip \u5b8c\u4e8b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : zoharSoul <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    jdbc \u652f\u6301\u7684 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : letitbesqzr <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    navicat \u8001\u65e9\u5c31\u652f\u6301\u4e86… <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Love4Taylor <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    navicat \u6ca1\u95ee\u9898\uff0cphp \u4e5f\u6ca1\u95ee\u9898<\/p>\n

    [email protected]:~$ sudo docker exec -it php php -v
    PHP 7.4.12 (cli) (built: Nov 5 2020 20:24:10) ( NTS )
    Copyright (c) The PHP Group
    Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.12, Copyright (c), by Zend Technologies <\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : studentht <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    MySQL Workbench 8 \u6ca1\u95ee\u9898 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : warcraft1236 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u8fd9\u662f\u4e2a\u5565\uff0c\u6709\u6ca1\u6709\u5927\u4f6c\u4ecb\u7ecd\u4e00\u4e0b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : lepig <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u597d\u50cf php7.3.9 \u4ee5\u540e\u90fd\u652f\u6301\u4e86\u5427 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : julyclyde <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u9047\u5230\u81ea\u5bb6\u5ba2\u6237\u7aef\u90fd\u4e0d\u652f\u6301\uff0c\u4f60\u5f97\u5148\u8003\u8651\u4e00\u4e0b\u4f60\u81ea\u5df1\u7684\u95ee\u9898 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : pinews <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @a719114136
    @orchid9210
    @zoharSoul
    @letitbesqzr
    @Love4Taylor
    @studentht
    @warcraft1236
    @lepig
    @julyclyde <\/p>\n

    \u56de\u590d\u4e0a 9 \u4f4d\uff0c\u6211\u9519\u4e86\uff0c\u201cmysql8.0 \u9ed8\u8ba4 plugin \u4e3a caching_sha2_password\u201d\u662f\u6211\u542c\u4fe1\u4e86\u7f51\u4e0a\u7684\u4f20\u8a00\uff0c\u7ecf\u6211\u518d\u4e09\u6d4b\u8bd5\u3002
    centos \u9ed8\u8ba4\u5b89\u88c5 msyql ,plugin \u4e3a mysql_native_password
    \u9ed8\u8ba4\u5b89\u88c5 mariadb\uff0cplugin \u4e3a\u7a7a\uff0c\u7ed3\u679c\u7b49\u540c mysql_native_password
    debian\uff0c\u4e0d\u80fd\u5b89\u88c5 mysql\uff0c\u5b89\u88c5 mariadb\uff0cplugin \u4e3a caching_sha2_password\uff0c\u7ed3\u679c\u7684\u786e\u662f\u62d2\u7edd\u8bbf\u95ee\u3002
    MySQL Workbench\uff0cnavicatl \u4e3a\u6700\u65b0\u7248\uff0cphp7.3 \u90fd\u4e0d\u652f\u6301\uff0c\u7ecf\u8fc7\u641c\u7d22 php7.4 \u597d\u50cf\u652f\u6301\uff0c\u4f46\u53c8\u6709\u95ee\u9898\u7684\u6837\u5b50\uff0c<\/p>\n

    \u90a3\u4e48\uff1f\uff1f\uff1f <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Foxkeh <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    MySQL8.0 \u521d\u4e0a\u7684\u65f6\u5019\u4e5f\u9047\u5230\u4e86\u5bc6\u7801\u5b58\u50a8\u7b56\u7565\u53d8\u6210 caching_sha2_password \u7684\u95ee\u9898\uff0cJDBC \u90fd\u8981\u81f3\u5c11\u66f4\u65b0\u5230 5.1.46 \uff0c \u4f46\u5b98\u65b9 MySQL Workbench \u7684\u786e\u662f\u652f\u6301\u7684\uff0cNavicat \u4e5f\u662f\u6bd4\u8f83\u5feb\u63d0\u4f9b\u4e86\u652f\u6301\uff0cDbeaver \u4e5f\u80fd\u641e\u4f46\u4e0d\u597d\u7528\uff0c\u5f88\u4e45\u4ee5\u540e HeidiSQL \u4e5f\u5f00\u59cb\u652f\u6301\uff0c \u50cf\u5176\u4ed6\u7684 Sqlyog, MysqlFront\uff0c \u4ee5\u53ca MySQLCompare \u8fd9\u7c7b\u8f6f\u4ef6\u90fd\u6ca1\u8ddf\u4e0a\u6211\u4e5f\u5c31\u6ca1\u518d\u7528\u4e86\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : julyclyde <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    php \u4f60\u94fe\u63a5\u5230\u65b0\u7248 libmysqlclient \u8bd5\u8bd5\u5462\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : cco <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e3b\u6d41\u7684\u90fd\u652f\u6301\u4e86\u554a- -\u3002\u5347\u7ea7\u4e0b\u5427\u5144\u5f1f\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n","protected":false},"excerpt":{"rendered":"

    mysql8.0 \u9ed8\u8ba4 plugi…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/191942"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=191942"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/191942\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=191942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=191942"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=191942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}