{"id":7,"date":"2011-05-30T16:00:07","date_gmt":"2011-05-30T07:00:07","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/wordpress\/?p=7"},"modified":"2015-09-17T11:48:44","modified_gmt":"2015-09-17T02:48:44","slug":"7","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=7","title":{"rendered":"MySQL \u30e6\u30fc\u30b6\u7ba1\u7406"},"content":{"rendered":"

\u25a0\u30e6\u30fc\u30b6\u78ba\u8a8d
\n[code]
\nSELCET user, password, host FROM mysql.user;
\n[\/code]<\/p>\n

\u25a0\u30e6\u30fc\u30b6\u8ffd\u52a0
\n[code]
\nGRANT ALL ON db_name.* TO hoge@localhost IDENTIFIED BY ‘*****’;
\nGRANT ALL ON db_name.* TO hoge@’192.168.0.%’ IDENTIFIED BY ‘*****’;
\nGRANT ALL ON db_name.* TO hoge@’192.168.0.6′ IDENTIFIED BY ‘*****’;
\n[\/code]<\/p>\n

\u25a0\u6a29\u9650\u8ffd\u52a0
\n[code]
\nGRANT ALL ON db_name.* TO hoge@’192.168.0.%’ IDENTIFIED BY ‘*****’;
\n[\/code]<\/p>\n

\u25a0\u30e6\u30fc\u30b6\u524a\u9664
\n[code]
\nREVOKE ALL ON hoge.* FROM db_name@hostname;
\nDELETE FROM mysql.user WHERE USER LIKE ‘hoge’ AND HOST LIKE ‘localhost’;
\n[\/code]
\n[code]
\nREVOKE ALL ON hoge.* FROM db_name@hostname;
\nDELETE FROM mysql.user WHERE USER LIKE ‘hoge’ AND HOST LIKE ‘hostname’;
\n[\/code]
\n[code]
\nREVOKE ALL ON mt.* FROM mt@192.168.0.6;
\nDELETE FROM mysql.user WHERE USER LIKE ‘hoge’ AND HOST LIKE ‘192.168.0.6’;
\n[\/code] <\/p>\n

\u25a0\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5
\n[code]
\nFLUSH PRIVILEGES;
\n[\/code]<\/p>\n","protected":false},"excerpt":{"rendered":"

\u25a0\u30e6\u30fc\u30b6\u78ba\u8a8d [code] SELCET user, password, host FROM mysql.user; [\/code] \u25a0\u30e6\u30fc\u30b6\u8ffd\u52a0 [code] GRANT ALL ON db_name.* TO hog […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[11,4],"tags":[],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-mysql","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7"}],"version-history":[{"count":3,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/7\/revisions"}],"predecessor-version":[{"id":2338,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/7\/revisions\/2338"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}