{"id":341,"date":"2019-03-20T15:08:51","date_gmt":"2019-03-20T07:08:51","guid":{"rendered":"http:\/\/www.inhhh.com\/blog\/?p=341"},"modified":"2019-03-20T15:08:51","modified_gmt":"2019-03-20T07:08:51","slug":"%e6%a0%91%e8%8e%93%e6%b4%bemysql%e6%97%a0%e9%9c%80%e5%af%86%e7%a0%81%e8%bf%9e%e6%8e%a5%e7%9a%84%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"http:\/\/www.inhhh.com\/blog\/?p=341","title":{"rendered":"\u6811\u8393\u6d3emysql\u65e0\u9700\u5bc6\u7801\u8fde\u63a5\u7684\u95ee\u9898"},"content":{"rendered":"\n<p>\u95ee\u9898\u63cf\u8ff0<br>\n\u6700\u8fd1\u9700\u8981\u5728\u6811\u8393\u6d3e3B+\u4e0a\u8fd0\u884c\u4e00\u4e2aJava\u7a0b\u5e8f\uff0c\u8fd9\u4e2ajava\u7a0b\u5e8f\u4f7f\u7528\u5230\u4e86mysql\u6570\u636e\u5e93\u3002\u5728\u8fd9\u4e2a\u8fc7\u7a0b\u4e2d\u9047\u5230\u4e86\u4e00\u4e2a\u95ee\u9898\uff1a<\/p>\n\n\n\n<p>\u5b89\u88c5mysql-server\u7684\u8fc7\u7a0b\u6ca1\u6709\u63d0\u793a\u8f93\u5165root\u7684password<br>\n\u5b89\u88c5\u6210\u529f\u540e\uff0c\u8f93\u5165\u6307\u4ee4mysql -uroot\uff0c\u63d0\u793aAccess denied for user \u2018root\u2019@\u2019localhost\u2019<br>\n\u8f93\u5165sudo mysql -uroot\u53ef\u4ee5\u76f4\u63a5\u8fde\u63a5\u6210\u529f<br>\n\u8f93\u5165sudo mysql -uroot -p\u540e\u56de\u8f66\u8f93\u5165\u4efb\u610fpassword\u4e5f\u53ef\u4ee5\u76f4\u63a5\u8fde\u63a5\u6210\u529f<br>\n\u8f93\u5165mysql -h 127.0.0.1 -P 3306 -uroot -p\u63d0\u793aAccess denied for user \u2018root\u2019@\u2019localhost\u2019<br>\n\u56e0\u6b64\uff0cjava\u7a0b\u5e8f\u901a\u8fc7jdbc\u6765\u8fde\u63a5\u6570\u636e\u5e93\u4e5f\u662f\u63d0\u793a\uff1aAccess denied for user \u2018root\u2019@\u2019localhost\u2019<\/p>\n\n\n\n<p>\u539f\u56e0<br>\n\u9700\u8981\u7ed9root\u8bbe\u7f6epassword<br>\n\u9700\u8981\u5c06\u7528\u6237\u8868\u4e2dplugin\u5b57\u6bb5\u7531auth_plugin\u8bbe\u7f6e\u6210mysql_native_password<br>\n\u53c2\u8003 https:\/\/blog.jasonmeridth.com\/posts\/unable-to-access-mysql-with-root-and-no-password-after-new-install-on-ubuntu\/<\/p>\n\n\n\n<p>\u89e3\u51b3\u6b65\u9aa4<br>\n\u7b2c\u4e00\u6b65\uff1a\u5b89\u88c5mysql<br>\nsudo apt-get update<\/p>\n\n\n\n<p>sudo apt-get install mysql-server<br>\n1<br>\n2<br>\n3<br>\n\u7b2c\u4e8c\u6b65\uff1a\u8bbe\u7f6eroot\u7684password\u548c\u4fee\u6539plugin\u5b57\u6bb5<br>\nsudo mysql -uroot <\/p>\n\n\n\n<h1 class=\"wp-block-heading\">\u8fde\u63a5mysql<\/h1>\n\n\n\n<p>1<br>\n2<br>\nUSE mysql;<\/p>\n\n\n\n<p>UPDATE user SET password=PASSWORD(&#8216;123456&#8242;) WHERE user=&#8217;root&#8217;;<\/p>\n\n\n\n<p>UPDATE user SET plugin=&#8217;mysql_native_password&#8217; WHERE user=&#8217;root&#8217;;<\/p>\n\n\n\n<p>FLUSH PRIVILEGES;<\/p>\n\n\n\n<p>exit;<br>\n1<br>\n2<br>\n3<br>\n4<br>\n5<br>\n6<br>\n7<br>\n8<br>\n9<br>\n\u7b2c\u4e09\u6b65\uff1a\u91cd\u542f\u670d\u52a1<br>\nsudo systemctl restart mysql<\/p>\n\n\n\n<p>sudo systemctl status mysql<br>\n1<br>\n2<br>\n3<br>\n\u9644\u52a0\uff1a\u5b8c\u5168\u5378\u8f7dmysql\uff08\u5982\u679c\u4ee5\u4e0a\u6267\u884c\u6210\u529f\u4e86\u53ef\u5ffd\u7565\u8fd9\u4e00\u6b65\uff09<br>\nsudo apt-ge autoremove &#8211;purge mysql-server<\/p>\n\n\n\n<p>sudo apt-get remove mysqyl-server<\/p>\n\n\n\n<p>sudo apt-get remove mysql-common #\u91cd\u8981<\/p>\n\n\n\n<p>sudo apt-get autoremove mysql-server<br> <br> \u6548\u679c<br> \u4e0d\u7ba1\u662f\u5426\u52a0sudo \u90fd\u5fc5\u987b\u4f7f\u7528\u6b63\u786e\u7684\u5bc6\u7801\u624d\u80fd\u8fde\u63a5\u6570\u636e\u5e93<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u8fdc\u7a0b\u8fde\u63a5\u7684\u95ee\u9898\uff1a\u5728\/etc\/mysql\/mariadb.conf.d\/50-server.conf\u4e2d\uff0c\u5c06bind-address=127.0.0.1\u6539\u6210bind-address=0.0.0.0\uff0c\u91cd\u542f\u7cfb\u7edf\u5373\u53ef\u3002<\/h2>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u95ee\u9898\u63cf\u8ff0 \u6700\u8fd1\u9700\u8981\u5728\u6811\u8393\u6d3e3B+\u4e0a\u8fd0\u884c\u4e00\u4e2aJava\u7a0b\u5e8f\uff0c\u8fd9\u4e2ajava\u7a0b\u5e8f\u4f7f\u7528\u5230\u4e86mysql\u6570\u636e\u5e93\u3002\u5728\u8fd9\u4e2a\u8fc7\u7a0b\u4e2d<\/p>\n<div class=\"more-link\">\n\t\t\t\t <a href=\"http:\/\/www.inhhh.com\/blog\/?p=341\" class=\"link-btn theme-btn\"><span>Read More <\/span> <i class=\"fa fa-caret-right\"><\/i><\/a>\n\t\t\t<\/div>\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-341","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/341","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=341"}],"version-history":[{"count":1,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/341\/revisions"}],"predecessor-version":[{"id":342,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/341\/revisions\/342"}],"wp:attachment":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=341"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=341"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}