mysql 임시비밀번호 에러 Your password has expired. To log in you must change it using a client that supports expired passwords.

Your password has expired. To log in you must change it using a client that supports expired passwords.

 

You must reset your password using ALTER USER statement before executing this statement.

 

 

해결방법

ALTER USER 'root'@'localhost' IDENTIFIED BY '새로운 비밀번호';

 

 

 

참고사이트

https://innocentk.tistory.com/170

 

[MYSQL]Connect Error: Your password has expired. To log in you must change it using a client that supports expired passwords.

데이터베이스 선택 use 데이터베이스 실행 ALTER USER `root`@`localhost` IDENTIFIED BY '비밀번호', `root`@`localhost` PASSWORD EXPIRE NEVER;

innocentk.tistory.com

 

https://morningame.tistory.com/6

 

MySQL You must reset your password using ALTER USER statement before executing this statement. 대처법

1. 현상 MySQL 5.7.16 버전을 설치하고 root 계정으로 접속, 정상 접속되는 것을 확인했지만 use mysql;을 입력하니 아래와 같은 문구가 나왔다. You must reset your password using ALTER USER statement before..

morningame.tistory.com

댓글

Designed by JB FACTORY