[Error] nested exception is java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'.] with root cause

Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'.] with root cause

위에는 에러 내용

 

USE 데이터베이스명입력;
ALTER USER 아이디입력@localhost IDENTIFIED WITH mysql_native_password BY '비밀번호입력'; 

 사용할 데이터베이스에 들어가서 위와 같이 사용자를 수정했다.

 

 

 

참고 👉 https://seoulbliss.tistory.com/88

[코딩이야기] java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'. mysql 에러