{"id":6246,"date":"2024-06-19T01:10:23","date_gmt":"2024-06-18T16:10:23","guid":{"rendered":"https:\/\/higherhope.net\/?p=6246"},"modified":"2024-06-19T01:11:25","modified_gmt":"2024-06-18T16:11:25","slug":"mariadb%e3%81%ae%e3%83%90%e3%83%bc%e3%82%b8%e3%83%a7%e3%83%b3%e3%82%9211-0-6%e3%81%8b%e3%82%8911-4-2%e3%81%ab%e4%b8%8a%e3%81%92%e3%81%a6%e3%81%bf%e3%81%9f%e3%80%82","status":"publish","type":"post","link":"https:\/\/higherhope.net\/?p=6246","title":{"rendered":"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002"},"content":{"rendered":"<p>\u3042\u307e\u308a\u306b\u591c\u5bdd\u308c\u306a\u3044\u306e\u3067\u3001\u9152\u98f2\u307f\u306a\u304c\u3089\u3084\u3063\u3066\u307f\u305f\u7d50\u679c\u3092\u30b7\u30a7\u30a2\u3057\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u3057\u305fMariaDB\u306e\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u4f5c\u696d\u8a18\u9332\u3067\u3059\u3002<\/p>\n<p>\u73fe\u5728\u306eMariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f<br \/>\n<code>Server version: 11.0.6-MariaDB-log MariaDB Server<\/code><\/p>\n<p>\u516c\u5f0f\u30b5\u30a4\u30c8\u306b\u3088\u308b\u3068\u300111.4.3\u304c\u51fa\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u304c\u3001\u4eca\u56de\u306fdnf\u3084yum\u3067\u5165\u308b<strong>MariaDB 11.4.2<\/strong>\u306b\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<p>\u4f5c\u696d\u7528\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<br \/>\n<code># cd \/root\/work\/<\/code><\/p>\n<p>\u4f5c\u696d\u958b\u59cb\u3067\u3059\u3002<br \/>\n<strong>1.\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/strong><br \/>\n<code># wget https:\/\/r.mariadb.com\/downloads\/mariadb_repo_setup<\/code><\/p>\n<p><strong>2.\u5b9f\u884c\u6a29\u9650\u3092\u4ed8\u3051\u307e\u3059<\/strong><br \/>\n<code># chmod +x mariadb_repo_setup<\/code><\/p>\n<p><strong>3\uff0e\u5b9f\u884c\u3057\u307e\u3059<\/strong><br \/>\n<code>.\/mariadb_repo_setup<br \/>\n[info] Checking for script prerequisites.<br \/>\n[warning] Found existing file at \/etc\/yum.repos.d\/mariadb.repo. Moving to \/etc\/yum.repos.d\/mariadb.repo.old_2<br \/>\n[info] MariaDB Server version 11.4 is valid<br \/>\n[info] Repository file successfully written to \/etc\/yum.repos.d\/mariadb.repo<br \/>\n[info] Adding trusted package signing keys...<br \/>\n\/etc\/pki\/rpm-gpg ~\/work<br \/>\n~\/work<\/p>\n<p>[info] Successfully added trusted package signing keys<br \/>\n[info] Cleaning package cache...<br \/>\n102 files removed<br \/>\n<\/code><\/p>\n<p><strong>4.\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u306e\u78ba\u8a8d<\/strong><br \/>\n<code># dnf check-update<br \/>\n\u7565<br \/>\nMariaDB-client.x86_64 11.4.2-1.el8 mariadb-main<br \/>\nMariaDB-client-compat.noarch 11.4.2-1.el8 mariadb-main<br \/>\nMariaDB-common.x86_64 11.4.2-1.el8 mariadb-main<br \/>\nMariaDB-server.x86_64 11.4.2-1.el8 mariadb-main<br \/>\nMariaDB-server-compat.noarch 11.4.2-1.el8 mariadb-main<br \/>\nMariaDB-shared.x86_64 11.4.2-1.el8 mariadb-main<br \/>\n<\/code><\/p>\n<p>11.4.2-1.el8 \u304c\u964d\u3063\u3066\u6765\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><strong>5.\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u5b9f\u884c<\/strong><br \/>\n<code># dnf -y update<br \/>\n\u7565<br \/>\nUpgraded:<br \/>\nMariaDB-client-11.4.2-1.el8.x86_64<br \/>\nMariaDB-client-compat-11.4.2-1.el8.noarch<br \/>\nMariaDB-common-11.4.2-1.el8.x86_64<br \/>\nMariaDB-server-11.4.2-1.el8.x86_64<br \/>\nMariaDB-server-compat-11.4.2-1.el8.noarch<br \/>\nMariaDB-shared-11.4.2-1.el8.x86_64<br \/>\nInstalled:<br \/>\nliburing-1.0.7-3.el8.x86_64<br \/>\n<\/code><\/p>\n<p>MariaDB\u304c11.4.2-1\u306b\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<p><strong>6.\u78ba\u8a8d<\/strong><br \/>\n<code># mysql -v<br \/>\nmysql: Deprecated program name. It will be removed in a future release, use '\/usr\/bin\/mariadb' instead<br \/>\nWelcome to the MariaDB monitor. Commands end with ; or \\g.<br \/>\nYour MariaDB connection id is 11<br \/>\nServer version: 11.4.2-MariaDB-log MariaDB Server<br \/>\n<\/code><\/p>\n<p>\u7121\u4e8b\u306b\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3042\u307e\u308a\u306b\u591c\u5bdd\u308c\u306a\u3044\u306e\u3067\u3001\u9152\u98f2\u307f\u306a\u304c\u3089\u3084\u3063\u3066\u307f\u305f\u7d50\u679c\u3092\u30b7\u30a7\u30a2\u3057\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u3057\u305fMariaDB\u306e\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u4f5c\u696d\u8a18\u9332\u3067\u3059\u3002 \u73fe\u5728\u306eMariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f Server version: 11.0.6-MariaDB&#8230; <a class=\"continue-reading-link\" href=\"https:\/\/higherhope.net\/?p=6246\"> Continue reading <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1065,4,159],"tags":[70],"class_list":["post-6246","post","type-post","status-publish","format-standard","hentry","category-almalinux","category-linux","category-mysql-mariadb","tag-mariadb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/higherhope.net\/?p=6246\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"og:description\" content=\"\u3042\u307e\u308a\u306b\u591c\u5bdd\u308c\u306a\u3044\u306e\u3067\u3001\u9152\u98f2\u307f\u306a\u304c\u3089\u3084\u3063\u3066\u307f\u305f\u7d50\u679c\u3092\u30b7\u30a7\u30a2\u3057\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u3057\u305fMariaDB\u306e\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u4f5c\u696d\u8a18\u9332\u3067\u3059\u3002 \u73fe\u5728\u306eMariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f Server version: 11.0.6-MariaDB... Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/higherhope.net\/?p=6246\" \/>\n<meta property=\"og:site_name\" content=\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-18T16:10:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-18T16:11:25+00:00\" \/>\n<meta name=\"author\" content=\"higherhope\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:site\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"higherhope\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/higherhope.net\/?p=6246#article\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/?p=6246\"},\"author\":{\"name\":\"higherhope\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"headline\":\"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002\",\"datePublished\":\"2024-06-18T16:10:23+00:00\",\"dateModified\":\"2024-06-18T16:11:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/higherhope.net\/?p=6246\"},\"wordCount\":10,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"keywords\":[\"mariadb\"],\"articleSection\":[\"AlmaLinux\",\"linux\",\"mysql,mariadb\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/higherhope.net\/?p=6246#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/higherhope.net\/?p=6246\",\"url\":\"https:\/\/higherhope.net\/?p=6246\",\"name\":\"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/#website\"},\"datePublished\":\"2024-06-18T16:10:23+00:00\",\"dateModified\":\"2024-06-18T16:11:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/higherhope.net\/?p=6246#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/higherhope.net\/?p=6246\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/higherhope.net\/?p=6246#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\/\/higherhope.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/higherhope.net\/#website\",\"url\":\"https:\/\/higherhope.net\/\",\"name\":\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"description\":\"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002\",\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/higherhope.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\",\"name\":\"higherhope\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"contentUrl\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"width\":700,\"height\":394,\"caption\":\"higherhope\"},\"logo\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/higherhope5963\"],\"url\":\"https:\/\/higherhope.net\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/higherhope.net\/?p=6246","og_locale":"ja_JP","og_type":"article","og_title":"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","og_description":"\u3042\u307e\u308a\u306b\u591c\u5bdd\u308c\u306a\u3044\u306e\u3067\u3001\u9152\u98f2\u307f\u306a\u304c\u3089\u3084\u3063\u3066\u307f\u305f\u7d50\u679c\u3092\u30b7\u30a7\u30a2\u3057\u307e\u3059\u3002\u3061\u3087\u3063\u3068\u3057\u305fMariaDB\u306e\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u4f5c\u696d\u8a18\u9332\u3067\u3059\u3002 \u73fe\u5728\u306eMariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f Server version: 11.0.6-MariaDB... Continue reading &rarr;","og_url":"https:\/\/higherhope.net\/?p=6246","og_site_name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","article_published_time":"2024-06-18T16:10:23+00:00","article_modified_time":"2024-06-18T16:11:25+00:00","author":"higherhope","twitter_card":"summary_large_image","twitter_creator":"@higherhope5963","twitter_site":"@higherhope5963","twitter_misc":{"\u57f7\u7b46\u8005":"higherhope","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"1\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/higherhope.net\/?p=6246#article","isPartOf":{"@id":"https:\/\/higherhope.net\/?p=6246"},"author":{"name":"higherhope","@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"headline":"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002","datePublished":"2024-06-18T16:10:23+00:00","dateModified":"2024-06-18T16:11:25+00:00","mainEntityOfPage":{"@id":"https:\/\/higherhope.net\/?p=6246"},"wordCount":10,"commentCount":0,"publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"keywords":["mariadb"],"articleSection":["AlmaLinux","linux","mysql,mariadb"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/higherhope.net\/?p=6246#respond"]}]},{"@type":"WebPage","@id":"https:\/\/higherhope.net\/?p=6246","url":"https:\/\/higherhope.net\/?p=6246","name":"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","isPartOf":{"@id":"https:\/\/higherhope.net\/#website"},"datePublished":"2024-06-18T16:10:23+00:00","dateModified":"2024-06-18T16:11:25+00:00","breadcrumb":{"@id":"https:\/\/higherhope.net\/?p=6246#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/higherhope.net\/?p=6246"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/higherhope.net\/?p=6246#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/higherhope.net\/"},{"@type":"ListItem","position":2,"name":"MariaDB\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u309211.0.6\u304b\u308911.4.2\u306b\u4e0a\u3052\u3066\u307f\u305f\u3002"}]},{"@type":"WebSite","@id":"https:\/\/higherhope.net\/#website","url":"https:\/\/higherhope.net\/","name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","description":"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002","publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/higherhope.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af","name":"higherhope","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/","url":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","contentUrl":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","width":700,"height":394,"caption":"higherhope"},"logo":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/x.com\/higherhope5963"],"url":"https:\/\/higherhope.net\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/6246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6246"}],"version-history":[{"count":4,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/6246\/revisions"}],"predecessor-version":[{"id":6250,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/6246\/revisions\/6250"}],"wp:attachment":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}