[Window10] Mysql ¼ºñ½º µî·Ï/»èÁ¦
Window ½Ã½ºÅÛ¿¡ Mysql¸¦ ¼³Ä¡ ÈÄ ¼ºñ½º(Daemon) µî·Ï/»èÁ¦ ÇÏ´Â ¹æ¹ýÀÌ´Ù.
¸ÕÀú ½Ã½ºÅÛ¿¡ »çÀü¿¡ µî·ÏµÈ Mysql¼ºñ½º°¡ ÀÖ´ÂÁö È®ÀÎÇÑ´Ù.
CMD > sc query | find /i "mysql"
¾Æ¹«·± Ãâ·ÂÀÌ ¾ø´Ù¸é ¾Æ·¡¿Í °°ÀÌ mysql¸¦ ¼ºñ½º·Î µî·ÏÇÒ ¼ö ÀÖ´Ù.
¼ºñ½º µî·Ï
MysqlÀÌ ¼³Ä¡µÈ Æú´õ·Î À̵¿ÇÏ¿© ¾Æ·¡ ¸í·É¾î¸¦ ½ÇÇàÇÑ´Ù.
D:\Mysql\mysql-5.7.27-winx64>.\bin\mysqld --install
Service successfully installed.
Á¤»óÀûÀ¸·Î µî·ÏÀÌ µÇ¾ú´ÂÁö´Â À§ÀÇ "sc query | find /i "mysql" ¶Ç´Â scquery mysql" ¸í·É¾î¸¦ ½ÇÇàÇÏ¿© È®ÀÎÇϰųª ¼ºñ½º °ü¸®Ã¢¿¡¼ È®ÀÎÇÑ´Ù.
¶Ç´Â (¼ºñ½º °ü¸®Ã¢ ½ÇÇàÀº winÅ° + r·Î ½ÇÇàâÀ» ¿°í services.msc¶ó°í ÀÔ·ÂÇϰųª Á¦¾îÆÇ > °ü¸®µµ±¸ > ¼ºñ½º¿¡¼ ½ÇÇàÇÒ ¼ö ÀÖ´Ù.)
¼ºñ½º µî·ÏÀÌ ¿Ï·áµÇ¸é ¼ºñ½º â¿¡¼ ½ÃÀÛ/ÁßÁö¸¦ ÇÒ ¼ö ÀÖ°í CMDâ¿¡¼´Â ¾Æ·¡¿Í °°ÀÌ ÇÒ ¼ö ÀÖ´Ù.
COMMAND > net [start|stop] mysql
¸¸¾à ¼ºñ½º¸¦ µî·ÏÇÒ ¶§ ¾Æ·¡¿Í °°Àº ¿¡·¯°¡ ¹ß»ýÇÒ °æ¿ì ´çȲÇÏÁö ¸»°í ±âÁ¸ ¼ºñ½º¸¦ »èÁ¦ÇÏ°í ´Ù½Ã µî·ÏÇÏ¸é µÈ´Ù.
"The service already exists!"
D:\Mysql\mysql-5.7.27-winx64>.\bin\mysqld --install
The service already exists!
The current server installed: D:\Mysql\mysql-5.7.27-winx64\bin\mysqld MySQL
¼ºñ½º »èÁ¦
µî·ÏµÈ ¼ºñ½º¸¦ »èÁ¦ ÇÒ¶§¿¡´Â ¼ºñ½º¸¦ ÁßÁö ½ÃŲ´ÙÀ½¿¡ »èÁ¦ ÇÑ´Ù.
¼ºñ½º ÁßÁö => CMD > net stop mysql ¶Ç´Â sc stop mysql
¼ºñ½º µî·Ï »èÁ¦ => CMD > ${MYSQL_HOME}\bin\mysqld --remove ¶Ç´Â sc delete mysql
D:\Mysql\mysql-5.7.27-winx64>net stop mysql
MySQL ¼ºñ½º¸¦ ¸ØÃä´Ï´Ù..
MySQL ¼ºñ½º¸¦ Àß ¸ØÃß¾ú½À´Ï´Ù.
D:\Mysql\mysql-5.7.27-winx64>.\bin\mysqld --remove
Service successfully removed.