{"id":366,"date":"2022-10-06T12:15:10","date_gmt":"2022-10-06T04:15:10","guid":{"rendered":"https:\/\/www.stusc.com\/?p=366"},"modified":"2022-10-06T12:15:10","modified_gmt":"2022-10-06T04:15:10","slug":"mysql%e9%80%9f%e8%ae%b001","status":"publish","type":"post","link":"https:\/\/www.stusc.com\/?p=366","title":{"rendered":"MySQL\u901f\u8bb0(01)"},"content":{"rendered":"\n

1\u3001\u767b\u5f55MySQL<\/p>\n\n\n\n

$mysql -p -u [\u7528\u6237\u540d]<\/p>\n\n\n\n

\u8bf4\u660e\uff1a\u5b89\u88c5\u540e\u9996\u6b21\u53ea\u80fd\u7528root\u7528\u6237\u767b\u5f55<\/p>\n\n\n\n

2\u3001\u521b\u5efa\u7528\u6237\u5e76\u5206\u914d\u6743\u9650<\/p>\n\n\n\n

2.1\u3001\u7ba1\u7406\u5458\u767b\u5f55\u540e\u64cd\u4f5c<\/p>\n\n\n\n

mysql>CREATE USER ‘[\u7528\u6237\u540d]’@'[\u4f4d\u7f6e]’ IDENTIFIEN BY ‘[\u5bc6\u7801]’;<\/p>\n\n\n\n

mysql>GRANT ALL ON [\u6570\u636e\u5e93\u540d].* TO \u2018[\u7528\u6237\u540d]\u2019@\u2018[\u4f4d\u7f6e]\u2019;<\/p>\n\n\n\n

2.2\u3001\u547d\u4ee4\u884c\u64cd\u4f5c<\/p>\n\n\n\n

$mysql -h [\u4e3b\u673a] -p -u root CREATE USER ‘[\u7528\u6237\u540d]’@'[\u4f4d\u7f6e]’ IDENTIFIEN BY ‘[\u5bc6\u7801]’<\/p>\n\n\n\n

$mysql -h [\u4e3b\u673a] -p -u root GRANT ALL ON [\u6570\u636e\u5e93\u540d].* TO \u2018[\u7528\u6237\u540d]\u2019@\u2018[\u4f4d\u7f6e]\u2019<\/p>\n\n\n\n

\u8bf4\u660e\uff1a\u4ec5root\u53ef\u6267\u884c\u6b64\u64cd\u4f5c\u3002<\/p>\n\n\n\n

3\u3001\u521b\u5efa\u6570\u636e\u5e93<\/p>\n\n\n\n

3.1\u3001\u7ba1\u7406\u5458\u767b\u5f55\u540e\u521b\u5efa<\/p>\n\n\n\n

mysql>CREATE DATABASE [\u6570\u636e\u5e93\u540d]\uff1b<\/p>\n\n\n\n

3.2\u3001\u547d\u4ee4\u884c\u521b\u5efa<\/p>\n\n\n\n

$mysql -h [\u4e3b\u673a] -p -u root CREATE DATABASE [\u6570\u636e\u5e93\u540d]<\/p>\n\n\n\n

\u8bf4\u660e\uff1a\u4ec5root\u53ef\u521b\u5efa\u6570\u636e\u5e93\u3002<\/p>\n\n\n\n

4\u3001\u67e5\u8be2\u670d\u52a1<\/p>\n\n\n\n

4.1\u3001\u67e5\u8be2\u5f53\u524d\u65f6\u95f4<\/p>\n\n\n\n

mysql>SELECT NOW();<\/p>\n\n\n\n

4.2\u3001\u67e5\u8be2\u5f53\u524d\u7528\u6237<\/p>\n\n\n\n

mysql>SELECT USER();<\/p>\n\n\n\n

4.3\u3001\u67e5\u8be2\u7cfb\u7edf\u7248\u672c<\/p>\n\n\n\n

mysql>SELECT VERSION();<\/p>\n\n\n\n

4.4\u3001\u6a2a\u884c\u663e\u793a\u67e5\u8be2\u7ed3\u679c<\/p>\n\n\n\n

mysql>SELECT [\u64cd\u4f5c] \\G<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL\u8981\u70b9\u7b80\u8ff0<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[7],"tags":[110,111],"class_list":{"0":"post-366","1":"post","2":"type-post","3":"status-publish","4":"format-aside","5":"hentry","6":"category-tech","7":"tag-my-sql","8":"tag-sql","9":"post_format-post-format-aside","10":"h-entry","12":"h-as-note"},"_links":{"self":[{"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/posts\/366","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stusc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=366"}],"version-history":[{"count":1,"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/posts\/366\/revisions"}],"predecessor-version":[{"id":367,"href":"https:\/\/www.stusc.com\/index.php?rest_route=\/wp\/v2\/posts\/366\/revisions\/367"}],"wp:attachment":[{"href":"https:\/\/www.stusc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stusc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stusc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}