인프라코디: MySQL

MySQL

Sorry, this site doesn't work properly without JavaScript.

MySQL에서 배열 데이터를 다루는 방법

인프라코디

2023년 08월 16일 2025년 07월 08일

배열이란 무엇인가? 배열이란 같은 종류의 여러 개의 데이터를 하나의 변수에 저장할 수 있는 자료구조입니다. 예를 들어, 사과, 바나나, 오렌지 등과 같은 과일들을 fruits라는 변수...

더 읽어보기 » 댓글 쓰기

Rocky Linux 9에 MySQL 5.7 설치 방법

인프라코디

2023년 08월 16일 2025년 07월 08일

Rocky Linux는 CentOS의 후속 버전으로, 커뮤니티 기반의 엔터프라이즈 리눅스 배포판입니다. Rocky Linux는 안정성과 호환성을 중시하며, 다양한 서버 환경에서 사용할 ...

더 읽어보기 » 댓글 쓰기

CentOS 7에서 MySQL 5.7 설치 시 RPM GPG 키 오류를 해결하는 방법

인프라코디

2022년 12월 07일 2025년 07월 08일

MySQL은 오픈 소스 관계형 데이터베이스 관리 시스템으로, 많은 사람들이 사용하고 있습니다. CentOS 7에서 MySQL을 설치하려면, 공식 저장소나 MySQL 저장소 중 하나를 선...

더 읽어보기 » 댓글 쓰기

MySQL/MariaDB root 비밀번호 초기화 방법

인프라코디

2022년 06월 19일 2025년 07월 08일

[root@infracody ~]# mysqld_safe -bash: mysqld_safe: command not found MySQL 또는 MairaDB에서 root 계정의 비밀...

더 읽어보기 » 댓글 쓰기

MySQL Shell Script 비밀번호 노출 경고 해결하기 (Warning :Using a password on the command line interface can be insecure)

인프라코디

2022년 06월 07일 2025년 07월 08일

리눅스에서 bash shell script나 cron 작업으로 MySQL 작업 시 비밀번호를 자동으로 입력하도록 -p, --password 옵션으로 자동 로그인을 사용하고 있었으나, ...

더 읽어보기 » 댓글 쓰기


<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/552934507-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY4Ad1_ISvbWqzKKnXuodblyrx74xQ:1757923699690';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d1438752199397536901','//www.infracody.com/search/label/MySQL','1438752199397536901');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '1438752199397536901', 'title': '\uc778\ud504\ub77c\ucf54\ub514', 'url': 'https://www.infracody.com/search/label/MySQL', 'canonicalUrl': 'https://www.infracody.com/search/label/MySQL', 'homepageUrl': 'https://www.infracody.com/', 'searchUrl': 'https://www.infracody.com/search', 'canonicalHomepageUrl': 'https://www.infracody.com/', 'blogspotFaviconUrl': 'https://www.infracody.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'G-PKMR5K5CDP', 'analytics4': true, 'encoding': 'UTF-8', 'locale': 'ko', 'localeUnderscoreDelimited': 'ko', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\uc778\ud504\ub77c\ucf54\ub514 - Atom\x22 href\x3d\x22https://www.infracody.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22\uc778\ud504\ub77c\ucf54\ub514 - RSS\x22 href\x3d\x22https://www.infracody.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\uc778\ud504\ub77c\ucf54\ub514 - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/1438752199397536901/posts/default\x22 /\x3e\n', 'meTag': '\x3clink rel\x3d\x22me\x22 href\x3d\x22https://www.blogger.com/profile/15053650230296239174\x22 /\x3e\n', 'adsenseClientId': 'ca-pub-2724591303128751', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/04ff204f4c551a27', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': '\uacf5\uc720 \ub9c1\ud06c \ub9cc\ub4e4\uae30', 'key': 'link', 'shareMessage': '\uacf5\uc720 \ub9c1\ud06c \ub9cc\ub4e4\uae30', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Facebook\uc5d0 \uacf5\uc720', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'X\uc5d0 \uacf5\uc720', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Pinterest\uc5d0 \uacf5\uc720', 'target': 'pinterest'}, {'name': '\uc774\uba54\uc77c', 'key': 'email', 'shareMessage': '\uc774\uba54\uc77c', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27ko\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': '\ub354 \uc77d\uc5b4\ubcf4\uae30 \xbb', 'pageType': 'index', 'searchLabel': 'MySQL', 'pageName': 'MySQL', 'pageTitle': '\uc778\ud504\ub77c\ucf54\ub514: MySQL', 'metaDescription': '\uc708\ub3c4\uc6b0\uc640 \ub9ac\ub205\uc2a4 \uc11c\ubc84 \uad00\ub9ac, \uac00\uc0c1\ud654, \uc815\ubcf4 \ubcf4\uc548, \ub124\ud2b8\uc6cc\ud06c, \ub370\ube0c\uc635\uc2a4, IT \uc790\ub3d9\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1 \uc815\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': '\uc218\uc815', 'linkCopiedToClipboard': '\ub9c1\ud06c\ub97c \ud074\ub9bd\ubcf4\ub4dc\uc5d0 \ubcf5\uc0ac\ud588\uc2b5\ub2c8\ub2e4.', 'ok': '\ud655\uc778', 'postLink': '\uae00 \ub9c1\ud06c'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': '\uc0ac\uc6a9\uc790 \uc9c0\uc815', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\uc778\ud504\ub77c\ucf54\ub514', 'description': '\uc708\ub3c4\uc6b0\uc640 \ub9ac\ub205\uc2a4 \uc11c\ubc84 \uad00\ub9ac, \uac00\uc0c1\ud654, \uc815\ubcf4 \ubcf4\uc548, \ub124\ud2b8\uc6cc\ud06c, \ub370\ube0c\uc635\uc2a4, IT \uc790\ub3d9\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1 \uc815\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.', 'url': 'https://www.infracody.com/search/label/MySQL', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': 'MySQL', 'resultsMessage': '\ub77c\ubca8\uc774 MySQL\uc778 \uac8c\uc2dc\ubb3c \ud45c\uc2dc', 'resultsMessageHtml': '\ub77c\ubca8\uc774 \x3cspan class\x3d\x27search-label\x27\x3eMySQL\x3c/span\x3e\uc778 \uac8c\uc2dc\ubb3c \ud45c\uc2dc'}}}, {'name': 'widgets', 'data': [{'title': 'JavaScript Variables', 'type': 'LinkList', 'sectionId': 'elcreative_panel_top', 'id': 'LinkList995'}, {'title': 'CSS Options', 'type': 'LinkList', 'sectionId': 'elcreative_panel_top', 'id': 'LinkList996'}, {'title': 'Custom SVG Icons', 'type': 'LinkList', 'sectionId': 'elcreative_panel_top', 'id': 'LinkList998'}, {'title': 'Custom SVG Pack (SVG Sprites)', 'type': 'HTML', 'sectionId': 'elcreative_panel_top', 'id': 'HTML994'}, {'title': '\uc778\ud504\ub77c\ucf54\ub514(\ud5e4\ub354)', 'type': 'Header', 'sectionId': 'section_app_bar', 'id': 'Header1'}, {'title': 'Navigation Drawer Menu', 'type': 'LinkList', 'sectionId': 'section_navigation', 'id': 'LinkList999'}, {'title': 'More Menu', 'type': 'PageList', 'sectionId': 'section_navigation', 'id': 'PageList999'}, {'title': '\ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c', 'type': 'Blog', 'sectionId': 'section_main_widget', 'id': 'Blog1', 'posts': [{'id': '5597370656824262095', 'title': 'MySQL\uc5d0\uc11c \ubc30\uc5f4 \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub294 \ubc29\ubc95', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhIe1d48OO25xFYVT1KMf2e2pw6ufi0hKQuJeTHW4l-vdyRWtMn69ZRc1oUOzsxjK6vSoy2k9FK8IxgBcq7m1S86_S6Y7zRWPoZIGM3cbw72NHdl8xDaOzpC1UcvulvwA_rrUX30aQ6rY4bo0P71wfeVS4poDRA3IExBdrHwMCfNYtvgW_4GIwzFEfcK2y/w300-h250-c-rw/mysql_database.webp', 'showInlineAds': false}, {'id': '3105423452446124975', 'title': 'Rocky Linux 9\uc5d0 MySQL 5.7 \uc124\uce58 \ubc29\ubc95', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhIe1d48OO25xFYVT1KMf2e2pw6ufi0hKQuJeTHW4l-vdyRWtMn69ZRc1oUOzsxjK6vSoy2k9FK8IxgBcq7m1S86_S6Y7zRWPoZIGM3cbw72NHdl8xDaOzpC1UcvulvwA_rrUX30aQ6rY4bo0P71wfeVS4poDRA3IExBdrHwMCfNYtvgW_4GIwzFEfcK2y/w300-h250-c-rw/mysql_database.webp', 'showInlineAds': false}, {'id': '7347973447767210088', 'title': 'CentOS 7\uc5d0\uc11c MySQL 5.7 \uc124\uce58 \uc2dc RPM GPG \ud0a4 \uc624\ub958\ub97c \ud574\uacb0\ud558\ub294 \ubc29\ubc95', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPRDXDXY_V_-feVtp4MRcddojWvqRgSgt1sZi6kLegriSMssBDfX8A7jIfiul43iw6wEXSHXjZrRRVBVv_NwR4y65cZ8EPdhVzBMgt2Kb5wYlwLoH0y4vthcBPQHx2I4U0ooFJW5t1Tanhg8njgEq8sK7gLTB7rVNrkMMRw8b6btU6K3CflopqKyzgjCxi/w300-h250-c-rw/database.webp', 'showInlineAds': false}, {'id': '8965482996281167494', 'title': 'MySQL/MariaDB root \ube44\ubc00\ubc88\ud638 \ucd08\uae30\ud654 \ubc29\ubc95', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgM7nZ9cTQuw5jPSjBhQMbezStqIVBDQ4lNXU4tzlfUDY8Jje7R7W7T6q8KrLag21mXBwlZT5venHFCO2mSJ7_6ULoyfU0l4rrgqGUA1bfzGy0wFT4bVmaCoK63ThZytGtiX7eXl0EY84sibeZ7v4Q0vITREK2XOw8DytCzLASPfHLtat4Nw1dcW9tKnWSK/w300-h250-c-rw/mysql_database.webp', 'showInlineAds': false}, {'id': '3469789440140479609', 'title': 'MySQL Shell Script \ube44\ubc00\ubc88\ud638 \ub178\ucd9c \uacbd\uace0 \ud574\uacb0\ud558\uae30 (Warning :Using a password on the command line interface can be insecure)', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHYn-OtMeGGqoxeojNjmlSzYl9ujRXaXn26XOcntrgSk2HQ0iQoHWWUoM1npyPt_mdq4AUbFfAzwkMbCehU4Tqr7I_ZnuNZut9mkgkjVhWSmQQCipeR5F78FZ4agjvLmcpYwg8OMBlfIYanhu9VhSRTnP7gmQiHpdA-vOaF0pzzkHzSLKosRGaoI7xSXXW/w300-h250-c-rw/mysql_database.webp', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': ''}, {'name': 'timestamp', 'label': ''}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Comment'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Labels'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': ''}, {'name': 'timestamp', 'label': ''}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': 'Labels'}]}, {'title': 'Between Post Ad Slot', 'type': 'HTML', 'sectionId': 'section_main_widget', 'id': 'HTML995'}, {'title': 'Post Ad Slot (Bottom)', 'type': 'HTML', 'sectionId': 'section_main_widget', 'id': 'HTML997'}, {'title': 'elcreativeSocial', 'type': 'LinkList', 'sectionId': 'section_aside_widget', 'id': 'LinkList1'}, {'title': 'Translate', 'type': 'Translate', 'sectionId': 'section_aside_widget', 'id': 'Translate1'}, {'title': '', 'type': 'HTML', 'sectionId': 'section_aside_widget', 'id': 'HTML2'}, {'title': '\uad6c\ub3c5\ud558\uae30', 'type': 'Subscribe', 'sectionId': 'section_aside_widget', 'id': 'Subscribe1'}, {'title': '', 'type': 'HTML', 'sectionId': 'section_aside_widget', 'id': 'HTML1'}, {'title': 'Custom Vanilla JavaScript', 'type': 'HTML', 'sectionId': 'elcreative_panel_bottom', 'id': 'HTML998'}, {'title': 'Custom jQuery Script', 'type': 'HTML', 'sectionId': 'elcreative_panel_bottom', 'id': 'HTML999'}, {'title': '\ubb38\uc758\ud558\uae30 \uc591\uc2dd', 'type': 'ContactForm', 'sectionId': 'hidden', 'id': 'ContactForm1'}]}]);
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList995', 'elcreative_panel_top', document.getElementById('LinkList995'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList996', 'elcreative_panel_top', document.getElementById('LinkList996'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList998', 'elcreative_panel_top', document.getElementById('LinkList998'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML994', 'elcreative_panel_top', document.getElementById('HTML994'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'section_app_bar', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList999', 'section_navigation', document.getElementById('LinkList999'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList999', 'section_navigation', document.getElementById('PageList999'), {'title': 'More Menu', 'links': [{'isCurrentPage': false, 'href': 'http://www.infracody.com/', 'title': 'Home'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'section_main_widget', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'navMessage': '\ub808\uc774\ube14\uc774 \x3cb\x3eMySQL\x3c/b\x3e\uc778 \uac8c\uc2dc\ubb3c\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4. \x3ca href\x3d\x22https://www.infracody.com/\x22\x3e\ubaa8\ub4e0 \uac8c\uc2dc\ubb3c \ud45c\uc2dc\x3c/a\x3e', 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1516774855-lbx__ko.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/828616780-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML995', 'section_main_widget', document.getElementById('HTML995'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML997', 'section_main_widget', document.getElementById('HTML997'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList1', 'section_aside_widget', document.getElementById('LinkList1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_TranslateView', new _WidgetInfo('Translate1', 'section_aside_widget', document.getElementById('Translate1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML2', 'section_aside_widget', document.getElementById('HTML2'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_SubscribeView', new _WidgetInfo('Subscribe1', 'section_aside_widget', document.getElementById('Subscribe1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'section_aside_widget', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML998', 'elcreative_panel_bottom', document.getElementById('HTML998'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML999', 'elcreative_panel_bottom', document.getElementById('HTML999'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm1', 'hidden', document.getElementById('ContactForm1'), {'contactFormMessageSendingMsg': '\uc804\uc1a1 \uc911...', 'contactFormMessageSentMsg': '\uba54\uc77c\uc774 \uc804\uc1a1\ub418\uc5c8\uc2b5\ub2c8\ub2e4.', 'contactFormMessageNotSentMsg': '\uba54\uc77c\uc744 \uc804\uc1a1\ud558\uc9c0 \ubabb\ud588\uc2b5\ub2c8\ub2e4. \uc7a0\uc2dc \ud6c4 \ub2e4\uc2dc \uc2dc\ub3c4\ud574 \uc8fc\uc138\uc694.', 'contactFormInvalidEmailMsg': '\uc62c\ubc14\ub978 \uc774\uba54\uc77c \uc8fc\uc18c\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.', 'contactFormEmptyMessageMsg': '\uba54\uc2dc\uc9c0 \uc785\ub825\ub780\uc740 \ubc18\ub4dc\uc2dc \uc785\ub825\ud574\uc57c \ud569\ub2c8\ub2e4.', 'title': '\ubb38\uc758\ud558\uae30 \uc591\uc2dd', 'blogId': '1438752199397536901', 'contactFormNameMsg': '\uc774\ub984', 'contactFormEmailMsg': '\uc774\uba54\uc77c', 'contactFormMessageMsg': '\uba54\uc2dc\uc9c0', 'contactFormSendMsg': '\ubcf4\ub0b4\uae30', 'contactFormToken': 'AOuZoY7u6XMZM3ZWQ-m-60JwUp5oDujCgQ:1757923699691', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull'));
</script>
</body>