Docker 사용하여 mysql 설치 및 외부접속 하기

Docker에 Mysql 설치

docker pull mysql
docker volume create {volume}
docker run -d -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD={password} -v {volume}:/var/lib/mysql mysql --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
docker exec -it {container ID} /bin/bash

docker pull mysql

docker volume create {volume}

docker run -d -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD={password} -v {volume}:/var/lib/mysql mysql --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

docker exec -it {container ID} /bin/bash

Mysql 설정

mysql -u root -p{password}
CREATE USER '{ID}'@'%' IDENTIFIED BY '{PASSWORD}';
GRANT ALL PRIVILEGES ON *.* TO '{ID}'@'%';
CREATE DATABASE {DATABASENAME};
flush privileges;

mysql -u root -p{password}

CREATE USER '{ID}'@'%' IDENTIFIED BY '{PASSWORD}';

GRANT ALL PRIVILEGES ON *.* TO '{ID}'@'%';

CREATE DATABASE {DATABASENAME};

flush privileges;

Public Key Retrieval is not allowed 오류 발생시

allowPublicKeyRetrieval=true

useSSL=false

JDBC 접속

jdbc:mysql://localhost:3306/{DATABASE}?useSSL=false&allowPublicKeyRetrieval=true

Docker 사용하여 mysql 설치 및 외부접속 하기

답글 남기기 응답 취소