{"id":935,"date":"2022-11-28T00:50:06","date_gmt":"2022-11-27T15:50:06","guid":{"rendered":"https:\/\/eng.miteel.net\/?page_id=935"},"modified":"2026-05-20T06:57:13","modified_gmt":"2026-05-19T21:57:13","slug":"mysql-%e3%83%a6%e3%83%bc%e3%82%b6%e3%83%bc%e8%bf%bd%e5%8a%a0","status":"publish","type":"page","link":"https:\/\/eng.miteel.net\/?page_id=935","title":{"rendered":"MYSQL \u30e6\u30fc\u30b6\u30fc\u8ffd\u52a0"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5168\u30db\u30b9\u30c8\u304b\u3089\u63a5\u7d9a\u53ef\u80fd\u306a\u7ba1\u7406\u8005\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u4f5c\u6210<\/p>\n\n\n\n<pre class=\"wp-block-verse\"><code>CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';<br>GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%' WITH GRANT OPTION;<br>GRANT CREATE USER ON *.* TO 'newuser'@'%';<br>FLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3000\u3000\u6d88\u53bb\u306f\u4ee5\u4e0b<\/p>\n\n\n\n<pre class=\"wp-block-verse\"><code>DROP USER 'username'@'%';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u30e6\u30fc\u30b6\u30fc\u3092\u3001\u30b5\u30fc\u30d0\u30fc\u30db\u30b9\u30c8\u9650\u5b9a\u3068\u3059\u308b\u5834\u5408\u306f\u3000\u4e0a\u8a18 <code>'%'<\/code>\u3092<code>'localhost'<\/code>\u3068\u3059\u308c\u3070\u3088\u3044<br>\u4f5c\u6210\u3057\u305f\u7ba1\u7406\u8005\u30e6\u30fc\u30b6\u30fc\u306e\u6a29\u9650\u59d4\u8b72\u304c\u3044\u3044\u3048\u306b\u306a\u3063\u3066\u3044\u308b\u5834\u5408\u3001GRANT ALL PRIVILEGIS  \u306e\u5f8c\u308d\u306b\u3000WITH GRANT OPTION\u3000\u3092\u3064\u3051\u5fd8\u308c\u3066\u3044\u308b<\/p>\n\n\n<BR><BR><BR>\n\n<p class=\"wp-block-paragraph\">\u65e2\u5b58\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u30e6\u30fc\u30b6\u30fc\u3092\u8ffd\u52a0<\/p>\n\n\n<pre class=\"wp-block-verse\"><code>GRANT ALL PRIVILEGES ON DATABASE_NAME.* TO 'USER_NAME'@'%';\nFLUSH PRIVILEGES;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5168\u30db\u30b9\u30c8\u304b\u3089\u63a5\u7d9a\u53ef\u80fd\u306a\u7ba1\u7406\u8005\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u4f5c\u6210 CREATE USER &#8216;newuser&#8217;@&#8217;%&#8217; IDENTIFIED BY &#8216;password&#8217;;GRANT ALL PRIVILEGES ON *.* TO &#8216;newu &hellip; <a href=\"https:\/\/eng.miteel.net\/?page_id=935\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">MYSQL \u30e6\u30fc\u30b6\u30fc\u8ffd\u52a0<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"parent":306,"menu_order":99999,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-935","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages\/935","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=935"}],"version-history":[{"count":12,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages\/935\/revisions"}],"predecessor-version":[{"id":1413,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages\/935\/revisions\/1413"}],"up":[{"embeddable":true,"href":"https:\/\/eng.miteel.net\/index.php?rest_route=\/wp\/v2\/pages\/306"}],"wp:attachment":[{"href":"https:\/\/eng.miteel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}