{"id":386,"date":"2021-05-05T11:29:01","date_gmt":"2021-05-05T03:29:01","guid":{"rendered":"https:\/\/22pig.com\/?p=386"},"modified":"2021-05-05T11:29:01","modified_gmt":"2021-05-05T03:29:01","slug":"%e7%be%a4%e6%99%96mariadb%e6%b7%bb%e5%8a%a0%e8%bf%9c%e7%a8%8b%e8%ae%bf%e9%97%ae%e5%8a%9f%e8%83%bd","status":"publish","type":"post","link":"http:\/\/22pig.com\/?p=386","title":{"rendered":"\u7fa4\u6656MariaDB\u6dfb\u52a0\u8fdc\u7a0b\u8bbf\u95ee\u529f\u80fd"},"content":{"rendered":"<p>\u7fa4\u6656\u7684\u5957\u4ef6\u4e2d\u5fc3\u5b89\u88c5MariaDB\uff0c\u4f46\u662f\u8fdc\u7a0b\u8bbf\u95ee\u529f\u80fd\u662f\u9ed8\u8ba4\u5173\u95ed\u7684\uff0c\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u547d\u4ee4\u5f00\u542f\u3002<\/p>\n<pre class=\"line-numbers language-bash\"><code class=\" language-bash\"># ssh\u5230Synology\nsudo -i  # \u63d0\u6743\ncd \/volume1\/@appstore\/MariaDB10\/usr\/local\/mariadb10\/bin  #\u8bbf\u95ee\u76ee\u5f55\n.\/mysql -u root -p  #  \u8fd9\u91cc\u6709\u4e2a\u5751\uff0croot\u5bc6\u7801\u548cMariaDB\u5bc6\u7801\u662f\u4e0d\u540c\u7684\uff0c\u9700\u8981\u5728\u5957\u4ef6\u4e2d\u5fc3\u5404\u81ea\u8bbe\u7f6e\nuse mysql  #  \u9009\u62e9\u6570\u636e\u5e93\nupdate user set host = '192.168.1.%' where user = 'root';  #\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528%\uff0c\u4e5f\u53ef\u4ee5\u7528192.168.1.%\u6765\u7f29\u5c0f\u8303\u56f4\nselect host, user from user;  #  \u786e\u8ba4\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528select User,host from mysql.user;\nFLUSH PRIVILEGES;  #  \u5237\u65b0\u6743\u9650<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u7fa4\u6656\u7684\u5957\u4ef6\u4e2d\u5fc3\u5b89\u88c5MariaDB\uff0c\u4f46\u662f\u8fdc\u7a0b\u8bbf\u95ee\u529f\u80fd\u662f\u9ed8\u8ba4\u5173\u95ed\u7684\uff0c\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u547d\u4ee4\u5f00\u542f\u3002 # ssh\u5230Synology sudo -i # \u63d0\u6743 cd \/volume1\/@appstore\/MariaDB10\/usr\/local\/mariadb10\/bin #\u8bbf\u95ee\u76ee\u5f55 .\/mysql -u root -p # \u8fd9\u91cc\u6709\u4e2a\u5751\uff0croot\u5bc6\u7801\u548cMariaDB\u5bc6\u7801\u662f\u4e0d\u540c\u7684\uff0c\u9700\u8981\u5728\u5957\u4ef6\u4e2d\u5fc3\u5404\u81ea\u8bbe\u7f6e use mysql # \u9009\u62e9\u6570\u636e\u5e93 update user set host = &#8216;192.168.1.%&#8217; where user = &#8216;root&#8217;; #\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528%\uff0c\u4e5f\u53ef\u4ee5\u7528192.168.1.%\u6765\u7f29\u5c0f\u8303\u56f4 select host, user from user; # \u786e\u8ba4\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528select User,host from mysql.user; FLUSH PRIVILEGES; # \u5237\u65b0\u6743\u9650<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-386","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=386"}],"version-history":[{"count":0,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/386\/revisions"}],"wp:attachment":[{"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=386"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}