https://phoenixnap.com/kb/mysql-docker-container
https://jang8584.tistory.com/267
ㄴ password 에러로 삽질하다가 mysql 인스턴스 생성시부터 패스워드 설정하는 방식으로 해결 / 접속 권한 등 정리돼있음
https://wooiljeong.github.io/server/docker-mysql/
ㄴ docker 명령어 정리
https://dev.mysql.com/doc/mysql-linuxunix-excerpt/5.6/en/docker-mysql-more-topics.html
docker을 사용해 mysql 접속한 모습
mysql에서 나갈 때는 quit 입력.
ㄴshow databases
로 현재 database 확인
mysql 컨테이너(test-mysql) 에 bash로 접속
bash에서 나갈 때는 exit 입력.
bash 접속 후 locale 입력을 통해 기본 언어가 posix로 설정돼있음을 확인할 수 있다.
한글을 쓰면 깨지기 때문에 utf-8로 locale 설정을 바꿔줘야한다.
language가 latin으로 설정돼있음을 확인할수있다.
database 만들었음
이제 show databases 입력했을 때 그 안에 mydb란 새로운 데이터베이스가 존재함을 확인가능함
쿼리란? database에 대한 요청. insert, select, delete, update와 같은 명령문으로 이뤄진다.
Usage: docker [OPTIONS] COMMAND
A self-sufficient runtime for containers
Options:
--config string Location of client config files (default
"C:\Users\bhmar\.docker")
-c, --context string Name of the context to use to connect to the
daemon (overrides DOCKER_HOST env var and
default context set with "docker context use")
-D, --debug Enable debug mode
-H, --host list Daemon socket(s) to connect to
-l, --log-level string Set the logging level
("debug"|"info"|"warn"|"error"|"fatal")
(default "info")
--tls Use TLS; implied by --tlsverify
--tlscacert string Trust certs signed only by this CA (default
"C:\Users\bhmar\.docker\ca.pem")
--tlscert string Path to TLS certificate file (default
"C:\Users\bhmar\.docker\cert.pem")
--tlskey string Path to TLS key file (default
"C:\Users\bhmar\.docker\key.pem")
--tlsverify Use TLS and verify the remote
-v, --version Print version information and quit
Management Commands:
app Docker App (Docker Inc., v0.9.1-beta3)
builder Manage builds
buildx Build with BuildKit (Docker Inc., v0.5.1-docker)
config Manage Docker configs
container Manage containers
context Manage contexts
image Manage images
manifest Manage Docker image manifests and manifest lists
network Manage networks
node Manage Swarm nodes
plugin Manage plugins
scan* Docker Scan (Docker Inc., v0.5.0)
secret Manage Docker secrets
service Manage services
stack Manage Docker stacks
swarm Manage Swarm
system Manage Docker
trust Manage trust on Docker images
volume Manage volumes
Commands:
attach Attach local standard input, output, and error streams to a running container
build Build an image from a Dockerfile
commit Create a new image from a container's changes
cp Copy files/folders between a container and the local filesystem
create Create a new container
diff Inspect changes to files or directories on a container's filesystem
events Get real time events from the server
exec Run a command in a running container
export Export a container's filesystem as a tar archive
history Show the history of an image
images List images
import Import the contents from a tarball to create a filesystem image
info Display system-wide information
inspect Return low-level information on Docker objects
kill Kill one or more running containers
load Load an image from a tar archive or STDIN
login Log in to a Docker registry
logout Log out from a Docker registry
logs Fetch the logs of a container
pause Pause all processes within one or more containers
port List port mappings or a specific mapping for the container
ps List containers
pull Pull an image or a repository from a registry
push Push an image or a repository to a registry
rename Rename a container
restart Restart one or more containers
rm Remove one or more containers
rmi Remove one or more images
run Run a command in a new container
save Save one or more images to a tar archive (streamed to STDOUT by default)
search Search the Docker Hub for images
start Start one or more stopped containers
stats Display a live stream of container(s) resource usage statistics
stop Stop one or more running containers
tag Create a tag TARGET_IMAGE that refers to SOURCE_IMAGE
top Display the running processes of a container
unpause Unpause all processes within one or more containers
update Update configuration of one or more containers
version Show the Docker version information
wait Block until one or more containers stop, then print their exit codes
