MySQL 5.6 ¼öµ¿¼³Ä¡ Çϱâ(ZIP,MySQL Community Server 5.6)
1) MySql ȨÆäÀÌÁö Á¢¼ÓÇϱâ
´ÙÀ½°ú °°Àº ¼ø¼·Î µé¾î¿Í¼ MySQL Community Server ¸µÅ© Ŭ¸¯
2. MySQL Community Server 5.6 ¸µÅ© Ŭ¸¯ ÈÄ ´Ù¿î·Îµå
ÀÚ½ÅÀÇ ÄÄÇ»ÅÍ¿¡ ¸Â´Â ¹öÀüÀÇ zipÆÄÀÏÀ» ´Ù¿î·Îµå ¹Þ¾Æ ÁÝ´Ï´Ù. ´Ù¿î·Îµå ¹öÆ° Ŭ¸¯
3. ¾ÐÃà Ç®±â
4. my-default.ini ¼öÁ¤ ÈÄ ´Ù¸¥ À̸§ my.ini·Î ÀúÀå
¾ÐÃà ¹Ù·Î Ç¬ ÈÄ Æú´õ ¿¸é my.ini ÆÄÀÏÀÌ ¾ø½À´Ï´Ù. my-default.ini ÆÄÀÏ ´õºíŬ¸¯Çؼ ¸Þ¸ðÀåÀ¸·Î ¿¾î ÁÖ¼¼¿ä
ÀÌÁ¦ ¿©±â¿¡ Ãß°¡·Î Àû¾îÁÙ °Ì´Ï´Ù.
[client]
default-character-set =[client]
default-character-set = utf8
[mysqld]
character-set-client-handshake = FALSE
init_connect = "SET collection_connection = utf8_general_ci"
init_connect = "SET NAMES utf8"
character-set-server = utf8
collation-server = utf8_general_ci
Á¶±Ý ³»·Á°¡´Ùº¸¸é [mysqld]¿¡ basedir¿Í datadir, port°¡ #À¸·Î µÇ¾îÀִµ¥
#À» Áö¿ì°í
basedir = ¾ÐÃà Ǭ °æ·Î
datadir = ¾ÐÃà Ǭ ÆÄÀÏ ¾È¿¡ ÀÖ´Â dataÆú´õ °æ·Î
port = 3306
Àú´Â
basedir = C:\mysql-5.6.44-winx64\mysql-5.6.44-winx64
datadir = C:\mysql-5.6.44-winx64\mysql-5.6.44-winx64\data
port=3306
ÀÌ·¸°Ô µË´Ï´Ù.
ÀÌÈÄ ´Ù¸¥ À̸§À¸·Î ÀúÀå
my.ini·Î my-default.ini°¡ ÀÖ´Â Æú´õ¿¡ ÀúÀåÇØ ÁÝ´Ï´Ù.
5. ȯ°æº¯¼ö ¼³Á¤
¾ÐÃà Ǭ °æ·Î¸¦ º¹»çÇØÁÝ´Ï´Ù.
ȯ°æ º¯¼ö¿¡ µé¾î°¡¼ ½Ã½ºÅÛ º¯¼ö¿¡
º¯¼ö À̸§ : MySQL_HOME
º¯¼ö °ª : ¾ÐÃà Ǭ ÆÄÀÏ °æ·Î
½Ã½ºÅÛ º¯¼ö path¿¡
bin µð·ºÅ丮 °æ·Î Ãß°¡ÇØÁÝ´Ï´Ù.
6. °ü¸®ÀÚ ±ÇÇÑÀ¸·Î cmd½ÇÇà -> ÀçºÎÆÃ
mysql ¼ºñ½º µî·Ï ÇÕ´Ï´Ù.
mysqld --install
ÀÔ·Â ÈÄ Àç ºÎÆà ÇÕ´Ï´Ù.
7. mysql ¼ºñ½º ½ÃÀÛ
À̹ø¿¡µµ °ü¸®ÀÚ ±ÇÇÑÀ¸·Î cmd¸¦ ÄѼ
net start mysql
À» ÀÔ·ÂÇÏ¿© ¼ºñ½º¸¦ ½ÃÀÛÇØÁÝ´Ï´Ù.
¼ºñ½º ½ÃÀÛÇß´Ù°í ¶ß°Å³ª À§¿¡ Àú ó·³ ¶¹´Ù¸é ¼ºñ½º ÀÌ¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
8. ºñ¹Ð¹øÈ£ ¼³Á¤Çϱâ
cmd¿¡ mysql -u¾ÆÀ̵ð -p¸¦ ÀÔ·ÂÇÕ´Ï´Ù.
¾ÆÀ̵ð´Â root
ºñ¹Ð¹øÈ£´Â ¾ÆÁ÷ ÁöÁ¤ÇÏÁö ¾Ê¾Ò±â ¶§¹®¿¡
Enter password¶ó´Â ¹®±¸¿¡¼ ±×³É ¿£ÅÍ ´©¸£¸é µË´Ï´Ù.
±× ÈÄ ºñ¹Ð¹øÈ£¸¦ ¼³Á¤ÇÒ °Ì´Ï´Ù.
update user set password = pasword('ÁöÁ¤ÇÒ ºñ¹Ð¹øÈ£') where user = '¾ÆÀ̵ð';
±× ÈÄ flush privileages;ÇØÁÖ½Ã¸é µË´Ï´Ù.