{"id":277,"date":"2022-06-09T19:46:33","date_gmt":"2022-06-09T11:46:33","guid":{"rendered":"https:\/\/frogvps.com\/?p=277"},"modified":"2022-06-09T20:24:56","modified_gmt":"2022-06-09T12:24:56","slug":"mysql%e7%94%a8%e6%88%b7%e8%b4%a6%e5%8f%b7%e5%92%8c%e5%91%bd%e4%bb%a4","status":"publish","type":"post","link":"https:\/\/frogvps.com\/?p=277","title":{"rendered":"MYSQL\u7528\u6237\u8d26\u53f7\u548c\u547d\u4ee4"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">MYSQL\u7528\u6237\u8d26\u53f7<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">mysql\u7528\u6237\u8d26\u53f7\u7531\u4e24\u90e8\u5206\u7ec4\u6210\uff0c\u7528\u6237\u540d@\u4e3b\u673a\uff0c\u9650\u5236\u4e86\u8d26\u53f7\u6240\u5728\u7684\u4e3b\u673a\uff0c\u7531\u6b64\u5b9e\u73b0\u4e86\u5b89\u5168\u63a7\u5236\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>'USERNAME'@'HOST'<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e3b\u673a\u7684\u683c\u5f0f\u652f\u6301\u901a\u914d\u7b26<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>% \u5339\u914d\u4efb\u610f\u957f\u5ea6\u7684\u4efb\u610f\u5b57\u7b26(\u76f8\u5f53\u4e8eshell\u4e2d\u7684*) \u793a\u4f8b: 172.16.0.0\/255.255.0.0 \u6216 172.16.%.%\n_ \u5339\u914d\u4efb\u610f\u5355\u4e2a\u5b57\u7b26(\u76f8\u5f53\u4e8eshell\u4e2d\u7684?)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u67e5\u8be2\u6570\u636e\u5e93\u91cc\u7684\u7528\u6237\u8d26\u53f7<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT user,host FROM mysql.user;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">MYSQL\u547d\u4ee4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MYSQL\u8fd0\u884c\u547d\u4ee4<\/strong>(\u767b\u5f55\u6570\u636e\u5e93\u4ee5\u540e)\u5206\u4e3a\u5ba2\u6237\u7aef\u547d\u4ee4\u548c\u670d\u52a1\u7aef\u547d\u4ee4\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5ba2\u6237\u7aef\u547d\u4ee4\uff0c\u540e\u9762\u6ca1\u6709\u5206\u53f7\uff1b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>? (\\?)\nhelp (\\h) #\u67e5\u770b\u5e2e\u52a9\nquit (\\q)\nexit (\\q) #\u9000\u51faMYSQL\uff0c\u4e5f\u53ef\u4ee5\u6309CTRL+D\nstatus (\\s) #\u67e5\u770b\u670d\u52a1\u72b6\u6001\nsystem (\\!) #\u6267\u884cshell\u547d\u4ee4\uff0c\u4f8b\u5982\\! ls\nsource (\\.) #\u6267\u884cSQL\u811a\u672c\u6587\u4ef6\nuse (\\u) #\u5207\u6362\u6570\u636e\u5e93<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u670d\u52a1\u7aef\u547d\u4ee4\uff0c\u9ed8\u8ba4\u4ee5\u5206\u53f7\u7ed3\u5c3e\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT version();<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>mysql\u547d\u4ee4<\/strong>\u683c\u5f0f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql &#91;OPTIONS] &#91;database]<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u9009\u9879<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-A, --no-auto-rehash #\u7981\u6b62\u8865\u5168\n-u, --user= #\u7528\u6237\u540d,\u9ed8\u8ba4\u4e3aroot\n-h, --host= #\u670d\u52a1\u5668\u4e3b\u673a,\u9ed8\u8ba4\u4e3alocalhost\n-p, --passowrd= #\u7528\u6237\u5bc6\u7801,\u5efa\u8bae\u4f7f\u7528-p,\u9ed8\u8ba4\u4e3a\u7a7a\u5bc6\u7801\n-P, --port= #\u670d\u52a1\u5668\u7aef\u53e3\n-S, --socket= #\u6307\u5b9a\u8fde\u63a5socket\u6587\u4ef6\u8def\u5f84\n-D, --database= #\u6307\u5b9a\u9ed8\u8ba4\u6570\u636e\u5e93\n-C, --compress #\u542f\u7528\u538b\u7f29\n-e \"SQL\" #\u6267\u884cSQL\u547d\u4ee4\n-V, --version #\u663e\u793a\u7248\u672c\n-v --verbose #\u663e\u793a\u8be6\u7ec6\u4fe1\u606f\n--print-defaults #\u83b7\u53d6\u7a0b\u5e8f\u9ed8\u8ba4\u4f7f\u7528\u7684\u914d\u7f6e<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5root\u8eab\u4efd\u767b\u5f55\u6570\u636e\u5e93<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -uroot -p<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u767b\u5f55\u4ee5\u540e\u9ed8\u8ba4\u7684\u63d0\u793a\u7b26\u4e0d\u663e\u793a\u5728\u54ea\u4e2a\u6570\u636e\u5e93\u91cc<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u9700\u8981\u4fee\u6539\u63d0\u793a\u7b26\uff0c\u53ef\u4ee5\u5728\u914d\u7f6e\u6587\u4ef6\u91cc\u52a0\u4e0a\u4ee5\u4e0b\u4ee3\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;mysql]\nprompt=\"\\\\r:\\\\m:\\\\s(\\\\u@\\\\h) &#91;\\\\d]&gt;\\\\_\"<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">mysqladmin\u547d\u4ee4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">mysqladmin\u5e38\u7528\u547d\u4ee4<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#\u67e5\u770bmysql\u670d\u52a1\u662f\u5426\u6b63\u5e38\uff0c\u5982\u679c\u6b63\u5e38\u63d0\u793amysqld is alive\nmysqladmin -uroot -p\u4f60\u7684\u5bc6\u7801 ping\n#\u5173\u95edmysql\u670d\u52a1\uff0c\u4f46mysqladmin\u547d\u4ee4\u65e0\u6cd5\u5f00\u542f\nmysqladmin -uroot -p\u4f60\u7684\u5bc6\u7801 shutdown\n#\u521b\u5efa\u6570\u636e\u5e93testdb\nmysqladmin -uroot -p\u4f60\u7684\u5bc6\u7801 create testdb\n#\u5220\u9664\u6570\u636e\u5e93testdb\nmysqladmin -uroot -p\u4f60\u7684\u5bc6\u7801 drop testdb\n#\u4fee\u6539root\u5bc6\u7801\nmysqladmin -uroot -p\u4f60\u7684\u5bc6\u7801 password '\u65b0\u5bc6\u7801'\n#\u65e5\u5fd7\u6eda\u52a8,\u751f\u6210\u65b0\u6587\u4ef6\uff0c\u4f8b\u5982\/var\/lib\/mysql\/mariadb-bin.00000N\nmysqladmin -uroot -p\u4f60\u7684\u5bc6\u7801 flush-logs<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MYSQL\u7528\u6237\u8d26\u53f7 mysql\u7528\u6237\u8d26\u53f7\u7531\u4e24\u90e8\u5206\u7ec4\u6210\uff0c\u7528\u6237\u540d@\u4e3b\u673a\uff0c\u9650\u5236\u4e86\u8d26\u53f7\u6240\u5728\u7684\u4e3b\u673a\uff0c\u7531\u6b64\u5b9e\u73b0\u4e86\u5b89\u5168\u63a7\u5236\u3002 \u4e3b\u673a\u7684\u683c\u5f0f\u652f\u6301\u901a\u914d\u7b26 \u67e5\u8be2\u6570\u636e\u5e93\u91cc\u7684\u7528\u6237\u8d26\u53f7 MYSQL\u547d\u4ee4 MYSQL\u8fd0\u884c\u547d\u4ee4(\u767b\u5f55\u6570\u636e\u5e93\u4ee5\u540e)\u5206\u4e3a\u5ba2\u6237\u7aef\u547d\u4ee4\u548c\u670d\u52a1\u7aef\u547d\u4ee4\u3002 \u5ba2&#8230;<\/p>\n","protected":false},"author":1,"featured_media":283,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[36],"topic":[],"class_list":["post-277","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-35","tag-mysql"],"_links":{"self":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts\/277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=277"}],"version-history":[{"count":1,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts\/277\/revisions"}],"predecessor-version":[{"id":279,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/posts\/277\/revisions\/279"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=\/wp\/v2\/media\/283"}],"wp:attachment":[{"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=277"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/frogvps.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftopic&post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}