{"id":5639,"date":"2024-05-12T21:36:53","date_gmt":"2024-05-12T13:36:53","guid":{"rendered":"https:\/\/www.webteach.tw\/?p=5639"},"modified":"2024-05-12T21:36:55","modified_gmt":"2024-05-12T13:36:55","slug":"mysql-%e4%bd%bf%e7%94%a8%e8%80%85%e5%af%86%e7%a2%bc","status":"publish","type":"post","link":"https:\/\/www.webteach.tw\/?p=5639","title":{"rendered":"[ Linux ] \u8b8a\u66f4Mysql \u4f7f\u7528\u8005\u5bc6\u78bc"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u6700\u8fd1\u8001\u662f\u5fd8\u8a18 Mysql \u4f7f\u7528\u8005\u5bc6\u78bc\uff0c\u8a18\u4e0d\u4f4f\u53ea\u597d\u76f4\u63a5\u6539\u6389\uff0c\u771f\u662f\u6b72\u6708\u4e0d\u9952\u4eba\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\/\/\u7528root\u5e33\u865f\u767b\u5165 MYSQL<br>mysql -u root -p<br>\/\/\u986f\u793a\u6240\u6709\u8cc7\u6599\u5eab<br>show databases;<br>\/\/\u5207\u63db\u5230mysql \u8cc7\u6599\u5eab<br>use mysql;<br>\/\/\u986f\u793a\u6240\u6709\u8cc7\u6599\u8868<br>show tables;<br>\/\/\u986f\u793a\u6240\u6709\u4f7f\u7528\u8005<br>select User from user;<br>\/\/\u4fee\u6539\u4f7f\u7528\u8005\u5e33\u865f\u65b9\u6cd5<br>ALTER USER &#8216;jeff&#8217;@&#8217;localhost&#8217; IDENTIFIED WITH caching_sha2_password BY &#8216;12345&#8217;;<br>exit;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u8001\u662f\u5fd8\u8a18 Mysql \u4f7f\u7528\u8005\u5bc6\u78bc\uff0c\u8a18\u4e0d\u4f4f\u53ea\u597d\u76f4\u63a5\u6539\u6389\uff0c\u771f\u662f\u6b72\u6708\u4e0d\u9952\u4eba\u3002<\/p>\n","protected":false},"author":1,"featured_media":1867,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[1397,402,1395,441,1396,1398,1399],"class_list":["post-5639","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-change","tag-mysql","tag-mysql-","tag-password","tag-user","tag-1398","tag-1399","hvn-theme-has-thumbnail"],"_links":{"self":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/5639","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5639"}],"version-history":[{"count":1,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/5639\/revisions"}],"predecessor-version":[{"id":5640,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/5639\/revisions\/5640"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/media\/1867"}],"wp:attachment":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}