๐Ÿ‘ฉ‍๐Ÿ’ป/Data Base 1

[MySQL] MySQL Installer -> Type and Networking -> Port "The Specified port is already in use" ์ด์Šˆ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ•

DB ์ด์šฉํ•ด์„œ ํšŒ์› ๊ด€๋ฆฌ ์‹œ์Šคํ…œ ์—ฐ์Šต์„ ์œ„ํ•ด์„œ ๋‹ค์‹œ MySQL ์„ค์น˜๋ฅผ ์ง„ํ–‰ํ•˜๋Š”๋ฐ, ์˜ˆ์ „์— MySQL ์„ค์น˜๋ฅผ ํ•ด๋‘” ๋ฒ„์ „์ด ์žˆ์–ด์„œ Port ์„ค์ • ๋‹จ๊ณ„์—์„œ "The specified port is already in use"๋ผ๋Š” ๋ฉ”์„ธ์ง€๋ฅผ ๋„์› ๋‹ค. ๋ฆฌ์†Œ์Šค ๋ชจ๋‹ˆํ„ฐ์—์„œ ๊ฐ„๋‹จํ•˜๊ฒŒ ํ•ด๊ฒฐํ•  ์ˆ˜ ์žˆ๋‹ค. Window+R -> resmon.exe ์‹คํ–‰ ๋˜๋Š” ์œˆ๋„์šฐ ๊ฒ€์ƒ‰์— '๋ฆฌ์†Œ์Šค ๋ชจ๋‹ˆํ„ฐ'๋ผ๊ณ  ๊ฒ€์ƒ‰ํ•ด๋„ ๋œ๋‹ค. ๋„คํŠธ์›Œํฌ ํƒญ -> ์ˆ˜์‹ ๋Œ€๊ธฐ ํฌํŠธ ์“ฐ๊ณ ์ž ํ–ˆ๋˜ ํฌํŠธ ๋„˜๋ฒ„๊ฐ€ 3306์ด์—ˆ์œผ๋ฏ€๋กœ, ํ•ด๋‹น ํŒŒ์ผ์˜ PID๋ฅผ ํ™•์ธํ•œ๋‹ค. ๋ช…๋ น ํ”„๋กฌํฌํŠธ(CMD) -> ๊ด€๋ฆฌ์ž ๊ถŒํ•œ์œผ๋กœ ์‹คํ–‰ / ๋˜๋Š” Window + R๋กœ CMD ๊ฒ€์ƒ‰ taskkill /F /PID 6060 ๋ช…๋ น์–ด ์ž…๋ ฅ. ์˜คํƒ€์— ์ฃผ์˜ ๐Ÿ˜ช ์ด์ œ 3306์„ Port number๋กœ ์“ธ ์ˆ˜ ์žˆ๋‹ค.