๐Ÿฅ”Project/[Project] Threepark

[Capstone Design] 1. ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค (AWS RDS + MySQL) - (2) MySQL ์—ฐ๊ฒฐ

mingyung 2024. 5. 13. 15:04

 

์ด์ „ ํฌ์ŠคํŒ…์—์„œ๋Š” RDS์ธ์Šคํ„ด์Šค๋ฅผ ์ƒ์„ฑํ–ˆ๋‹ค. 

์ด์ œ MySQL์„ RDS์™€ ์—ฐ๊ฒฐํ•˜์—ฌ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํด๋ผ์šฐ๋“œ๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋„๋ก ํ•˜๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด ์•Œ์•„๋ณธ๋‹ค.

 

MySQL ๋‹ค์šด๋กœ๋“œ

https://dev.mysql.com/downloads/installer/

 

MySQL :: Download MySQL Installer

Note: MySQL 8.0 is the final series with MySQL Installer. As of MySQL 8.1, use a MySQL product's MSI or Zip archive for installation. MySQL Server 8.1 and higher also bundle MySQL Configurator, a tool that helps configure MySQL Server.

dev.mysql.com

MySQL์„ ๋‹ค์šด๋ฐ›์ž 

๋ฒ„์ „์€ 8.0์œผ๋กœ ํ•œ๋‹ค.

๋‘๊ฐœ์˜ ๋‹ค์šด๋กœ๋“œ ๋ฒ„ํŠผ ์ค‘ ๋‘๋ฒˆ์งธ๋ฅผ ๋ˆ„๋ฅธ๋‹ค.

์ดํ›„ ์•ˆ๋‚ด๋ฅผ ๋”ฐ๋ผ MySQL์„ ์„ค์น˜ํ•˜๋„๋ก ํ•œ๋‹ค.

 

MySQL๊ณผ RDS ์—ฐ๊ฒฐ

์„ค์น˜ ์™„๋ฃŒ ํ›„ MySQL Workbench๋ฅผ ์—ฐ๋‹ค.

๊ฒ€์ƒ‰ํ•˜์—ฌ ์ฐพ์•„์ฃผ์ž

์ด์ œ MySQL Connections ์˜†์˜ +๋ฒ„ํŠผ์„ ๋ˆ„๋ฅธ๋‹ค

๊ทธ๋Ÿผ ์ด๋Ÿฐ ์ฐฝ์ด ๋œจ๊ฒŒ๋œ๋‹ค.

๋จผ์ € Connection Name์€ ์–ด๋–ค MySQL์— ๋Œ€ํ•œ ์—ฐ๊ฒฐ์ธ์ง€ ์ธ์ง€ํ•˜๊ธฐ ์œ„ํ•œ ์ด๋ฆ„์ด๋ฏ€๋กœ ๋ณธ์ธ์ด ์›ํ•˜๋Š” ์ด๋ฆ„์œผ๋กœ ์ž‘์„ฑํ•œ๋‹ค.

 

Hostname์—๋Š” RDS์˜ ์—”๋“œํฌ์ธํŠธ ์ •๋ณด๋ฅผ ์ž…๋ ฅํ•œ๋‹ค.

์ด์ „์— ์ƒ์„ฑํ•œ RDS์— ๋“ค์–ด๊ฐ€๋ฉด ์—”๋“œํฌ์ธํŠธ์— ๋Œ€ํ•œ ์ •๋ณด๊ฐ€ ์žˆ์œผ๋‹ˆ ๋ณต์‚ฌํ•˜์—ฌ ๋ถ™์—ฌ๋„ฃ๋Š”๋‹ค.

Port์—๋Š” ํฌํŠธ ๋ฒˆํ˜ธ๋ฅผ ์ž…๋ ฅํ•œ๋‹ค.

๊ธฐ๋กํ•ด๋’€๋˜ username์„ ์ ๊ณ , store in vault๋ฅผ ๋ˆŒ๋Ÿฌ password๋ฅผ ์ž…๋ ฅํ•œ๋‹ค.

 

Test Connection๋ฅผ ๋ˆ„๋ฅด๊ณ  ์•„๋ž˜ ์•Œ๋žŒ์ด ๋œฌ๋‹ค๋ฉด Ok๋ฅผ ๋ˆ„๋ฅธ๋‹ค.