{"id":4036,"date":"2020-12-22T17:26:19","date_gmt":"2020-12-22T08:26:19","guid":{"rendered":"\/blog\/?p=4036"},"modified":"2023-09-21T09:26:36","modified_gmt":"2023-09-21T00:26:36","slug":"mysql-community-server-%ec%84%a4%ec%b9%98-%ec%9c%88%eb%8f%84%ec%9a%b0","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=4036","title":{"rendered":"MySQL Community Server \uc124\uce58 (\uc708\ub3c4\uc6b0)"},"content":{"rendered":"\n\u25a0\ub2e4\uc6b4\ub85c\ub4dc
https:\/\/downloads.mysql.com\/archives\/community\/<\/a>
\uc5d0\uc11c \uc708\ub3c4\uc6b0\uc6a9 64\ube44\ud2b8 5.7.31\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\ub294\ub2e4.

1. my.ini \ud30c\uc77c\uc744 \uc544\ub798\uc640 \uac19\uc774 \uc791\uc131\ud574\uc11c MySQL \ud504\ub85c\uadf8\ub7a8 \ub514\ub809\ud1a0\ub9ac\uc5d0 \ub123\ub294\ub2e4.

my.ini
------------------------------------------------------------------------------

[mysqld]
basedir=\"D:\\mysql\\mysql-5.7.31-winx64\"
datadir=\"D:\/mysql\/db\"
port=3306
binlog_format = MIXED
character-set-client-handshake = FALSE
character-set-server = utf8
collation-server = utf8_general_ci
default_storage_engine=innodb
innodb_buffer_pool_size = 10240M
innodb_file_format = Barracuda
innodb_file_per_table = true
innodb_large_prefix = 1
innodb_lock_wait_timeout = 300
innodb_log_file_size = 512M
max_allowed_packet = 2048M
query_cache_size = 128M
query_cache_type = 1
sql_mode = TRADITIONAL

[client]
port=3306
default-character-set=utf8

[mysql]
default-character-set=utf8

------------------------------------------------------------------------------

2. \ucd08\uae30 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4. (DB \ub514\ub809\ud1a0\ub9ac\ub294 \uc644\uc804\ud788 \ube44\uc6cc\uc838 \uc788\uc5b4\uc57c \ud55c\ub2e4)
mysqld --initialize-insecure --user=mysql


3. \uc708\ub3c4\uc6b0 \uc11c\ube44\uc2a4\ub97c \ub9cc\ub4e0\ub2e4. (services.msc\ub97c \uc2e4\ud589\ud558\uc5ec \ud655\uc778)
mysqld --install

<\/span>\n","protected":false},"excerpt":{"rendered":"

\u25a0\ub2e4\uc6b4\ub85c\ub4dchttps:\/\/downloads.mysql.com\/archives\/community\/\uc5d0\uc11c \uc708\ub3c4\uc6b0\uc6a9 64\ube44\ud2b8 5.7.31\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\ub294\ub2e4. 1. my.ini \ud30c\uc77c\uc744 \uc544\ub798\uc640 \uac19\uc774 \uc791\uc131\ud574\uc11c MySQL \ud504\ub85c\uadf8\ub7a8 \ub514\ub809\ud1a0\ub9ac\uc5d0 \ub123\ub294\ub2e4. my.ini—————————————————————————— [mysqld]basedir=”D:\\mysql\\mysql-5.7.31-winx64″datadir=”D:\/mysql\/db”port=3306binlog_format = MIXEDcharacter-set-client-handshake = FALSEcharacter-set-server = utf8collation-server = utf8_general_cidefault_storage_engine=innodbinnodb_buffer_pool_size = 10240Minnodb_file_format = Barracudainnodb_file_per_table = trueinnodb_large_prefix = 1innodb_lock_wait_timeout = 300innodb_log_file_size = 512Mmax_allowed_packet = 2048Mquery_cache_size = 128Mquery_cache_type = 1sql_mode = TRADITIONAL [client]port=3306default-character-set=utf8 [mysql]default-character-set=utf8 —————————————————————————— 2. \ucd08\uae30 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4. (DB \ub514\ub809\ud1a0\ub9ac\ub294 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-4036","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4036"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4036\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}