Search
Duplicate

Workbench

Workbench

MySQL Workbench
1.
root ๊ณ„์ •์œผ๋กœ ์ ‘์†
2.
Users and Privileges
3.
[Add Account]
a.
Login Name: ์•„์ด๋””
b.
Password : ๋น„๋ฐ€๋ฒˆํ˜ธ
c.
Confirm Password : ๋น„๋ฐ€๋ฒˆํ˜ธ ํ™•์ธ
4.
[Administrative Roles]
a.
DBA
5.
[Apply]
Workbench ๊ณ„์ • ์ƒ์„ฑ
1.
+
2.
์•„์ด๋”” ์ž…๋ ฅ
3.
Store in Valutโ€ฆ
4.
๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ
5.
[Test Connection]
6.
OK
Workbench ๊ณ„์ • ์ ‘์†
1.
SCHEMAS [์šฐํด๋ฆญ]
2.
Create Schema
3.
์Šคํ‚ค๋งˆ ์ด๋ฆ„ ์ž…๋ ฅ
4.
[Apply]
Workbench ์Šคํ‚ค๋งˆ ์ƒ์„ฑ

Workbench ๊ธฐ๋ณธ ์Šคํ‚ค๋งˆ ์„ค์ •

1.
์Šคํ‚ค๋งˆ [์šฐํด๋ฆญ]
2.
[Set as Default Schema]
Default Schema = ๊ธฐ๋ณธ ์Šคํ‚ค๋งˆ ๊ธฐ๋ณธ ์Šคํ‚ค๋งˆ๋กœ ์„ค์ • ๋˜์–ด ์žˆ์–ด์•ผ, ์–ด๋–ค ์Šคํ‚ค๋งˆ์ธ์ง€ ์ง€์ •ํ•˜์ง€ ์•Š๊ณ ๋„ DB ๊ฐ์ฒด๋ฅผ ์ง€์ •ํ•  ์ˆ˜ ์žˆ๋‹ค.
Workbench default Schema

Reverse Engineering (์—ญ๊ณตํ•™)

"์ด๋ฏธ ์กด์žฌํ•˜๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ ํ…Œ์ด๋ธ”, ์ปฌ๋Ÿผ, ์ œ์•ฝ์กฐ๊ฑด, ๊ด€๊ณ„(FK) ๋“ฑ์„ ์ถ”์ถœํ•˜์—ฌ ์ด๋ฅผ ์‹œ๊ฐ์ ์œผ๋กœ ํ‘œํ˜„(ERD๋กœ)ํ•˜๊ฑฐ๋‚˜, ๋‹ค์‹œ ๋ชจ๋ธ๋ง ๋„๊ตฌ์—์„œ ์‚ฌ์šฉ ๊ฐ€๋Šฅํ•œ ํ˜•ํƒœ๋กœ ๋งŒ๋“œ๋Š” ์ž‘์—…โ€

์ผ๋ฐ˜์ ์ธ ์—ญ๊ณตํ•™์˜ ์˜๋ฏธ

์ด๋ฏธ ๊ตฌ์ถ•๋˜์–ด ์žˆ๋Š” ์‹œ์Šคํ…œ์ด๋‚˜ ์†Œํ”„ํŠธ์›จ์–ด, ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๊ตฌ์กฐ ๋“ฑ์„ ๋ถ„์„ํ•˜์—ฌ ๊ทธ ๋‚ด๋ถ€ ๊ตฌ์กฐ, ๋™์ž‘ ๋ฐฉ์‹, ์„ค๊ณ„ ์ •๋ณด๋ฅผ ๋„์ถœํ•˜๋Š” ๊ณผ์ •์„ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค.
Reverse Engineering