{"id":243,"date":"2020-06-13T22:28:37","date_gmt":"2020-06-13T13:28:37","guid":{"rendered":"https:\/\/tech.softbell.net\/?p=243"},"modified":"2020-06-13T22:28:37","modified_gmt":"2020-06-13T13:28:37","slug":"mysql-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%b6%94%ea%b0%80-%eb%b0%8f-%ea%b6%8c%ed%95%9c-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"https:\/\/tech.softbell.net\/?p=243","title":{"rendered":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815"},"content":{"rendered":"\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\">\uc804\uc81c \uc870\uac74<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL Server 5.7.29<\/li><li>MySQL \ucf58\uc194 \uc811\uc18d<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\">MySQL \uc811\uc18d<\/h2>\n\n\n\n<p>\ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">$ sudo mysql<\/pre>\n\n\n\n<p>MySQL \ucf58\uc194 \uc811\uc18d \ud6c4<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mysql> USE mysql;<\/pre>\n<\/div><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\">\uacc4\uc815 \ud655\uc778<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mysql> SELECT host, user, authentication_string FROM user;<\/pre>\n\n\n\n<p>\uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.<br>\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading\">\uacc4\uc815 \ucd94\uac00<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mysql> CREATE USER '\uc0ac\uc6a9\uc790'@'localhost' IDENTIFIED BY '\ube44\ubc00\ubc88\ud638';\nmysql> CREATE USER '\uc0ac\uc6a9\uc790'@'%' IDENTIFIED BY '\ube44\ubc00\ubc88\ud638';\nmysql> CREATE USER '\uc0ac\uc6a9\uc790'@'192.168.1.%' IDENTIFIED BY '\ube44\ubc00\ubc88\ud638';<\/pre>\n\n\n\n<p>1: localhost(\uc11c\ubc84)\uc5d0\uc11c\ub9cc \uc811\uc18d \uac00\ub2a5<br>2: %(\uc640\uc77c\ub4dc\uce74\ub4dc) \ubaa8\ub4e0 \ub300\uc5ed\uc5d0\uc11c \uc811\uc18d \uac00\ub2a5<br>3: 192.168.1.* \ub300\uc5ed\uc5d0\uc11c \uc811\uc18d \uac00\ub2a5<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uad8c\ud55c \ubd80\uc5ec<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mysql> GRANT ALL PRIVILEGES ON *.* TO '\uc0ac\uc6a9\uc790'@'\uc811\uadfc \ub300\uc5ed';\nmysql> GRANT ALL PRIVILEGES ON \uc2a4\ud0a4\ub9c8.* TO '\uc0ac\uc6a9\uc790'@'\uc811\uadfc \ub300\uc5ed';<\/pre>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uacc4\uc815 \uc0ad\uc81c<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mysql> DROP USER  '\uc0ac\uc6a9\uc790'@'localhost';<\/pre>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\ubcc0\uacbd\uc0ac\ud56d \uc801\uc6a9<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">mysql> FLUSH PRIVILEGES;<\/pre>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>\uc870\ud68c\uc218: 210<\/p>","protected":false},"excerpt":{"rendered":"<p>\uc804\uc81c \uc870\uac74 MySQL Server 5.7.29 MySQL \ucf58\uc194 \uc811\uc18d MySQL \uc811\uc18d \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c MySQL \ucf58\uc194 \uc811\uc18d \ud6c4 \uacc4\uc815 \ud655\uc778 \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uacc4\uc815 \ucd94\uac00 1: localhost(\uc11c\ubc84)\uc5d0\uc11c\ub9cc \uc811\uc18d \uac00\ub2a52: %(\uc640\uc77c\ub4dc\uce74\ub4dc) \ubaa8\ub4e0 \ub300\uc5ed\uc5d0\uc11c \uc811\uc18d \uac00\ub2a53: 192.168.1.* \ub300\uc5ed\uc5d0\uc11c \uc811\uc18d \uac00\ub2a5 \uad8c\ud55c \ubd80\uc5ec \uacc4\uc815 \uc0ad\uc81c \ubcc0\uacbd\uc0ac\ud56d [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[12,52],"tags":[96,104,106,108,112],"class_list":["post-243","post","type-post","status-publish","format-standard","hentry","category-data-base-storage","category-mysql","tag-mysql","tag-104","tag-106","tag-108","tag-112"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\uc804\uc81c \uc870\uac74 MySQL Server 5.7.29MySQL \ucf58\uc194 \uc811\uc18d MySQL \uc811\uc18d \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c $ sudo mysql MySQL \ucf58\uc194 \uc811\uc18d \ud6c4 mysql&gt; USE mysql; \uacc4\uc815 \ud655\uc778 mysql&gt; SELECT host, user, authentication_string FROM user; \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uacc4\uc815 \ucd94\uac00 mysql&gt; CREATE USER &#039;\uc0ac\uc6a9\uc790&#039;@&#039;localhost&#039; IDENTIFIED BY\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Bell\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/tech.softbell.net\/?p=243\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"ko_KR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Bell&#039;s Tech Blog - \ubc29\uc6b8\uc758 \uae30\uc220 \ube14\ub85c\uadf8\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815 - Bell&#039;s Tech Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"\uc804\uc81c \uc870\uac74 MySQL Server 5.7.29MySQL \ucf58\uc194 \uc811\uc18d MySQL \uc811\uc18d \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c $ sudo mysql MySQL \ucf58\uc194 \uc811\uc18d \ud6c4 mysql&gt; USE mysql; \uacc4\uc815 \ud655\uc778 mysql&gt; SELECT host, user, authentication_string FROM user; \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uacc4\uc815 \ucd94\uac00 mysql&gt; CREATE USER &#039;\uc0ac\uc6a9\uc790&#039;@&#039;localhost&#039; IDENTIFIED BY\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/tech.softbell.net\/?p=243\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-06-13T13:28:37+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-06-13T13:28:37+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815 - Bell&#039;s Tech Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\uc804\uc81c \uc870\uac74 MySQL Server 5.7.29MySQL \ucf58\uc194 \uc811\uc18d MySQL \uc811\uc18d \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c $ sudo mysql MySQL \ucf58\uc194 \uc811\uc18d \ud6c4 mysql&gt; USE mysql; \uacc4\uc815 \ud655\uc778 mysql&gt; SELECT host, user, authentication_string FROM user; \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uacc4\uc815 \ucd94\uac00 mysql&gt; CREATE USER &#039;\uc0ac\uc6a9\uc790&#039;@&#039;localhost&#039; IDENTIFIED BY\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243#blogposting\",\"name\":\"MySQL \\uc0ac\\uc6a9\\uc790 \\ucd94\\uac00 \\ubc0f \\uad8c\\ud55c \\uc124\\uc815 - Bell's Tech Blog\",\"headline\":\"MySQL \\uc0ac\\uc6a9\\uc790 \\ucd94\\uac00 \\ubc0f \\uad8c\\ud55c \\uc124\\uc815\",\"author\":{\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?author=2#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/#organization\"},\"datePublished\":\"2020-06-13T22:28:37+09:00\",\"dateModified\":\"2020-06-13T22:28:37+09:00\",\"inLanguage\":\"ko-KR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243#webpage\"},\"articleSection\":\"Data Base\\\/Storage, MySQL, MySQL, \\uad8c\\ud55c, \\uc0ac\\uc6a9\\uc790, \\uc124\\uc815, \\ucd94\\uac00\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net#listItem\",\"position\":1,\"name\":\"\\ud648\",\"item\":\"https:\\\/\\\/tech.softbell.net\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?cat=12#listItem\",\"name\":\"Data Base\\\/Storage\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?cat=12#listItem\",\"position\":2,\"name\":\"Data Base\\\/Storage\",\"item\":\"https:\\\/\\\/tech.softbell.net\\\/?cat=12\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?cat=52#listItem\",\"name\":\"MySQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net#listItem\",\"name\":\"\\ud648\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?cat=52#listItem\",\"position\":3,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/tech.softbell.net\\\/?cat=52\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243#listItem\",\"name\":\"MySQL \\uc0ac\\uc6a9\\uc790 \\ucd94\\uac00 \\ubc0f \\uad8c\\ud55c \\uc124\\uc815\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?cat=12#listItem\",\"name\":\"Data Base\\\/Storage\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243#listItem\",\"position\":4,\"name\":\"MySQL \\uc0ac\\uc6a9\\uc790 \\ucd94\\uac00 \\ubc0f \\uad8c\\ud55c \\uc124\\uc815\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?cat=52#listItem\",\"name\":\"MySQL\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/#organization\",\"name\":\"Bell's Tech Blog\",\"description\":\"\\ubc29\\uc6b8\\uc758 \\uae30\\uc220 \\ube14\\ub85c\\uadf8\",\"url\":\"https:\\\/\\\/tech.softbell.net\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?author=2#author\",\"url\":\"https:\\\/\\\/tech.softbell.net\\\/?author=2\",\"name\":\"Bell\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/84215149e6ed0c8ad9f93ccb8c1f9d1ec029a6944b409128e5d594b7b8a51105?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Bell\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243#webpage\",\"url\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243\",\"name\":\"MySQL \\uc0ac\\uc6a9\\uc790 \\ucd94\\uac00 \\ubc0f \\uad8c\\ud55c \\uc124\\uc815 - Bell's Tech Blog\",\"description\":\"\\uc804\\uc81c \\uc870\\uac74 MySQL Server 5.7.29MySQL \\ucf58\\uc194 \\uc811\\uc18d MySQL \\uc811\\uc18d \\ub9ac\\ub205\\uc2a4\\uc5d0 MySQL \\uc11c\\ubc84\\uac00 \\uc788\\uc744 \\ub54c $ sudo mysql MySQL \\ucf58\\uc194 \\uc811\\uc18d \\ud6c4 mysql> USE mysql; \\uacc4\\uc815 \\ud655\\uc778 mysql> SELECT host, user, authentication_string FROM user; \\uacc4\\uc815 \\ud655\\uc778 \\ucffc\\ub9ac\\ubb38\\uc774 MySQL \\ubc84\\uc804\\uc5d0 \\ub530\\ub77c \\uc57d\\uac04 \\ub2e4\\ub974\\ub2e4.\\ud604\\uc7ac \\ubc84\\uc804\\uc5d0\\uc11c\\ub294 \\uc704 \\ucffc\\ub9ac \\uad6c\\ubb38\\uc744 \\uc0ac\\uc6a9\\ud558\\uba74 \\ub41c\\ub2e4. \\uacc4\\uc815 \\ucd94\\uac00 mysql> CREATE USER '\\uc0ac\\uc6a9\\uc790'@'localhost' IDENTIFIED BY\",\"inLanguage\":\"ko-KR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?p=243#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?author=2#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/?author=2#author\"},\"datePublished\":\"2020-06-13T22:28:37+09:00\",\"dateModified\":\"2020-06-13T22:28:37+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/#website\",\"url\":\"https:\\\/\\\/tech.softbell.net\\\/\",\"name\":\"Bell's Tech Blog\",\"description\":\"\\ubc29\\uc6b8\\uc758 \\uae30\\uc220 \\ube14\\ub85c\\uadf8\",\"inLanguage\":\"ko-KR\",\"publisher\":{\"@id\":\"https:\\\/\\\/tech.softbell.net\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815 - Bell's Tech Blog","description":"\uc804\uc81c \uc870\uac74 MySQL Server 5.7.29MySQL \ucf58\uc194 \uc811\uc18d MySQL \uc811\uc18d \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c $ sudo mysql MySQL \ucf58\uc194 \uc811\uc18d \ud6c4 mysql> USE mysql; \uacc4\uc815 \ud655\uc778 mysql> SELECT host, user, authentication_string FROM user; \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uacc4\uc815 \ucd94\uac00 mysql> CREATE USER '\uc0ac\uc6a9\uc790'@'localhost' IDENTIFIED BY","canonical_url":"https:\/\/tech.softbell.net\/?p=243","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/tech.softbell.net\/?p=243#blogposting","name":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815 - Bell's Tech Blog","headline":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815","author":{"@id":"https:\/\/tech.softbell.net\/?author=2#author"},"publisher":{"@id":"https:\/\/tech.softbell.net\/#organization"},"datePublished":"2020-06-13T22:28:37+09:00","dateModified":"2020-06-13T22:28:37+09:00","inLanguage":"ko-KR","mainEntityOfPage":{"@id":"https:\/\/tech.softbell.net\/?p=243#webpage"},"isPartOf":{"@id":"https:\/\/tech.softbell.net\/?p=243#webpage"},"articleSection":"Data Base\/Storage, MySQL, MySQL, \uad8c\ud55c, \uc0ac\uc6a9\uc790, \uc124\uc815, \ucd94\uac00"},{"@type":"BreadcrumbList","@id":"https:\/\/tech.softbell.net\/?p=243#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/tech.softbell.net#listItem","position":1,"name":"\ud648","item":"https:\/\/tech.softbell.net","nextItem":{"@type":"ListItem","@id":"https:\/\/tech.softbell.net\/?cat=12#listItem","name":"Data Base\/Storage"}},{"@type":"ListItem","@id":"https:\/\/tech.softbell.net\/?cat=12#listItem","position":2,"name":"Data Base\/Storage","item":"https:\/\/tech.softbell.net\/?cat=12","nextItem":{"@type":"ListItem","@id":"https:\/\/tech.softbell.net\/?cat=52#listItem","name":"MySQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/tech.softbell.net#listItem","name":"\ud648"}},{"@type":"ListItem","@id":"https:\/\/tech.softbell.net\/?cat=52#listItem","position":3,"name":"MySQL","item":"https:\/\/tech.softbell.net\/?cat=52","nextItem":{"@type":"ListItem","@id":"https:\/\/tech.softbell.net\/?p=243#listItem","name":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815"},"previousItem":{"@type":"ListItem","@id":"https:\/\/tech.softbell.net\/?cat=12#listItem","name":"Data Base\/Storage"}},{"@type":"ListItem","@id":"https:\/\/tech.softbell.net\/?p=243#listItem","position":4,"name":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815","previousItem":{"@type":"ListItem","@id":"https:\/\/tech.softbell.net\/?cat=52#listItem","name":"MySQL"}}]},{"@type":"Organization","@id":"https:\/\/tech.softbell.net\/#organization","name":"Bell's Tech Blog","description":"\ubc29\uc6b8\uc758 \uae30\uc220 \ube14\ub85c\uadf8","url":"https:\/\/tech.softbell.net\/"},{"@type":"Person","@id":"https:\/\/tech.softbell.net\/?author=2#author","url":"https:\/\/tech.softbell.net\/?author=2","name":"Bell","image":{"@type":"ImageObject","@id":"https:\/\/tech.softbell.net\/?p=243#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/84215149e6ed0c8ad9f93ccb8c1f9d1ec029a6944b409128e5d594b7b8a51105?s=96&d=mm&r=g","width":96,"height":96,"caption":"Bell"}},{"@type":"WebPage","@id":"https:\/\/tech.softbell.net\/?p=243#webpage","url":"https:\/\/tech.softbell.net\/?p=243","name":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815 - Bell's Tech Blog","description":"\uc804\uc81c \uc870\uac74 MySQL Server 5.7.29MySQL \ucf58\uc194 \uc811\uc18d MySQL \uc811\uc18d \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c $ sudo mysql MySQL \ucf58\uc194 \uc811\uc18d \ud6c4 mysql> USE mysql; \uacc4\uc815 \ud655\uc778 mysql> SELECT host, user, authentication_string FROM user; \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uacc4\uc815 \ucd94\uac00 mysql> CREATE USER '\uc0ac\uc6a9\uc790'@'localhost' IDENTIFIED BY","inLanguage":"ko-KR","isPartOf":{"@id":"https:\/\/tech.softbell.net\/#website"},"breadcrumb":{"@id":"https:\/\/tech.softbell.net\/?p=243#breadcrumblist"},"author":{"@id":"https:\/\/tech.softbell.net\/?author=2#author"},"creator":{"@id":"https:\/\/tech.softbell.net\/?author=2#author"},"datePublished":"2020-06-13T22:28:37+09:00","dateModified":"2020-06-13T22:28:37+09:00"},{"@type":"WebSite","@id":"https:\/\/tech.softbell.net\/#website","url":"https:\/\/tech.softbell.net\/","name":"Bell's Tech Blog","description":"\ubc29\uc6b8\uc758 \uae30\uc220 \ube14\ub85c\uadf8","inLanguage":"ko-KR","publisher":{"@id":"https:\/\/tech.softbell.net\/#organization"}}]},"og:locale":"ko_KR","og:site_name":"Bell's Tech Blog - \ubc29\uc6b8\uc758 \uae30\uc220 \ube14\ub85c\uadf8","og:type":"article","og:title":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815 - Bell's Tech Blog","og:description":"\uc804\uc81c \uc870\uac74 MySQL Server 5.7.29MySQL \ucf58\uc194 \uc811\uc18d MySQL \uc811\uc18d \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c $ sudo mysql MySQL \ucf58\uc194 \uc811\uc18d \ud6c4 mysql&gt; USE mysql; \uacc4\uc815 \ud655\uc778 mysql&gt; SELECT host, user, authentication_string FROM user; \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uacc4\uc815 \ucd94\uac00 mysql&gt; CREATE USER '\uc0ac\uc6a9\uc790'@'localhost' IDENTIFIED BY","og:url":"https:\/\/tech.softbell.net\/?p=243","article:published_time":"2020-06-13T13:28:37+00:00","article:modified_time":"2020-06-13T13:28:37+00:00","twitter:card":"summary_large_image","twitter:title":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815 - Bell's Tech Blog","twitter:description":"\uc804\uc81c \uc870\uac74 MySQL Server 5.7.29MySQL \ucf58\uc194 \uc811\uc18d MySQL \uc811\uc18d \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c $ sudo mysql MySQL \ucf58\uc194 \uc811\uc18d \ud6c4 mysql&gt; USE mysql; \uacc4\uc815 \ud655\uc778 mysql&gt; SELECT host, user, authentication_string FROM user; \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uacc4\uc815 \ucd94\uac00 mysql&gt; CREATE USER '\uc0ac\uc6a9\uc790'@'localhost' IDENTIFIED BY"},"aioseo_meta_data":{"post_id":"243","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2024-02-06 11:25:24","updated":"2025-06-04 00:19:42","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/tech.softbell.net\" title=\"\ud648\">\ud648<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/tech.softbell.net\/?cat=12\" title=\"Data Base\/Storage\">Data Base\/Storage<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/tech.softbell.net\/?cat=52\" title=\"MySQL\">MySQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"\ud648","link":"https:\/\/tech.softbell.net"},{"label":"Data Base\/Storage","link":"https:\/\/tech.softbell.net\/?cat=12"},{"label":"MySQL","link":"https:\/\/tech.softbell.net\/?cat=52"},{"label":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815","link":"https:\/\/tech.softbell.net\/?p=243"}],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/posts\/243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=243"}],"version-history":[{"count":0,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions"}],"wp:attachment":[{"href":"https:\/\/tech.softbell.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}