{"id":111,"date":"2026-03-06T22:24:04","date_gmt":"2026-03-06T13:24:04","guid":{"rendered":"https:\/\/systemzero.co.jp\/blog1\/?p=111"},"modified":"2026-03-08T21:21:19","modified_gmt":"2026-03-08T12:21:19","slug":"%e3%83%a6%e3%83%bc%e3%82%b6%e3%83%bc%e4%bd%9c%e6%88%90%e3%81%ae%e6%89%8b%e9%a0%86%ef%bc%88sql%ef%bc%89","status":"publish","type":"post","link":"https:\/\/systemzero.co.jp\/blog1\/2026\/03\/06\/%e3%83%a6%e3%83%bc%e3%82%b6%e3%83%bc%e4%bd%9c%e6%88%90%e3%81%ae%e6%89%8b%e9%a0%86%ef%bc%88sql%ef%bc%89\/","title":{"rendered":"\u30e6\u30fc\u30b6\u30fc\u4f5c\u6210\u306e\u624b\u9806\uff08SQL\uff09"},"content":{"rendered":"\n
    \n
  1. MySQL\u306broot\u3067\u30ed\u30b0\u30a4\u30f3<\/strong>bashmysql -u root -p<\/code><\/li>\n\n\n\n
  2. \u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210 (\u4f8b:\u00a0newuser<\/code>\u3001\u30ed\u30fc\u30ab\u30eb\u63a5\u7d9a\u306e\u307f\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u00a0password123<\/code>)<\/strong>
    sql
    CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password123';<\/mark><\/code>\n
      \n
    • 'localhost'<\/code>\u00a0\u306f\u540c\u3058\u30b5\u30fc\u30d0\u30fc\u5185\u304b\u3089\u306e\u63a5\u7d9a\u3092\u8a31\u53ef\u3057\u307e\u3059\u3002\u5916\u90e8\u304b\u3089\u306e\u63a5\u7d9a\u3092\u8a31\u53ef\u3059\u308b\u5834\u5408\u306f\u00a0'%'<\/code>\u00a0\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002
      <\/li>\n<\/ul>\n<\/li>\n\n\n\n
    • \u6a29\u9650\u3092\u4ed8\u4e0e (\u4f8b: \u5168\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5168\u6a29\u9650\u3092\u4ed8\u4e0e)<\/strong>
      sql
      GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';<\/mark><\/code>\n
        \n
      • \u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u307f\u8a31\u53ef\u3059\u308b\u5834\u5408:\u00a0<\/li>\n\n\n\n
      • GRANT ALL PRIVILEGES ON mydb.* TO 'newuser'@'localhost';<\/code>
        <\/li>\n<\/ul>\n<\/li>\n\n\n\n
      • \u6a29\u9650\u306e\u53cd\u6620<\/strong>
        sql
        FLUSH PRIVILEGES;<\/mark><\/code>
        <\/li>\n\n\n\n
      • \u78ba\u8a8d<\/strong>
        sql
        SELECT user, host FROM mysql.user; <\/mark><\/code>\u00a0<\/li>\n<\/ol>\n\n\n\n

        \u3088\u304f\u4f7f\u3046\u30b3\u30de\u30f3\u30c9<\/p>\n\n\n\n

          \n
        • \u30e6\u30fc\u30b6\u30fc\u524a\u9664<\/strong>:\u00a0DROP USER 'newuser'@'localhost';<\/mark><\/kbd><\/code><\/li>\n\n\n\n
        • \u6a29\u9650\u306e\u78ba\u8a8d<\/strong>: SHOW GRANTS FOR 'newuser'@'localhost';<\/code><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

          \u3088\u304f\u4f7f\u3046\u30b3\u30de\u30f3\u30c9<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-111","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/posts\/111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/comments?post=111"}],"version-history":[{"count":2,"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/posts\/111\/revisions"}],"predecessor-version":[{"id":118,"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/posts\/111\/revisions\/118"}],"wp:attachment":[{"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/media?parent=111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/categories?post=111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systemzero.co.jp\/blog1\/wp-json\/wp\/v2\/tags?post=111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}