-
Notifications
You must be signed in to change notification settings - Fork 636
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Client does not support authentication protocol requested by server; consider upgrading MySQL client #45
Labels
Comments
MySQL을 설치할 때에 Authentication Method를 설정할 때에 새로운 인증 형식(Use Strong Password Encryption for Authentication)으로 설치하는 경우에도 저 오류가 발생했는데, Use Legacy Authentication Method로 변경하여 설치하는 경우에도 해결 가능한 것 같습니다. |
@Xsolute 네 맞습니다. 5.7과 8.0 비밀번호 인증 형식이 달라서 발생하는 문제입니다. |
mysql2 2버전에서 수정되었다는데 체크해보기 |
mysql2의 2버전을 사용하면 해결됩니다. |
mariadb의 경우 set password = password("새로운 비밀번호 입력"); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
mysql prompt에 (터미널 아님. mysql -u root -p 접속화면임)
입력하시면 됩니다.
The text was updated successfully, but these errors were encountered: