๋กœ์ผ“๐Ÿพ
article thumbnail
๋ฐ˜์‘ํ˜•

 

1. ec2 ์ ‘์† ํ›„ cd/etc/mysql/mysql.conf.d ๋กœ ์ด๋™ํ•ฉ๋‹ˆ๋‹ค.

2.  sudo vi mysqld.cnf 

3. bind-address 127.0.0.1 ๊ฐ€ ์ ํžŒ์ค„ ๋งจ์•ž์— # ๋ฅผ ๋„ฃ์–ด ์ฃผ์„์ฒ˜๋ฆฌ ํ•ด์ฃผ๊ธฐ

4. mysql ์ ‘์†(sudo /usr/bin/mysql -u root -p)

 

5. ์™ธ๋ถ€์ ‘์† ํ—ˆ์šฉ sql๋ฌธ ์ž…๋ ฅ

mysql> create user 'root'@'%' identified by '[password]';
mysql> grant all privileges on *.* to 'root'@'%' with grant option;

'root' ๋Œ€์‹  ์œ ์ € ์ด๋ฆ„์„ ๋„ฃ์–ด์ฃผ์‹œ๋ฉด๋˜๊ณ , %๋Š” ๋ชจ๋“  ๊ณณ์—์„œ ์ ‘์† ํ—ˆ์šฉ์ด๋ผ๋Š” ๋œป์ž…๋‹ˆ๋‹ค.

 

6. mysql ์žฌ์‹œ์ž‘ํ•˜๊ธฐ

sudo service mysql restart
sudo ufw allow out 3306/tcp
sudo ufw allow in 3306/tcp
sudo service mysql restart

ufw allow๋Š” ํฌํŠธ๋ฅผ ์—ด์–ด์ค๋‹ˆ๋‹ค. ๋ช…๋ น์–ด ์‹คํ–‰ ํ›„ Rules updated๊ฐ€ ๋‚˜์˜ค๋ฉด ์ •์ƒ์ž…๋‹ˆ๋‹ค.

 

aws ์ธ์Šคํ„ด์Šค ๋ณด์•ˆ๊ทธ๋ฃน ์ธ๋ฐ”์šด๋“œ ๊ทœ์น™์— ํฌํŠธ๋ฒˆํ˜ธ 3306 ์ถ”๊ฐ€ํ•ด์ฃผ๋Š” ๊ฒƒ๋„ ์žŠ์ง€๋งˆ์„ธ์š”!

 

7. mysql workbench ์‹คํ–‰ํ•˜๊ธฐ

์œˆ๋„์šฐ์—์„œ ์›Œํฌ๋ฒค์น˜๋ฅผ ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.

+๋ฒ„ํŠผ์„ ๋ˆŒ๋Ÿฌ ํ•ด๋‹น ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ip์ฃผ์†Œ์™€ ์‚ฌ์šฉ์ž๋ช…์„ ์ž…๋ ฅํ•˜๋ฉด ์—ฐ๊ฒฐ์ด ๋ฉ๋‹ˆ๋‹ค.

๋ฐ˜์‘ํ˜•
profile on loading

Loading...