Docker MySQL Setting

Docker MySQL Setting

Tags
SQL
Backend
Tech
Published
Author
๋„์ปค์— MySQL ์„ค์น˜
docker pull --platform linux/amd64 mysql:5.7
MySQL Docker ์ปจํ…Œ์ด๋„ˆ ์ƒ์„ฑ
docker run --name mysql-container -e MYSQL_ROOT_PASSWORD=<๋น„๋ฐ€๋ฒˆํ˜ธ ์ž…๋ ฅ> -d -p 3306:3306 mysql:latest
MySQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์‚ฌ์šฉ์ž ์ƒ์„ฑ
mysql> create user 'jinseo'@'localhost' identified by 'password';
๐Ÿ“Œ
์ปจํ…Œ์ด๋„ˆ ์™ธ๋ถ€์—์„œ MySQL์— ๋กœ๊ทธ์ธ์ด ํ•„์š”ํ•  ์‹œ,ย localhostย ๋Œ€์‹ ย %๋ฅผ ์ž…๋ ฅํ•œ๋‹ค.
MySQL ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์ƒ์„ฑํ•œ ์œ ์ €์—์„œ ๋ชจ๋“  DB ๋ฐ ํ…Œ์ด๋ธ” ์ ‘๊ทผ ๊ถŒํ•œ ๋ถ€์—ฌ
mysql> grant all privileges on *.* to 'jinseo'@'localhost';
์„ค์ •ํ•œ ๊ถŒํ•œ ์ ์šฉ
mysql> flush privileges;
์ปจ๋„ค์ดํ„ฐ ์ ‘์†
docker exec -it [container-name] bin/bash
MySQL ์ ‘์†
mysql -u root -p
๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฆฌ์ŠคํŠธ ํ™•์ธ
mysql> SHOW DATABASES;
๋ฐ์ด๋ฒ„๋ฒ ์ด์Šค ์ƒ์„ฑ
mysql> CREATE DATABASE UserLog;
DB ์„ ํƒ
mysql> use UserLog;
ํ…Œ์ด๋ธ” ํ™•์ธ
mysql> SHOW tables;
ย