인프런 커뮤니티 질문&답변

igwangmin@igwangmin-ui-MacBookPro ~ % docker ps -a                                                               
CONTAINER ID   IMAGE     COMMAND                   CREATED        STATUS                    PORTS     NAMES
8550a9a141fd   mysql     "docker-entrypoint.s…"   15 hours ago   Exited (0) 11 hours ago             mysql
igwangmin@igwangmin-ui-MacBookPro ~ % docker container restart 8550a9a141fdaee67b6f7c586a24085c98a9b99512cb7a8901f0c23cf9082536
8550a9a141fdaee67b6f7c586a24085c98a9b99512cb7a8901f0c23cf9082536
igwangmin@igwangmin-ui-MacBookPro ~ % docker ps   
CONTAINER ID   IMAGE     COMMAND                   CREATED        STATUS         PORTS                               NAMES
8550a9a141fd   mysql     "docker-entrypoint.s…"   15 hours ago   Up 4 minutes   0.0.0.0:3306->3306/tcp, 33060/tcp   mysql

Docker restart를 한 후 Spring을 가동했을 때 아래와 같은 오류가 발생합니다.

2024-04-21 09:25:02.485  INFO 1378 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2024-04-21 09:25:03.641 ERROR 1378 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.29.jar:8.0.29]
	

기존에 알려주신 방법인 아래와 같은 터미널 창에서 입력후 재실행하였으나 똑같은 오류가 발생해 혹시 다른 방법이 존재할까요

igwangmin@igwangmin-ui-MacBookPro Mikor % docker exec -it mysql bash                                               
bash-4.4# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.3.0 MySQL Community Server - GPL

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use stock_example;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| stock_example      |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use stock_example;
Database changed
mysql> 

Spring 버전은 아래와 같고

plugins {
    id 'org.springframework.boot' version '2.7.1'
    id 'io.spring.dependency-management' version '1.0.11.RELEASE'
    id 'java'
}

group = 'com.shop'
version = '0.0.1-SNAPSHOT'
sourceCompatibility = '11'

configurations {
    compileOnly {
       extendsFrom annotationProcessor
    }
}

도커 버전은 아래와 같습니다.

igwangmin@igwangmin-ui-MacBookPro ~ % docker version                                                                           
Client: Docker Engine - Community
 Version:           26.0.0
 API version:       1.44 (downgraded from 1.45)
 Go version:        go1.22.1
 Git commit:        2ae903e86c
 Built:             Wed Mar 20 15:10:03 2024
 OS/Arch:           darwin/arm64
 Context:           desktop-linux

Server: Docker Desktop 4.28.0 (139021)
 Engine:
  Version:          25.0.3
  API version:      1.44 (minimum version 1.24)
  Go version:       go1.21.6
  Git commit:       f417435
  Built:            Tue Feb  6 21:14:22 2024
  OS/Arch:          linux/arm64
  Experimental:     false
 containerd:
  Version:          1.6.28
  GitCommit:        ae07eda36dd25f8a1b98dfbf587313b99c0190bb
 runc:
  Version:          1.1.12
  GitCommit:        v1.1.12-0-g51d5e94
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0