º¯°æµÈ MySQL ¼³Ä¡ ¹æ¹ý (5.7 ÀÌ»ó)
¿äÁò ansible ·Î MySQL ÇÁ·ÎºñÀú´× ½ºÅ©¸³Æ®¸¦ Â¥°í ÀÖ½À´Ï´Ù. ±âÁ¸ ÀÛ¼ºµÇ¾î ÀÖ´ø MariaDB ½ºÅ©¸³Æ®¸¦ Âü°íÇØ¼ ÀÛ¼º ÁßÀε¥ MySQL ¿¡¼´Â µ¿ÀÛÇÏÁö ¾Ê´Â ºÎºÐÀÌ Á» ÀÖ¾ú½À´Ï´Ù. ¾Æ¹«·¡µµ µÑÀÌ ºñ½ÁÇÏ´Ù°í´Â ÇØµµ °¢ÀÚ ¹öÀü ¾÷ÀÌ °è¼Ó µÇ¸é¼ Â÷ÀÌÁ¡ÀÌ »ý±ä °Í °°½À´Ï´Ù. À̹ø Æ÷½ºÆÃ¿¡¼´Â Unix/Linux ½Ã½ºÅÛ¿¡ ¹ÙÀ̳ʸ® ÆÄÀÏÀ» ÀÌ¿ëÇØ¼ ¼³Ä¡ÇÒ °æ¿ì, MySQL 5.7 ¹öÀüºÎÅÍ ¹Ù²ï ¼³Ä¡ ¹æ¹ýÀ» »ìÆìº¸°Ú½À´Ï´Ù.
Binary package
MySQL Installation Layout for Generic Unix/Linux Binary Package
- bin : mysqld server, Ŭ¶óÀ̾ðÆ®, À¯Æ¿¸®Æ¼ ÇÁ·Î±×·¥ µî
- docs : MySQL ¸Þ´º¾ó
- include : Include (header) ÆÄÀÏ
- lib : ¶óÀ̺귯¸®
- man : Unix ¸Þ´º¾ó ÆäÀÌÁö
- share : ¿¡·¯¸Þ½ÃÁö, µñ¼Å³Ê¸®, database ¼³Ä¡ SQL
- support-files : ±âŸ ÆÄÀÏ
MySQL 5.6 ÀÌÇÏ
MySQL 5.6 ÀÌÇϳª MariaDB °°Àº °æ¿ì mysql_install_db
¶ó´Â ½ºÅ©¸³Æ®¸¦ ÀÌ¿ëÇØ¼ ¼³Ä¡Çß½À´Ï´Ù.
1 | $ scripts/mysql_install_db --user=mysql |
MySQL 5.7 ÀÌ»ó
ÇÏÁö¸¸ mysql_isntall_db
°¡ deprecated µÇ¸é¼ »ç¿ë ½Ã ¿¡·¯°¡ ¹ß»ýÇÕ´Ï´Ù.
MySQL 5.7.6 deprecates the mysql_install_db command and introduces a mysqld --initialize command as a replacement.[1]
´ë½Å mysqld ÀÇ --initialize
¶ó´Â Ä¿¸Çµå¸¦ ÀÌ¿ëÇØ¼ ÃʱâÈ ¹× ¼³Ä¡¸¦ ÇØ¾ßÇÕ´Ï´Ù.
1 | $ bin/mysqld --initialize --user=mysql |
–initialize
À§ ¹æ¹ýÀ¸·Î ¼³Ä¡ÇÒ °æ¿ì, Àӽà ºñ¹Ð¹øÈ£°¡ ¹ß±ÞµË´Ï´Ù. À̸¦ ÀÌ¿ëÇØ¼ óÀ½ Á¢¼ÓÀÌ °¡´ÉÇϰí, Á¢¼Ó ÈÄ¿¡ ·çÆ® ºñ¹Ð¹øÈ£¸¦ º¯°æÇÏ¸é µË´Ï´Ù.
1 | 2018-04-26T07:11:50.371426Z 1 [Note] A temporary password is generated for root@localhost: IL0E:rfYAtwy |
1 | $ /MySQL/mysql-5.7.21/bin/mysql -uroot -pIL0E:rfYAtwy |
–initialize-insecure
±×·±µ¥ ¼³Ä¡ ½ºÅ©¸³Æ®¿¡¼´Â ÀÌ·± ÀÛ¾÷ÀÌ ½±Áö°¡ ¾Ê½À´Ï´Ù. ÀÌ·² ¶© Àӽà ºñ¹Ð¹øÈ£ ¾øÀÌ Á¢¼ÓÇÒ ¼ö ÀÖµµ·Ï ¼³Ä¡ÇÏ´Â ¹æ¹ýÀÌ ÀÖ½À´Ï´Ù.
1 | $ bin/mysqld --initialize-insecure --user=mysql |
Á¢¼Ó ÈÄ ÆÐ½º¿öµå º¯°æ
Àӽà ºñ¹Ð¹øÈ£ ¿©ºÎ¿Í »ó°ü¾øÀÌ ¸ðµÎ Á¢¼Ó ÈÄ¿¡´Â ÆÐ½º¿öµå¸¦ º¯°æÇØ¾ß ÇÕ´Ï´Ù.
1 | mysql> alter user ¡®root¡¯@¡¯localhost¡¯ identified by 'newpassword'; |
¼³Ä¡ °á°ú È®ÀÎ
mysql status
1 | $ /etc/init.d/mysqld status |
ÇÁ·Î¼¼½º È®ÀÎ
1 | $ ps -ef | grep mysql |
¼¹ö Á¢¼Ó ÈÄ DB ¹× À¯Àú È®ÀÎ
1 | mysql> show databases; |
1 | mysql> select user from mysql.user; |
À̹ø Æ÷½ºÆÃ¿¡¼´Â ¹ÙÀ̳ʸ® ÆÄÀÏÀ» ÀÌ¿ëÇÑ 5.7 ¹öÀü ÀÌ»ó MySQL ¼³Ä¡ ¹æ¹ýÀ» »ìÆìºÃ½À´Ï´Ù.
Âü°í
- Installing MySQL on Unix/Linux Using Generic Binaries
- Server Command Options --initialize
- Server Command Options --initialize-insecure