{"id":351,"date":"2022-03-10T18:00:25","date_gmt":"2022-03-10T10:00:25","guid":{"rendered":"https:\/\/www.stusc.com\/?p=351"},"modified":"2022-03-10T18:00:25","modified_gmt":"2022-03-10T10:00:25","slug":"mysql8%e6%97%a0%e6%b3%95%e6%9b%b4%e6%96%b0%e7%9a%84%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/www.stusc.com\/?p=351","title":{"rendered":"MySQL8\u65e0\u6cd5\u66f4\u65b0\u7684\u95ee\u9898"},"content":{"rendered":"\n<p>\u4eca\u5929SSH\u8fde\u5230\u670d\u52a1\u5668\uff0cyum update\u65f6\u62a5\u9519\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-white-color has-black-background-color has-text-color has-background\">warning: \/var\/cache\/yum\/x86_64\/7\/mysql80-community\/packages\/mysql-community-client-8.0.28-1.el7.x86_64.rpm: Header V4 RSA\/SHA256 Signature, key ID 3a79bd29: NOKEY\nRetrieving key from file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\n\nThe GPG keys listed for the \"MySQL 8.0 Community Server\" repository are already installed but they are not correct for this package.\nCheck that the correct key URLs are configured for this repository.\n\nFailing package is: mysql-community-client-8.0.28-1.el7.x86_64\nGPG Keys are configured as: file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql<\/pre>\n\n\n\n<p>\u67e5\u4e86\u4e0b\/etc\/pki\/rpm-gpg\/\u76ee\u5f55\u4e0b\u4e5f\u6709 RPM-GPG-KEY-mysql\u6587\u4ef6 \uff0c\u4fee\u6539\u65e5\u671f\u4e3a2019-4-25<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"679\" height=\"198\" src=\"https:\/\/www.stusc.com\/wp-content\/uploads\/2022\/03\/image-1.png\" alt=\"\" class=\"wp-image-352\" srcset=\"https:\/\/www.stusc.com\/wp-content\/uploads\/2022\/03\/image-1.png 679w, https:\/\/www.stusc.com\/wp-content\/uploads\/2022\/03\/image-1-300x87.png 300w\" sizes=\"auto, (max-width: 679px) 100vw, 679px\" \/><\/figure>\n\n\n\n<p>\u767e\u5ea6\u65f6\u6709\u4eba\u5efa\u8bae\u4fee\u6539\/etc\/yum\/repos.d\/mysql-community.repo\u914d\u7f6e\uff0c\u5c06gpgcheck\u503c\u6539\u4e3a0\uff0c\u8df3\u8fc7\u9a8c\u8bc1\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;mysql80-community]\r\nname=MySQL 8.0 Community Server\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-8.0-community\/el\/7\/$basearch\/\r\nenabled=1\r\ngpgcheck=0\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql<\/code><\/pre>\n\n\n\n<p>\u4ed4\u7ec6\u60f3\u60f3\u8fd9\u4e5f\u4e0d\u662f\u957f\u8fdc\u4e4b\u8ba1\uff0c\u4e8e\u662f\u8dd1\u5230mysql\u5b98\u7f51\u4e0a\u770b\u4e86\u4e00\u4e0b\u3002\u539f\u6765\u662f\u5bc6\u94a5\u8fc7\u671f\u4e86\uff08\u539f\u6587\u89c1https:\/\/bugs.mysql.com\/bug.php?id=106188\uff09\uff0c\u73b0\u5728\u5b98\u65b9\u63a8\u51fa\u4e86\u65b0\u5bc6\u94a5\uff0c\u66f4\u65b0\u4e00\u4e0b\u4fbf\u53ef\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># rpm --import https:\/\/repo.mysql.com\/RPM-GPG-KEY-mysql-2022\n# yum update -y<\/code><\/pre>\n\n\n\n<p>\u4e00\u5207\u6062\u590d\u6b63\u5e38~<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL8\u65e0\u6cd5\u66f4\u65b0\u7684\u89e3\u51b3\u65b9\u6cd5<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[101],"class_list":{"0":"post-351","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-tech","7":"tag-mysql8","8":"h-entry","10":"h-as-article"},"_links":{"self":[{"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/posts\/351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stusc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=351"}],"version-history":[{"count":1,"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/posts\/351\/revisions"}],"predecessor-version":[{"id":353,"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/posts\/351\/revisions\/353"}],"wp:attachment":[{"href":"https:\/\/www.stusc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stusc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stusc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}