Search

์‚ฌ์šฉ์ž ๊ณ„์ • ์ƒ์„ฑ

SQL ๋ช…๋ น์–ด๋กœ ๊ณ„์ • ์ƒ์„ฑ

-- 1. ์‚ฌ์šฉ์ž ์ƒ์„ฑ CREATE USER 'aloha'@'%' IDENTIFIED BY '123456'; -- 2. ๋ชจ๋“  ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ๋Œ€ํ•ด ๋ชจ๋“  ๊ถŒํ•œ ๋ถ€์—ฌ GRANT ALL PRIVILEGES ON *.* TO 'aloha'@'%' WITH GRANT OPTION; -- 3. ๊ถŒํ•œ ๋ณ€๊ฒฝ ์ ์šฉ FLUSH PRIVILEGES;
SQL
๋ณต์‚ฌ
๋ช…๋ น์–ด
์˜๋ฏธ
CREATE USER
์ƒˆ ๊ณ„์ •(aloha) ๋งŒ๋“ค๊ธฐ
@'%'
์–ด๋””์„œ ์ ‘์†ํ•˜๋“  ํ—ˆ์šฉ (๋ชจ๋“  IP)
GRANT ALL PRIVILEGES
๋ชจ๋“  ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค/ํ…Œ์ด๋ธ”์— ๋Œ€ํ•ด ๋ชจ๋“  ๊ถŒํ•œ ๋ถ€์—ฌ
WITH GRANT OPTION
๋‹ค๋ฅธ ์‚ฌ์šฉ์ž์—๊ฒŒ๋„ ๊ถŒํ•œ์„ ์ค„ ์ˆ˜ ์žˆ๊ฒŒ ํ—ˆ์šฉ
FLUSH PRIVILEGES
๊ถŒํ•œ ํ…Œ์ด๋ธ”์„ ์ฆ‰์‹œ ๊ฐฑ์‹ 

Workbench ์—์„œ ๊ณ„์ • ์ƒ์„ฑ ํ•˜๊ธฐ

1.
Administration
2.
Users and Privileges
3.
๊ณ„์ • ์ •๋ณด ์ž…๋ ฅ
a.
Login Name
b.
Password
c.
Confirm Password
4.
Administrative Roles
a.
DBA