MySQL 5.6 ¼öµ¿¼³Ä¡ Çϱâ(ZIP,MySQL Community Server 5.6)
1) MySql ȨÆäÀÌÁö Á¢¼ÓÇϱâ
MySQL :: Developer Zone
Supporting all kinds of outer references in derived tables (lateral, or not) (Image credit: Pixabay). In my earlier post, I showed how MySQL, since version 8.0.14, has support for LATERAL derived tables. With LATERAL, a JOIN can have a second table – a sub
dev.mysql.com

´ÙÀ½°ú °°Àº ¼ø¼·Î µé¾î¿Í¼ 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;ÇØÁÖ½Ã¸é µË´Ï´Ù.