MySQL Community Server ZIP Archive ¼³Ä¡¹æ¹ý
º» °Ô½Ã±ÛÀº À©µµ¿ì10 Home¹öÀüÀ¸·Î ÀÛ¼ºÇÔ.
À©µµ¿ì 7 ¿î¿µÃ¼Á¦ ÀÌ¿ë ½Ã È¯°æº¯¼öÀÛ¾÷¿¡¼ ÀÎÅÍÆäÀ̽º»óÀÇ Â÷ÀÌ°¡ ÀÖÀ» ¼ö ÀÖÀ½.
2017³â 1¿ù 3ÀϱâÁØÀ¸·Î ÇöÀç±îÁö MySQL 5.7¹öÀüºÎÅÍ´Â 64ºñÆ® ¿î¿µÃ¼Á¦¿¡ ´ëÇÑ msi ÀνºÅç·¯°¡ Á¦°øµÇÁö¾ÊÀ½.
±×·¯¹Ç·Î ZIP Archive¹æ½ÄÀ¸·Î ¼³Ä¡¸¦ ÇؾßÇϴµ¥ ¼³Ä¡ ¹æ¹ýÀÌ ±î´Ù·Î¿ò. (°¡±ÞÀû »çÁø¾øÀÌ Æ÷½ºÆà ÁøÇà)
1. MySQL ZIP Archive ¼³Ä¡ÆÄÀÏ ´Ù¿î·Îµå
http://dev.mysql.com/downloads/mysql/ // Windows (x86, 64-bit), ZIP Archive Ç׸ñÀ» ´Ù¿î·Îµå
(ÇÊÀÚÀÇ °æ¿ì ZIP ÆÄÀÏÀÇ À̸§Àº mysql-5.7.17-winx64)
2. ¾ÐÃà ÇØÁ¦ ÈÄ ³ª¿Â Æú´õ¸¦ ÀÓÀÇÀÇ °ø°£¿¡ ¹èÄ¡ (°¡±ÞÀû »¡¸® Á¢±ÙÇÒ ¼ö ÀÖ´Â °÷)
Ex) C:\mysql-5.7.17-winx64 //Æú´õ À̸§À» mysql µîÀ¸·Î °£·«È ÇÏ¿© º¯°æÇÏ¿©µµ ¹«°üÇÔ. ¡æ C:\mysql
(ÇÊÀÚ´Â Eµå¶óÀ̺꿡 mysqlÆú´õ¸¦ ¹èÄ¡Çß´Ù.)
3. mysql Æú´õ ³»ÀÇ my-default.ini ÆÄÀÏ ¼öÁ¤ ÈÄ ´Ù¸¥À̸§À¸·Î ÀúÀåÀ» ÀÌ¿ëÇÏ¿© my.ini·Î ÀúÀå
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
# basedir = [ÇöÀç mysqlÆú´õÀÇ À§Ä¡]
# datadir = [ÇöÀç mysqlÆú´õÀÇ À§Ä¡\data]
# port = 3306
Ex) ÇÊÀÚÀÇ °æ¿ì ¾Æ·¡¿Í °°ÀÌ ¼³Á¤ÇÔ.
# basedir = E:\mysql
# datadir = E:\mysql\data
# port = 3306
4. ȯ°æº¯¼ö ¼³Á¤
Á¦¾îÆÇ - ½Ã½ºÅÛ ¹× º¸¾È - ½Ã½ºÅÛ - °í±Þ ½Ã½ºÅÛ ¼³Á¤ - °í±Þ - ȯ°æ º¯¼ö(N) - ½Ã½ºÅÛ º¯¼ö(S) - Path
[À©µµ¿ì 7]
1. Path¸¦ ´õºí Ŭ¸¯ ÇÑ´Ù.
2. º¯¼ö °ª(V): ÀÇ ³»¿ë ³¡¿¡ ;[ÇöÀç mysqlÆú´õÀÇ À§Ä¡\bin] À» ÀÔ·Â ÈÄ È®ÀÎ\
Ex) ...blahblah\blah;E:\mysql\bin
[À©µµ¿ì 10]
1. Path¸¦ ´õºí Ŭ¸¯ ÇÑ´Ù.
2. »õ·Î ¸¸µé±â(N) À» Ŭ¸¯ÇÑ´Ù.
3. ¼±ÅÃµÈ ÅؽºÆ® »óÀÚ¿¡ [ÇöÀç mysqlÆú´õÀÇ À§Ä¡\bin] ¸¦ ÀÔ·Â ÈÄ ¿£ÅÍ È®ÀÎ
Ex) E:\mysql\bin
5. cmd(¸í·É ÇÁ·ÒÇÁÆ®)¸¦ °ü¸®ÀÚ ±ÇÇÑÀ¸·Î ½ÇÇà ÈÄ ¸í·É¾î ÀÔ·Â
1) mysqld.exe --initialize
2) mysqld.exe --install
3) mysqld --console --explicit_defaults_for_timestamp --skip-grant-tables
4) 3)ÀÇ ¸í·É¾î ÀÔ·Â ½Ã ¿¢¼¼½º¸¦ ½ÂÀÎÇÏ°Ù³Ä°í ¹¯´Âµ¥, Çã¿ëÇØÁÖÀÚ. ÀÌ ¶§ cmdâÀ» ²ôÁö¸»°í °¡¸¸È÷ ³ÀµÎÀÚ.
¿©±â±îÁö°¡ ZIP Archive ¼³Ä¡¹æ¹ýÀÇ ³¡ÀÌ´Ù. Ãß°¡·Î mysql Á¢¼Ó ¹× root°èÁ¤ÀÇ ºñ¹Ð¹øÈ£ ¼³Á¤ÇÏ°ÚÀ½.
6. »õ·Î¿î cmd(¸í·É ÇÁ·ÒÇÁÆ®)âÀ» ¿¾î¼ ¸í·É¾î ÀÔ·Â
1) mysql -u root mysql ¸¦ ÀÔ·ÂÇÑ´Ù. ³¡¿¡ mysql> ÇÏ´Â ³à¼®ÀÌ º¸Àδٸé mysql Á¢¼Ó ¼º°ø
2) update user set authentication_string = password('»õ ºñ¹Ð¹øÈ£') where user = 'root';
ex) update user set authentication_string = password('1234') where user = 'root';
3) flush privileges; // º¯°æ»çÇ× Àû¿ëÀÇ ¿ªÇÒÀ» ÇÏ´Â ¸í·É¾î
4) alter user 'root'@'localhost' identified by '¼³Á¤ÇÞ´ø ºñ¹Ð¹øÈ£';
5) \q ÀÔ·Â ÈÄ (·Î±×¾Æ¿ôÀÓ) ´Ù½Ã mysql -uroot -pºñ¹Ð¹øÈ£ ·Î Á¢¼ÓÇغ¸¸é Àß Á¢¼ÓµÇ´Â °ÍÀ» ¾Ë ¼ö ÀÖÀ½
ÇϳªÇϳª°¡ Àý´ë ½Ç¼öÇؼ±¾ÈµÇ´Â °úÁ¤ÀÌ´Ù. ÀÚÄ©ÇÏ¸é ±«»óÇÑ ¿À·ù·Î À̾îÁö´Âµ¥ »¡¸® msi¼³Ä¡ÆÄÀÏÀ» ¹èÆ÷ÇßÀ¸¸éÇÑ´Ù.
³Ê¹« ¼³Ä¡°úÁ¤ÀÌ ±î´Ù·Ó´Ù..