< cd ..
junter@IP024:~$ cat day30.log
# ๋งˆ์ง€๋ง‰ ์ˆ˜์ • ์‹œ๊ฐ„ : 2026-07-30 16:30:01

30์ผ์ฐจ -

์‹ค์Šต ๋ชฉํ‘œ

DVWA(Damn Vulnerable Web Application) ํ™˜๊ฒฝ์„ ๊ตฌ์ถ•ํ•˜๊ณ , SQL Injection์˜ ์›๋ฆฌ๋ฅผ ์ง์ ‘ ์‹ค์Šต์„ ํ†ตํ•ด ์ดํ•ดํ•œ๋‹ค.

DVWA ๊ณ„์ • & DB ์„ค์ •

CREATE USER 'dvwa'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dvwa.* TO 'dvwa'@'%';
FLUSH PRIVILEGES;

๋ผ์šฐํŒ… ๊ตฌ์กฐ : routes โ†’ Home.php โ†’ Views โ†’ sqli.php ํ˜•ํƒœ๋กœ /sqli ํŽ˜์ด์ง€๋ฅผ ๋ผ์šฐํ„ฐ์— ๋“ฑ๋ก.

SQL Injection ์‹ค์Šต

๋กœ๊ทธ์ธ/์กฐํšŒ์ฐฝ์— ์ž…๋ ฅ๋˜๋Š” ๊ฐ’์ด SQL ์ฟผ๋ฆฌ๋ฌธ์— ๊ทธ๋Œ€๋กœ ๋“ค์–ด๊ฐ€๋Š” ๊ตฌ์กฐ๋ฅผ ์ด์šฉํ•ด, ์•„๋ž˜์ฒ˜๋Ÿผ ์กฐ๊ฑด์„ ์กฐ์ž‘ํ•˜๋Š” ์ธ์ ์…˜์„ ํ…Œ์ŠคํŠธํ–ˆ๋‹ค.

SELECT * FROM dvwa.users WHERE user_id = '';
SELECT * FROM dvwa.users WHERE user_id = '' OR '';
SELECT * FROM dvwa.users WHERE user_id = '' OR '1=1';
SELECT * FROM dvwa.users;

์ •์ƒ์ ์œผ๋กœ๋Š” ์กฐ๊ฑด์— ๋งž๋Š” ๊ฐ’๋งŒ ๋‚˜์™€์•ผ ํ•˜์ง€๋งŒ, OR '1=1' ์ฒ˜๋Ÿผ ํ•ญ์ƒ ์ฐธ์ด ๋˜๋Š” ์กฐ๊ฑด์„ ๋„ฃ์œผ๋ฉด users ํ…Œ์ด๋ธ” ์ „์ฒด(5๊ฐœ ๋ฐ์ดํ„ฐ)๊ฐ€ ๊ทธ๋Œ€๋กœ ๋…ธ์ถœ๋จ์„ ํ™•์ธํ–ˆ๋‹ค.

๋А๋‚€ ์ 

์ž…๋ ฅ๊ฐ’ ๊ฒ€์ฆ ์—†์ด ์ฟผ๋ฆฌ๋ฅผ ๊ทธ๋Œ€๋กœ ์กฐํ•ฉํ•˜๋ฉด, ๋‹จ์ˆœํ•œ ๋ฌธ์ž์—ด(' or '1=1) ํ•˜๋‚˜๋กœ๋„ ์ธ์ฆ ๋กœ์ง์ด ์™„์ „ํžˆ ๋ฌด๋ ฅํ™”๋  ์ˆ˜ ์žˆ๋‹ค๋Š” ๊ฑธ ์ง์ ‘ ๋ˆˆ์œผ๋กœ ํ™•์ธํ•œ ๊ฒŒ ์ธ์ƒ ๊นŠ์—ˆ๋‹ค. "SQL Injection์€ ์™œ ์œ„ํ—˜ํ•œ๊ฐ€"๋ฅผ ์ด๋ก ์ด ์•„๋‹ˆ๋ผ ๋ชธ์œผ๋กœ ์ดํ•ดํ•œ ํ•˜๋ฃจ.

๋‹ค์Œ ์‹ค์Šต ์˜ˆ๊ณ 

๋‹ค๋‹ค์Œ ์ฃผ ํ† ์š”์ผ โ€” CSRF (Cross-Site Request Forgery) ์‹ค์Šต ์˜ˆ์ •