{"id":2884,"date":"2025-02-24T22:16:20","date_gmt":"2025-02-24T13:16:20","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/?p=2884"},"modified":"2025-04-16T23:19:35","modified_gmt":"2025-04-16T14:19:35","slug":"mysql-2025%e5%b9%b4%e5%ba%a6%e7%89%88-%e5%88%9d%e6%9c%9f%e8%a8%ad%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=2884","title":{"rendered":"MySQL 2025\u5e74\u5ea6\u7248 \u521d\u671f\u8a2d\u5b9a"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210 \u203b\u6307\u5b9a\u3057\u306a\u304f\u3066\u3082Default\u306f utf8mb4<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE db_name CHARACTER SET utf8mb4;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u524a\u9664<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP DATABASE db_name;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u60c5\u5831\u8868\u793a<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW CREATE DATABASE db_name;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW DATABASES;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u30c6\u30fc\u30d6\u30eb\u4e00\u89a7<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW TABLES;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5909\u66f4<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>USE db_name;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u30e6\u30fc\u30b6\u4f5c\u6210 \u203b8.0\u3088\u308a\u4ee5\u524d\u306fCREATE USER\u306f\u4f7f\u7528\u3057\u306a\u304b\u3063\u305f<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'xxxxxxxx';<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u6a29\u9650\u4ed8\u4e0e<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL ON db_name.* TO 'user_name'@'localhost';<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>FLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">\u30d1\u30b9\u30ef\u30fc\u30c9\u5909\u66f4<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code><s>set password for user_name@localhost='xxxxxxxx';<\/s>\nALTER USER 'user_name'@'localhost' IDENTIFIED BY 'xxxxxxxx';<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">DB\u30e6\u30fc\u30b6\u4e00\u89a7<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT user FROM mysql.user;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210 \u203b\u6307\u5b9a\u3057\u306a\u304f\u3066\u3082Default\u306f utf8mb4 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u524a\u9664 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u60c5\u5831\u8868\u793a \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7 \u30c6\u30fc\u30d6\u30eb\u4e00\u89a7 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5909\u66f4 \u30e6\u30fc\u30b6\u4f5c\u6210 \u203b8.0\u3088\u308a\u4ee5\u524d\u306fCREATE USER\u306f\u4f7f\u7528\u3057\u306a [&hellip;]<\/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-2884","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\/2884","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=2884"}],"version-history":[{"count":7,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2884\/revisions"}],"predecessor-version":[{"id":2997,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2884\/revisions\/2997"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}