{"id":682,"date":"2023-09-07T20:13:55","date_gmt":"2023-09-07T12:13:55","guid":{"rendered":"http:\/\/www.huerpu.cc:7000\/?p=682"},"modified":"2023-09-07T20:13:55","modified_gmt":"2023-09-07T12:13:55","slug":"ubuntu22-04%e5%9c%a8%e7%ba%bf%e5%ae%89%e8%a3%85mysql8","status":"publish","type":"post","link":"http:\/\/www.huerpu.cc:7000\/?p=682","title":{"rendered":"ubuntu22.04\u5728\u7ebf\u5b89\u88c5MySQL8"},"content":{"rendered":"<h3>ubuntu22.04\u5728\u7ebf\u5b89\u88c5MySQL8<\/h3>\n<pre><code class=\"language-shell\">wget https:\/\/repo.mysql.com\/\/mysql-apt-config_0.8.25-1_all.deb\n\n#\u8f93\u5165\u8fd9\u6761\u547d\u4ee4\uff0c\u7136\u540e\u9009\u62e9OK\nsudo dpkg -i mysql-apt-config_0.8.25-1_all.deb\n\napt update \n\n#\u5b89\u88c5\napt-get -y install mysql-server\n\n#\u8f93\u5165\u5bc6\u7801\uff0c\u4e24\u6b21\n#\u7136\u540e\u9009\u62e9\u7b2c\u4e8c\u4e2a\uff0cUse Legacy Authentication Method \n\n#\u67e5\u770b\u72b6\u6001\nsystemctl status mysql\n\n#\u767b\u5f55MySQL\nmysql -uroot -p\n\n#\u4fee\u6539\u5bc6\u7801\u5e76\u8bbe\u7f6e\u8bbf\u95ee\u4e3b\u673a\nselect host , user , plugin ,authentication_string from mysql.user;\n\nALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;admin123&#039;;\nflush privileges;\n\nALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED WITH mysql_native_password BY &#039;admin123&#039;;\nflush privileges;\n\nupdate mysql.user set host = &#039;%&#039;,plugin=&#039;mysql_native_password&#039; where user=&#039;root&#039;;\nflush privileges;\n\nquit;\n\n#\u91cd\u542fmysql\nsystemctl restart mysql\n\n#\u5f00\u653e3306\u7aef\u53e3\nufw allow 3306<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>ubuntu22.04\u5728\u7ebf\u5b89\u88c5MySQL8 wget https:\/\/repo.mysql.com\/\/mysq [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-682","post","type-post","status-publish","format-standard","hentry","category-20"],"_links":{"self":[{"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/posts\/682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=682"}],"version-history":[{"count":1,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/posts\/682\/revisions"}],"predecessor-version":[{"id":683,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=\/wp\/v2\/posts\/682\/revisions\/683"}],"wp:attachment":[{"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=682"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.huerpu.cc:7000\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}