{"id":11234,"date":"2023-05-08T06:04:16","date_gmt":"2023-05-07T21:04:16","guid":{"rendered":"https:\/\/lab4ict.com\/system\/?p=11234"},"modified":"2023-05-09T08:38:02","modified_gmt":"2023-05-08T23:38:02","slug":"mariadb%e3%81%ab%e3%83%8d%e3%83%83%e3%83%88%e3%83%af%e3%83%bc%e3%82%af%e7%b5%8c%e7%94%b1%e3%81%a7%e6%8e%a5%e7%b6%9a%e5%8f%af%e8%83%bd%e3%81%ab%e3%81%99%e3%82%8b%ef%bc%81%ef%bc%88rocky-linux-9%ef%bc%89","status":"publish","type":"post","link":"https:\/\/lab4ict.com\/system\/archives\/11234","title":{"rendered":"MariaDB\u306b\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u7d4c\u7531\u3067\u63a5\u7d9a\u53ef\u80fd\u306b\u3059\u308b\uff01\uff08Rocky Linux 9\uff09"},"content":{"rendered":"<p>Rocky Linux 9\u4e0a\u3067\u7a3c\u50cd\u3059\u308bMariaDB\u306b\u3001\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u7d4c\u7531\u3067\u63a5\u7d9a\u53ef\u80fd\u306b\u306a\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002<br \/>\n<!--more--><\/p>\n<h2>MariaDB\u306e\u30ea\u30c3\u30b9\u30f3\u72b6\u614b\u3092\u78ba\u8a8d\u3059\u308b\uff01<\/h2>\n<p>\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001IP\u30a2\u30c9\u30ec\u30b9\u300c0.0.0.0\u300d\u3042\u308b\u3044\u306f\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u3067\u30ea\u30c3\u30b9\u30f3\u3057\u3066\u3044\u308c\u3070\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n# ss -lt4np\r\nState     Recv-Q    Send-Q       Local Address:Port         Peer Address:Port    Process                                \r\nLISTEN    0         80                 0.0.0.0:3306              0.0.0.0:*        users:((&quot;mariadbd&quot;,pid=780,fd=20)\r\n<\/pre>\n<p>\u300c127.0.0.1\u300d\u306e\u5834\u5408\u306f\u3001\u30ea\u30c3\u30b9\u30f3\u3059\u308bIP\u30a2\u30c9\u30ec\u30b9\u3092\u3092\u300c0.0.0.0\u300d\u3042\u308b\u3044\u306f\u30b5\u30fc\u30d0\u306eIP\u30a2\u30c9\u30ec\u30b9\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n<h2>Firewalld\u3067MariaDB\u3078\u306e\u901a\u4fe1\u3092\u8a31\u53ef\u3059\u308b\uff01<\/h2>\n<p>Firewalld\u3067MariaDB\u3078\u306e\u901a\u4fe1\u3092\u8a31\u53ef\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n# firewall-cmd --permanent --add-port=3306\/tcp --zone=public\r\n# firewall-cmd --reload\r\n# firewall-cmd --list-ports\r\n3306\/tcp\r\n<\/pre>\n<h2>\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u63a5\u7d9a\u3059\u308b\u30e6\u30fc\u30b6\u3092\u4f5c\u6210\u3059\u308b\uff01<\/h2>\n<p>\u63a5\u7d9a\u78ba\u8a8d\u7528\u306b\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u63a5\u7d9a\u3059\u308b\u30e6\u30fc\u30b6\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n# mariadb\r\n&gt; grant all privileges on *.* to 'mariadb'@'%' identified by 'mariadb' with grant option;\r\nQuery OK, 0 rows affected (0.003 sec)\r\n<\/pre>\n<h2>\u304a\u308f\u308a\u306b<\/h2>\n<p>Rocky Linux 9\u3067\u306f\u3001MariaDB\u306b\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u63a5\u7d9a\u53ef\u80fd\u306b\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u901a\u4fe1\u8a31\u53ef\u8a2d\u5b9a\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<h2>\u53c2\u8003\u60c5\u5831<\/h2>\n<ul>\n<li><a href=\"https:\/\/mariadb.com\/kb\/en\/\" target=\"_blank\" rel=\"noopener\">MariaDB - Knowledge Base<\/a><\/li>\n<\/ul>\n<h2>\u95a2\u9023\u8a18\u4e8b<\/h2>\n<div class=\"sc_getpost\"><a class=\"clearfix\" href=\"https:\/\/lab4ict.com\/system\/archives\/10315\" ><div class=\"sc_getpost_thumb post-box-thumbnail__wrap\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODdhAQABAPAAAN3d3QAAACwAAAAAAQABAAACAkQBADs=\" width=\"150\" height=\"150\" alt=\"\u3010\u8a18\u4e8b\u4e00\u89a7\u3011MariaDB\u3092\u4f7f\u3044\u3053\u306a\u3059\uff01\" loading=\"lazy\" data-src=\"https:\/\/lab4ict.com\/system\/wp-content\/uploads\/2023\/05\/eyecatch_mariadb_01-150x150.png\" class=\"lazyload\"><span style=\"background:\" class=\"sc_getpost_cat\">MariaDB<\/span><\/div><div class=\"title\">\u3010\u8a18\u4e8b\u4e00\u89a7\u3011MariaDB\u3092\u4f7f\u3044\u3053\u306a\u3059\uff01<\/div><div class=\"substr\">MariaDB\u3092\u4f7f\u3044\u3053\u306a\u3059\u305f\u3081\u306e\u8a18\u4e8b\u4e00\u89a7\u3092\u63b2\u8f09\u3057\u307e\u3059\u3002...<\/div><\/a><\/div>\n<h2>\u95a2\u9023\u66f8\u7c4d\uff08Amazon\u5546\u54c1\u30ea\u30f3\u30af\uff09<\/h2>\n<p><iframe sandbox=\"allow-popups allow-scripts allow-modals allow-forms allow-same-origin\" style=\"width:120px;height:240px;\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" frameborder=\"0\" src=\"\/\/rcm-fe.amazon-adsystem.com\/e\/cm?lt1=_blank&bc1=000000&IS2=1&bg1=FFFFFF&fc1=000000&lc1=0000FF&t=infotecr-22&language=ja_JP&o=9&p=8&l=as4&m=amazon&f=ifr&ref=as_ss_li_til&asins=4774170208&linkId=800d87b228f07a60389e656d94ab962a\"><\/iframe><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Rocky Linux 9\u4e0a\u3067\u7a3c\u50cd\u3059\u308bMariaDB\u306b\u3001\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u7d4c\u7531\u3067\u63a5\u7d9a\u53ef\u80fd\u306b\u306a\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":1,"featured_media":11333,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[222],"tags":[],"class_list":["post-11234","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mariadb"],"_links":{"self":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/11234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/comments?post=11234"}],"version-history":[{"count":4,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/11234\/revisions"}],"predecessor-version":[{"id":11246,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/11234\/revisions\/11246"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/media\/11333"}],"wp:attachment":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/media?parent=11234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/categories?post=11234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/tags?post=11234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}