[Window10] Mysql 5.7.x ¼³Ä¡ Çϱâ ( Zip archive)
Mysql ¼¹ö¸¦ Window 10¿¡ ¼³Ä¡ Çϱâ À§ÇÑ ¹æ¹ýÀ̸ç, Mysql Community versionÀ» ¼³Ä¡ Çϱâ À§ÇÑ Âü°í¿ëÀÌ´Ù.
¼³Ä¡ ¹æ¹ýÀº msiÆÄÀÏÀ» ÀÌ¿ëÇÑ ¼³Ä¡ ¹æ¹ýÀÌ ¾Æ´Ñ zip archive ÆÄÀÏÀ» ÀÌ¿ëÇÑ ¼³Ä¡ ¹æ¹ýÀ̸ç, ¼³Ä¡ ¹æ¹ýÀº °£´ÜÇÏ´Ù.
¸ÕÀú ¾Æ·¡ Mysql Download page ¿¡ Á¢¼ÓÇÏ¿© ÇØ´ç ¹öÀüÀ» download ÇÑ´Ù.
https://dev.mysql.com/downloads/
=> Mysql Community Server ¼±ÅÃ
¾Æ·¡¿Í °°ÀÌ ´Ù¸¥ ¹öÀüÀ» ¹Þ±â À§ÇØ ÅÇÀ» º¯°æÇÏ°í "Mysql Community Server 5.7 " À» Ŭ¸¯ÇÑ´Ù.
°¢ ½Ã½ºÅÛ¿¡ ¸Â´Â ¹öÀüÀ» ´Ù¿î·Îµå ÇÑ´Ù.
´Ù¿î·Îµå µÈ ¾ÐÃà ÆÄÀÏÀ» È®ÀÎÇÑ´Ù.
¾ÐÃàÀ» ÇØÁ¦ÇÏ°í ÇØ´ç Æú´õ·Î À̵¿ÇÑ´Ù.
ÇØ´ç Æú´õ·Î À̵¿ÇÏ¸é ¾Æ·¡¿Í °°ÀÌ data Æú´õ´Â Á¸ÀçÇÏÁö ¾ÊÀ½À» È®ÀÎÇÑ´Ù.
win + r ¶Ç´Â ½ÇÇàâÀ» ½ÇÇàÇÏ¿© ¸í·ÉÇÁ·ÒÇÁÆ®(cmd)¸¦ °ü¸®ÀÚ ±ÇÇÑÀ¸·Î ½ÇÇàÇÑ´Ù.
¸í·ÉÇÁ·ÒÇÁÆ® â¿¡¼ mysqlÀÌ ¾ÐÃàÇØÁ¦µÈ Æú´õ·Î À̵¿ÇÑ´Ù.
´Ù½Ã Çѹø mysql ¹öÀüÀ» È®ÀÎÇغ»´Ù.(¸í·É¾î È®ÀÎÂ÷¿ø... »ý·«Çصµ µÈ´Ù.)
D:\Mysql\mysql-5.7.27-winx64>.\bin\mysqld --version
.\bin\mysqld Ver 5.7.27 for Win64 on x86_64 (MySQL Community Server (GPL))
Mysql¸¦ ¼ºñ½º¸¦ µî·ÏÇÑ´Ù.
D:\Mysql\mysql-5.7.27-winx64>.\bin\mysqld --install
¸¸¾à ÀÌ¹Ì µî·ÏÀÌ µÇ¾î ÀÖ´Ù°í Ãâ·ÂÀÌ µÈ´Ù¸é ¾Æ·¡ ¸µÅ©¸¦ ÀÌ¿ëÇÏ¿© ÇØ°áÇÑ´Ù.
** "The service already exists!" ¶ó°í Ãâ·ÂÀÌ µÈ´Ù¸é...
2019/10/10 - [¿î¿µÃ¼Á¦/Window] - [Mysql - window] Mysql ¼ºñ½º µî·Ï/»èÁ¦
Mysql¸¦ ÃʱâÈ ÇÑ´Ù.
D:\Mysql\mysql-5.7.27-winx64>.\bin\mysqld --initialize
¾Æ¹«·Ã Ãâ·ÂÀº ¾ø´Ù. ´Ù¸¸, data¶ó´Â Æú´õ°¡ »ý¼ºµÇ¾ú´ÂÁö È®ÀÎÇÑ´Ù.
¶Ç´Â Ž»ö±â â¿¡¼ È®ÀÎÇÑ´Ù.
dataÆú´õ°¡ »ý¼ºÀÌ µÇ¾ú´Ù¸é ÇØ´ç Æú´õ³» hostname.err¶ó´Â ÆÄÀÏÀÌ »ý¼ºµÇ´Âµ¥ ÇØ´ç ÆÄÀϳ»¿¡ DB root Ãʱâ Àӽà Æнº¿öµå°¡ ÀÖÀ¸¹Ç·Î ÇØ´ç ÆÄÀÏÀ» ¸Þ¸ðÀå ¶Ç´Â EditorÇÁ·Î±×·¥À» ÀÌ¿ëÇÏ¿© ÇØ´ç Ãʱâ Æнº¿öµå¸¦ È®ÀÎÇÑ´Ù.
¿©±â¼ hostname.err ¶ó´Â ÆÄÀÏÀÇ À̸§Àº ½ÇÇàÇÏ´Â PC¶Ç´Â ¼¹ö¸¶´Ù Â÷ÀÌ°¡ ÀÖÀ¸´Ï Âü°íÇÑ´Ù.
<¸í·ÉÇÁ·ÒÇÁÆ®¿¡¼ È®ÀÎ>
<Ž»ö±â â¿¡¼ÀÇ È®ÀÎ>
hostname.err¶ó´Â ÆÄÀÏÀ» ¿¾î º¸¸é ¸¶Áö¸· ÁÙ¿¡ "A temporary password is generated for" ºÎºÐÀ» È®ÀÎÇÑ´Ù.
ÇÊÀÚÀÇ °æ¿ì "foiu.sJlH4tj" ÀÓ½ÃÆнº¿öµåÀÌ´Ù.
ÀÌÁ¦ mysql¸¦ ½ÇÇàÇÑ´Ù.
D:\Mysql\mysql-5.7.27-winx64>net start mysql
MySQL ¼ºñ½º¸¦ ½ÃÀÛÇÕ´Ï´Ù..
MySQL ¼ºñ½º°¡ Àß ½ÃÀ۵Ǿú½À´Ï´Ù.
Àӽà Æнº¿öµå·Î Á¤»óÀûÀ¸·Î ·Î±×ÀÎÀÌ µÇ´ÂÁö È®ÀÎÇÑ´Ù.
D:\Mysql\mysql-5.7.27-winx64>.\bin\mysql -uroot -pfoiu.sJlH4tj
¸¸¾à Æнº¿öµå°¡ À߸ø µÇ¾î ÀÖÀ» °æ¿ì ·Î±×ÀÎÀÌ ½ÇÆÐ ³´Ù.
±âº»ÀûÀº Mysql¸¦ ¼³Ä¡ÇÏ¿´´Ù
mysql¸¦ Á¶±Ý´õ ÆíÇÏ°Ô »ç¿ëÇϱâ À§Çؼ´Â ȯ°æº¯¼ö¸¦ ¼³Á¤ÇÑ´Ù.
¸µÅ©~~~~