{"id":1724,"date":"2023-01-12T17:40:09","date_gmt":"2023-01-12T08:40:09","guid":{"rendered":"https:\/\/ysfarm.jp\/blog\/?p=1724"},"modified":"2023-01-07T14:55:46","modified_gmt":"2023-01-07T05:55:46","slug":"centos-stream9-%e5%88%9d%e6%9c%9f%e8%a8%ad%e5%ae%9a-%e3%81%9d%e3%81%ae7-dbmysql-%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%82%b5%e3%83%bc%e3%83%90%e3%83%bc","status":"publish","type":"post","link":"https:\/\/ysfarm.jp\/blog\/2023\/01\/12\/centos-stream9-%e5%88%9d%e6%9c%9f%e8%a8%ad%e5%ae%9a-%e3%81%9d%e3%81%ae7-dbmysql-%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%82%b5%e3%83%bc%e3%83%90%e3%83%bc\/","title":{"rendered":"CentOS Stream9 \u521d\u671f\u8a2d\u5b9a \u305d\u306e7 DB:MySQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc \/ phpMyAdmin"},"content":{"rendered":"<p>MySQL \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc\u3092\u69cb\u7bc9\u3057\u307e\u3059\u3002<\/p>\n<pre>\r\nsudo dnf -y install mysql-server\r\n\r\n======================================================================================================================================\r\n \u30d1\u30c3\u30b1\u30fc\u30b8                                 \u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc       \u30d0\u30fc\u30b8\u30e7\u30f3                         \u30ea\u30dd\u30b8\u30c8\u30ea\u30fc              \u30b5\u30a4\u30ba\r\n======================================================================================================================================\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n mysql-server                               x86_64                 8.0.30-3.el9                       appstream                  17 M\r\n\u4f9d\u5b58\u95a2\u4fc2\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n libicu                                     x86_64                 67.1-9.el9                         baseos                    9.6 M\r\n libtirpc                                   x86_64                 1.3.3-1.el9                        baseos                     93 k\r\n mariadb-connector-c-config                 noarch                 3.2.6-1.el9                        appstream                  11 k\r\n mecab                                      x86_64                 0.996-3.el9.3                      appstream                 356 k\r\n....\r\n....\r\n....\r\n\u5b8c\u4e86\u3057\u307e\u3057\u305f!\r\n<\/pre>\n<pre>\r\nsudo vi \/etc\/my.cnf.d\/charset.cnf\r\n\r\n# \u65b0\u898f\u4f5c\u6210\r\n# \u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u8a2d\u5b9a\r\n# \u7d75\u6587\u5b57\u7b49 4 \u30d0\u30a4\u30c8\u9577\u306e\u6587\u5b57\u3092\u6271\u3046\u5834\u5408\u306f [utf8mb4]\r\n\r\n[mysqld]\r\ncharacter-set-server = utf8mb4\r\n\r\n[client]\r\ndefault-character-set = utf8mb4\r\n\r\n\r\n\u4fdd\u5b58\u5f8c\r\n\r\nsudo systemctl enable --now mysqld\r\n\r\nfirewall-cmd --add-service=mysql\r\nsuccess\r\nfirewall-cmd --runtime-to-permanent\r\nsuccess\r\n<\/pre>\n<p>MySQL\u306e\u521d\u671f\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059<\/p>\n<pre>\r\nsudo mysql_secure_installation\r\n\r\n# \u30d1\u30b9\u30ef\u30fc\u30c9\u54c1\u8cea\u30c1\u30a7\u30c3\u30af\u3092\u6709\u52b9\u306b\u3059\u308b\u304b\u5426\u304b\r\nPress y|Y for Yes, any other key for No: y\r\n\r\n# \u30d1\u30b9\u30ef\u30fc\u30c9\u54c1\u8cea\u30c1\u30a7\u30c3\u30af\u3092\u6709\u52b9\u306b\u3057\u305f\u5834\u5408\u306f\u5f37\u5ea6\u3092\u9078\u629e\r\nPlease enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 0\r\nPlease set the password for root here.\r\n\r\n# MySQL root \u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\r\nNew password:\r\n\r\nRe-enter new password:\r\n\r\n# \u5165\u529b\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9\u3067\u826f\u3044\u304b\u306e\u78ba\u8a8d\r\nEstimated strength of the password: 100\r\nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y\r\n\r\n# \u533f\u540d\u30e6\u30fc\u30b6\u30fc\u3092\u524a\u9664\u3059\u308b\u304b\u5426\u304b\r\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : y\r\n\r\n# root \u30e6\u30fc\u30b6\u30fc\u306e\u30ea\u30e2\u30fc\u30c8\u30ed\u30b0\u30a4\u30f3\u3092\u7121\u52b9\u3068\u3059\u308b\u304b\u5426\u304b\r\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y\r\n\r\n# \u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u524a\u9664\u3059\u308b\u304b\u5426\u304b\r\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y\r\n\r\n# \u7279\u6a29\u60c5\u5831\u3092\u30ea\u30ed\u30fc\u30c9\u3059\u308b\u304b\u5426\u304b\r\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\r\n\r\nAll done!\r\n<\/pre>\n<p>\u3053\u306e\u3042\u3068phpMyAdmin\u5165\u308c\u305f\u3089\u300cYour Composer dependencies require the following PHP extensions to be installed: mysqli\u300d\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u306e\u3067\u8a00\u308f\u308c\u308b\u304c\u307e\u307e\u4ee5\u4e0b\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/p>\n<pre>\r\nsudo dnf -y install php-mysqli\r\n\r\n======================================================================================================================================\r\n \u30d1\u30c3\u30b1\u30fc\u30b8                       \u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u30fc            \u30d0\u30fc\u30b8\u30e7\u30f3                         \u30ea\u30dd\u30b8\u30c8\u30ea\u30fc                   \u30b5\u30a4\u30ba\r\n======================================================================================================================================\r\n\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb:\r\n php-mysqlnd                      x86_64                      8.0.20-3.el9                       appstream                      153 k\r\n\r\n\u5b8c\u4e86\u3057\u307e\u3057\u305f!\r\n<\/pre>\n<p>phpMyAdmin\u306b\u95a2\u3057\u3066\u306f\u3001\u3044\u3064\u3082ftp\u3067\u30b5\u30fc\u30d0\u30fc\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u3066\u3001\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u7279\u306b\u96e3\u3057\u3044\u8a2d\u5b9a\u306f\u3057\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc\u3092\u69cb\u7bc9\u3057\u307e\u3059\u3002 sudo dnf -y install mysql-server =========================================== [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1508,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"vkexunit_cta_each_option":"","footnotes":""},"categories":[405,404,399],"tags":[],"class_list":["post-1724","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-linux","category-399"],"_links":{"self":[{"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/posts\/1724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/comments?post=1724"}],"version-history":[{"count":6,"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/posts\/1724\/revisions"}],"predecessor-version":[{"id":1733,"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/posts\/1724\/revisions\/1733"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/media\/1508"}],"wp:attachment":[{"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/media?parent=1724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/categories?post=1724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ysfarm.jp\/blog\/wp-json\/wp\/v2\/tags?post=1724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}