๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

mysql5.73

์šฐ๋ถ„ํˆฌ Ubuntu 18.04์—์„œ mysql5.7 ์™„์ „ ์‚ญ์ œ ๋ฐ ์žฌ์„ค์น˜ mysql5.7 ์™„์ „ ์‚ญ์ œ ๋‚ด ๊ฒฝ์šฐ ํŒจํ‚ค์ง€ ์„ค์น˜๋กœ ์ง„ํ–‰ํ–ˆ์—ˆ๊ธฐ์— ์•„๋ž˜์™€ ๊ฐ™์ด ๋ช…๋ น์–ด ์ž…๋ ฅ sudo apt-get remove --purge mysql* ํŒŒ์ผ๋“ค ์ „๋ถ€ ์‚ญ์ œ sudo rm -rf /etc/mysql /var/lib/mysql sudo rm -rf /var/log/mysql sudo rm -rf /var/log/mysql.* ์•„๋ž˜์˜ ๋ช…๋ น์–ด๋กœ ํ™•์ธ์‚ฌ์‚ด sudo apt-get autoremove ์ด๊ฒƒ๋„ sudo apt-get autoclean mysql5.7 ์žฌ์„ค์น˜ sudo apt-get install mysql-server --fix-missing --fix-broken sudo mysql_secure_installation 2023. 8. 23.
mac os mysql5.7 ์‹คํ–‰ ๋ฌธ์ œ ํ•ด๊ฒฐ - Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ์—๋Ÿฌ ํ•ด๊ฒฐ Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ๋Œ€๋ถ€๋ถ„์˜ ํ•ด๋‹น ์—๋Ÿฌ์— ๋Œ€ํ•œ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ•์€ ์•„๋ž˜์˜ค ๊ฐ™์€ mysql ์„œ๋น„์Šค ์‹คํ–‰ ์—ฌ๋ถ€์˜€๋‹ค. brew services start mysql@5.7 ํ•˜์ง€๋งŒ ๋‚ด ๊ฒฝ์šฐ๋Š” ์•„๋‹ˆ์—ˆ๋‹ค!! ๋‚ด ๊ฒฝ์šฐ์—๋Š” ๊ธฐ์กด mysql 8.0์„ค์น˜๋ฅผ ํ•œ ํ›„ ํ•จ๊ป˜ ์ œ๊ฑฐํ–ˆ๋‹ค ๊น”์•˜๋Š”๋ฐ, configํŒŒ์ผ์— ๋ฌธ์ œ๊ฐ€ ์ƒ๊ฒผ๋˜ ๊ฒƒ์ด์—ˆ๋‹ค. brew install mysql@5.7 ์—์„œ ์ž์„ธํžˆ ์‚ดํŽด๋ณด๋‹ˆ ์•„๋ž˜์˜ ๋ฌธ์ œ๊ฐ€ ์ƒ๊ฒผ์—ˆ๋‹ค. [ERROR] unknown variable 'mysqlx-bind-address=127.0.0.1' [ERROR] Aborting ์ด ๊ฒฝ์šฐ ์•„๋ž˜์˜ ๋ช…๋ น์ด ์ฃผ์š”ํ–ˆ๋‹ค! ํ™ˆ ๊ฒฝ๋กœ์— ๋‹ค์Œ์˜ ํŒŒ์ผ์„ ๋งŒ๋“ค.. 2023. 6. 29.
Mac OS Monterey(๋ฒ„์ „ 12.6)์—์„œ mysql 5.7 ์„ค์น˜ํ•˜๊ธฐ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋Š” ๋งฅ ๋ฒ„์ „ mysql ์„ค์น˜๋ฅผ ์œ„ํ•ด Homebrew๋ฅผ ํ™œ์šฉํ•˜์˜€์œผ๋ฉฐ, ์ด์™€ ๊ด€๋ จํ•ด์„œ๋Š” ์•„๋ž˜ ๊ธ€ ์ฐธ์กฐ. https://gentlesark.tistory.com/114 [Mac] ๋งฅ์— Homebrew ์„ค์น˜ ๋ฐ brew cask ์„ค์น˜ Ubuntu์— ํŒจํ‚ค์ง€ ๊ด€๋ฆฌ ๋„๊ตฌ apt๊ฐ€ ์žˆ๋‹ค๋ฉด, ๋งฅ์—๋Š” ํŒจํ‚ค์ง€ ๊ด€๋ฆฌ ๋„๊ตฌ Homebrew๊ฐ€ ์žˆ๋‹ค. ๊ทธ๋ฆฌ๊ณ  cask๋Š” ์ด Homebrew์˜ ํ™•์žฅํŒฉ์ด๋ผ๊ณ  ๋ณผ ์ˆ˜ ์žˆ๋Š”๋ฐ, ์ด ๋‘๊ฐ€์ง€ ๋ชจ๋‘ ์„ค์น˜ ๋ฐฉ๋ฒ•์„ ์†Œ๊ฐœํ•œ๋‹ค. Homebrew ์„ค์น˜ ๋ฐฉ๋ฒ• /bi gentlesark.tistory.com ์„ค์น˜ ๋ช…๋ น์–ด brew install mysql@5.7 ์ดํ›„ ์„ธํŒ… mysql ๋ช…๋ น์–ด ์‹คํ–‰์ด ๋˜๋„๋ก ํ™˜๊ฒฝ๋ณ€์ˆ˜์— ๊ฒฝ๋กœ ์„ค์ • echo 'export PATH="/opt/homebrew/opt/mysq.. 2023. 6. 29.