MySQL ¹«¼³Ä¡ ¹öÀü ¼³Ä¡Çϱâ - Window
MySQL ¼³Ä¡ ¹× »ç¿ë : ¾ÐÃàÆÄÀϺ» ºñsetup ÆÇ
MySQL 5.5.59 -version ±âÁØ ¼³Ä¡
MySQL 5.7.10 -version Æ÷½ºÆà ÈĹݺο¡ ¼³¸í
¼³Ä¡Çϴµ¥ ¿¡·¯/¿À·ù½Ã ÇØ°á¹ý - Æ÷½ºÆà ÈĹݺο¡ ¼³¸í
1. ´Ù¿î·Îµå
http://dev.mysql.com/downloads/mysql/
¼¹ö ÇÁ·Î±×·¥ ´Ù¿î·Îµå
*** ÃֽŹöÀü¿¡´Â my-*.ini ÆÄÀÏÀÌ ¾ø¾î ±¸¹öÀüÀ» ´Ù¿î·Îµå ***
1) MySQL Community Edition (GPL)
Community (GPL) Downloads » ¸µÅ© Ŭ¸¯
2) MySQL Community Server
DOWNLOAD Ŭ¸¯
3) mysql-5.5.59-winx64.zip
Download Ŭ¸¯
(mysql-5.5.59-winx64.zip)
·Î±×ÀÎ ¾øÀÌ No Thanks click
´Ù¿î·Îµå : mysql-5.5.59-winx64.zip ¾ÐÃàÇ®±â
c:\mysql Æú´õ·Î À̵¿
µå¶óÀ̹ö ´Ù¿î·Îµå
https://dev.mysql.com/downloads/connector/
MySql Connectors
Connector/J Ŭ¸¯
Platform Independent (Architecture Independent), ZIP Archive 5.1.45 3.6M
Download Ŭ¸¯
2. ¾ÐÃàÇ®±â - ¼³Ä¡
MySQL Community Server ¾ÐÃàÇ®±â °æ·Î
C:\mysql
MySQL Connectors/J ¾ÐÃàÇ®±â -> mysql-connector-java-5.1.45-bin.jar ÆÄÀÏ º¹»ç/ºÙ¿©³Ö±â
C:\Program Files\Java\jdk1.8.0_151\jre\lib\ext
C:\Program Files\Java\jre1.8.0_151\lib\ext
3. ȯ°æº¯¼ö ¼³Á¤
½Ã½ºÅÛ -> °í±Þ ½Ã½ºÅÛ ¼³Á¤ -> ½Ã½ºÅÛ ¼Ó¼ºÀÇ °í±Þ ÅÇ -> ȯ°æº¯¼ö
»õ ½Ã½ºÅÛ º¯¼ö·Î ¸¸µé´ø°¡
OR
±âÁ¸ Path º¯¼öÆíÁý ´©¸£°í
; ÀÔ·ÂÈÄ ºÙ¿©³Ö´Â´Ù.
4. ini ÆÄÀÏ ¼³Á¤
C:\mysql Æú´õ¿¡¼
my-medium.ini ÆÄÀÏÀ» º¹Á¦Çؼ
my.ini ÆÄÀϸíÀ¸·Î º¯°æ
[mysqldum p]
default-character-set = utf8
[client]
default-character-set = utf8
[mysql]
default-character-set = utf8
[mysqld]
character-set-server = utf8
collation-server = utf8_general_ci
init_connect = set collation_connection = utf8_general_ci
init_connect = set names utf8
character-set-client-handshake = FALSE
skip-character-set-client-handshake
basedir = c:/mysql
datadir = c:/mysql/data
port = 3306
my.ini ÆÄÀÏ¿¡ Ãß°¡ÇÑ ÄÚµåµé
basedir : MySQLÀÌ ¼³Ä¡µÈ °æ·Î
datadir : DB µ¥ÀÌÅÍ°¡ ÀúÀåµÉ °æ·Î
port : ÀϹÝÀûÀ¸·Î 3306À» »ç¿ë
MySQL 5.7.10 -version¿¡¼ my.ini ÆÄÀÏ ¼³Á¤
5. °ü¸®ÀÚ ¸ðµå cmdâ ½ÇÇà
C:\ Command Prompt |
Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\KH>cd c:\ C:\>cd mysql C:\mysql>cd bin C:\mysql\bin>mysqld --initialize-insecure C:\mysql\bin>mysqld --install Service successfully installed. |
mysqld
[¿É¼Ç] --initialize : ¼³Á¤ ÆÄÀÏ(my.ini) ¿É¼Ç´ë·Î ÃʱâÈ ÀÛ¾÷
[¿É¼Ç] -insecure : ÃÖÃÊ root Á¢¼Ó½Ã ºñ¹Ð¹øÈ£¸¦ ÀԷ¾ÈÇÏ°í Á¢¼ÓÇÒ ±ÇÇÑ ºÎ¿© - ¾ÏÈ£¾øÀÌ root·Î ·Î±×ÀÎ Çϵµ·Ï ÇÏ´Â ¿É¼Ç
- ¾ÏÈ£¾øÀÌ root ·Î ·Î±×ÀÎÇϵµ·Ï ÁöÁ¤
°ü¸®ÀÚ cmd> net stop mysql À» ½ÇÇàÇÑ ÈÄ (¼¹ö Á¾·á)
»õ °ü¸®ÀÚ cmd> mysqld --skip-grant-tables
ÀÔ·ÂÇϸé, ÇØ´ç ¸í·É ÇÁ·ÒÇÁÆ®´Â ¼ºñ½º¸¦ ½ÇÇàÇÏ´À¶ó »ç¿ëÇÒ ¼ö ¾ø´Ù.
¿ø cmdâ¿¡¼ mysql -uroot -p
·Î±×ÀεȴÙ
mysqld --install : mysql ¼ºñ½º ¼³Ä¡
C:\ Command Prompt |
C:\mysql\bin>net start mysql MySQL ¼ºñ½º¸¦ ½ÃÀÛÇÕ´Ï´Ù.. MySQL ¼ºñ½º°¡ Àß ½ÃÀ۵Ǿú½À´Ï´Ù. C:\mysql\bin>mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.10 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> |
net start mysql : MySQL ¼ºñ½º ½ÃÀÛ
net stop mysql : MySQL ¼ºñ½º Á¤Áö
mysql -uroot -p : MySQL Á¢¼Ó
6. ¿À·ù/¿¡·¯½Ã MySQL ¿ÏÀü»èÁ¦
C:\ Command Prompt |
C:\>sc delete mysql |
sc delete mysql : sc »èÁ¦ ¸í·É¾î
[window] + [R] ´ÜÃàÅ° ½ÇÇà -> regedit
·¹Áö½ºÆ®¸®·Î Á¦°ÅÇÏ´Â ¹æ¹ý
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services
¸¦ È®ÀåÇÏ¸é ¾Æ·¡ÀÇ ¼ºñ½º Ç׸ñµé Áß¿¡ °ñ¶ó¼ Á¦°ÅÇÏ¸é µÈ´Ù.
»èÁ¦ ÈÄ ÀçºÎÆÃ