{"id":13,"date":"2023-07-04T08:48:47","date_gmt":"2023-07-03T23:48:47","guid":{"rendered":"https:\/\/melodystory.co.kr\/?p=13"},"modified":"2023-07-04T08:48:47","modified_gmt":"2023-07-03T23:48:47","slug":"linux-%ed%99%98%ea%b2%bd%ec%97%90%ec%84%9c-mysql-mariadb-%eb%b2%84%ec%a0%84-%ed%99%95%ec%9d%b8-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/pigletstory.co.kr\/?p=13","title":{"rendered":"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95"},"content":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694.<\/p>\n<p>\uc624\ub298\uc740 linux \ud658\uacbd\uc5d0\uc11c mysql \ubc0f mariadb \uc758 \ubc84\uc804\uc744 \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>OS \uc5d0\uc11c \ubc14\ub85c \ud655\uc778<\/li>\n<\/ul>\n<p>[root@woo ~]# mysql &#8211;version<br \/>\nmysql Ver 15.1 Distrib 10.0.30-MariaDB, for Linux (x86_64) using readline 5.1<\/p>\n<p>[root@woo ~]# mysqladmin -uroot -p\ud328\uc2a4\uc6cc\ub4dc version | grep ^Server<br \/>\nServer version 10.0.30-MariaDB<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>DB \uc811\uc18d \ud6c4 \ud655\uc778<\/li>\n<\/ul>\n<p>[root@woo ~]# mysql -uroot -p<br \/>\nEnter password: \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825<br \/>\nWelcome to the MariaDB monitor. Commands end with ; or \\g.<br \/>\nYour MariaDB connection id is 41489<br \/>\nServer version: 10.0.30-MariaDB MariaDB Server<\/p>\n<p>or<\/p>\n<p>MariaDB [(none)]&gt; use mysql<br \/>\nDatabase changed<br \/>\nMariaDB [mysql]&gt; select version();<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<br \/>\n| version() |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<br \/>\n| 10.0.30-MariaDB |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<br \/>\n1 row in set (0.00 sec)<\/p>\n<p>or<\/p>\n<p>MariaDB [mysql]&gt; show variables like &#8216;version&#8217;;<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<br \/>\n| Variable_name | Value |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<br \/>\n| version | 10.0.30-MariaDB |<br \/>\n+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+<br \/>\n1 row in set (0.00 sec)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694. \uc624\ub298\uc740 linux \ud658\uacbd\uc5d0\uc11c mysql \ubc0f mariadb \uc758 \ubc84\uc804\uc744 \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. &nbsp; OS \uc5d0\uc11c \ubc14\ub85c \ud655\uc778 [root@woo ~]# mysql &#8211;version mysql Ver 15.1 Distrib 10.0.30-MariaDB, for Linux (x86_64) using readline 5.1 [root@woo ~]# mysqladmin -uroot -p\ud328\uc2a4\uc6cc\ub4dc version | grep ^Server Server version 10.0.30-MariaDB &nbsp; DB \uc811\uc18d \ud6c4 \ud655\uc778 [root@woo ~]# mysql -uroot -p &#8230; <a title=\"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95\" class=\"read-more\" href=\"https:\/\/pigletstory.co.kr\/?p=13\" aria-label=\"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694\">\ub354 \uc77d\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7],"tags":[20,33,73,74,96,104,129],"class_list":{"0":"post-13","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-mariadb","7":"tag-centos-db-","8":"tag-db-","9":"tag-linux-db-","11":"tag-mariadb-","12":"tag-mysql-","13":"tag-rockylinux-db-"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95 - pigletstory \ube14\ub85c\uadf8<\/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:\/\/pigletstory.co.kr\/?p=13\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95 - pigletstory \ube14\ub85c\uadf8\" \/>\n<meta property=\"og:description\" content=\"\uc548\ub155\ud558\uc138\uc694. \uc624\ub298\uc740 linux \ud658\uacbd\uc5d0\uc11c mysql \ubc0f mariadb \uc758 \ubc84\uc804\uc744 \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. &nbsp; OS \uc5d0\uc11c \ubc14\ub85c \ud655\uc778 [root@woo ~]# mysql &#8211;version mysql Ver 15.1 Distrib 10.0.30-MariaDB, for Linux (x86_64) using readline 5.1 [root@woo ~]# mysqladmin -uroot -p\ud328\uc2a4\uc6cc\ub4dc version | grep ^Server Server version 10.0.30-MariaDB &nbsp; DB \uc811\uc18d \ud6c4 \ud655\uc778 [root@woo ~]# mysql -uroot -p ... \ub354 \uc77d\uae30\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pigletstory.co.kr\/?p=13\" \/>\n<meta property=\"og:site_name\" content=\"pigletstory \ube14\ub85c\uadf8\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T23:48:47+00:00\" \/>\n<meta name=\"author\" content=\"woo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"woo\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=13#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=13\"},\"author\":{\"name\":\"woo\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#\\\/schema\\\/person\\\/d7120640ee051cf680fd1c6a5208d620\"},\"headline\":\"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95\",\"datePublished\":\"2023-07-03T23:48:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=13\"},\"wordCount\":106,\"commentCount\":0,\"keywords\":[\"centos db \ubc84\uc804\ud655\uc778\",\"db \ubc84\uc804\ud655\uc778\",\"linux db \ubc84\uc804\ud655\uc778\",\"linux db \ud655\uc778\",\"mariadb \ubc84\uc804\ud655\uc778\",\"mysql \ubc84\uc804\ud655\uc778\",\"rockylinux db \ubc84\uc804\ud655\uc778\"],\"articleSection\":[\"MariaDB\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/pigletstory.co.kr\\\/?p=13#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=13\",\"url\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=13\",\"name\":\"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95 - pigletstory \ube14\ub85c\uadf8\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#website\"},\"datePublished\":\"2023-07-03T23:48:47+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#\\\/schema\\\/person\\\/d7120640ee051cf680fd1c6a5208d620\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=13#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pigletstory.co.kr\\\/?p=13\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/?p=13#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pigletstory.co.kr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#website\",\"url\":\"https:\\\/\\\/pigletstory.co.kr\\\/\",\"name\":\"pigletstory \ube14\ub85c\uadf8\",\"description\":\"pigletstory\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pigletstory.co.kr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pigletstory.co.kr\\\/#\\\/schema\\\/person\\\/d7120640ee051cf680fd1c6a5208d620\",\"name\":\"woo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g\",\"caption\":\"woo\"},\"sameAs\":[\"http:\\\/\\\/129.154.62.45\"],\"url\":\"https:\\\/\\\/pigletstory.co.kr\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95 - pigletstory \ube14\ub85c\uadf8","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:\/\/pigletstory.co.kr\/?p=13","og_locale":"ko_KR","og_type":"article","og_title":"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95 - pigletstory \ube14\ub85c\uadf8","og_description":"\uc548\ub155\ud558\uc138\uc694. \uc624\ub298\uc740 linux \ud658\uacbd\uc5d0\uc11c mysql \ubc0f mariadb \uc758 \ubc84\uc804\uc744 \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. &nbsp; OS \uc5d0\uc11c \ubc14\ub85c \ud655\uc778 [root@woo ~]# mysql &#8211;version mysql Ver 15.1 Distrib 10.0.30-MariaDB, for Linux (x86_64) using readline 5.1 [root@woo ~]# mysqladmin -uroot -p\ud328\uc2a4\uc6cc\ub4dc version | grep ^Server Server version 10.0.30-MariaDB &nbsp; DB \uc811\uc18d \ud6c4 \ud655\uc778 [root@woo ~]# mysql -uroot -p ... \ub354 \uc77d\uae30","og_url":"https:\/\/pigletstory.co.kr\/?p=13","og_site_name":"pigletstory \ube14\ub85c\uadf8","article_published_time":"2023-07-03T23:48:47+00:00","author":"woo","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"woo","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pigletstory.co.kr\/?p=13#article","isPartOf":{"@id":"https:\/\/pigletstory.co.kr\/?p=13"},"author":{"name":"woo","@id":"https:\/\/pigletstory.co.kr\/#\/schema\/person\/d7120640ee051cf680fd1c6a5208d620"},"headline":"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95","datePublished":"2023-07-03T23:48:47+00:00","mainEntityOfPage":{"@id":"https:\/\/pigletstory.co.kr\/?p=13"},"wordCount":106,"commentCount":0,"keywords":["centos db \ubc84\uc804\ud655\uc778","db \ubc84\uc804\ud655\uc778","linux db \ubc84\uc804\ud655\uc778","linux db \ud655\uc778","mariadb \ubc84\uc804\ud655\uc778","mysql \ubc84\uc804\ud655\uc778","rockylinux db \ubc84\uc804\ud655\uc778"],"articleSection":["MariaDB"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/pigletstory.co.kr\/?p=13#respond"]}]},{"@type":"WebPage","@id":"https:\/\/pigletstory.co.kr\/?p=13","url":"https:\/\/pigletstory.co.kr\/?p=13","name":"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95 - pigletstory \ube14\ub85c\uadf8","isPartOf":{"@id":"https:\/\/pigletstory.co.kr\/#website"},"datePublished":"2023-07-03T23:48:47+00:00","author":{"@id":"https:\/\/pigletstory.co.kr\/#\/schema\/person\/d7120640ee051cf680fd1c6a5208d620"},"breadcrumb":{"@id":"https:\/\/pigletstory.co.kr\/?p=13#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pigletstory.co.kr\/?p=13"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/pigletstory.co.kr\/?p=13#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pigletstory.co.kr\/"},{"@type":"ListItem","position":2,"name":"Linux \ud658\uacbd\uc5d0\uc11c MySQL , MariaDB \ubc84\uc804 \ud655\uc778 \ubc29\ubc95"}]},{"@type":"WebSite","@id":"https:\/\/pigletstory.co.kr\/#website","url":"https:\/\/pigletstory.co.kr\/","name":"pigletstory \ube14\ub85c\uadf8","description":"pigletstory","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pigletstory.co.kr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/pigletstory.co.kr\/#\/schema\/person\/d7120640ee051cf680fd1c6a5208d620","name":"woo","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/secure.gravatar.com\/avatar\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f7d07f5222a5108393f05e78f2bac1e7acbea452123f477645ad4dc5696acc36?s=96&d=mm&r=g","caption":"woo"},"sameAs":["http:\/\/129.154.62.45"],"url":"https:\/\/pigletstory.co.kr\/?author=1"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/13","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13"}],"version-history":[{"count":0,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions"}],"wp:attachment":[{"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pigletstory.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}