Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure auth' enabled)

Workbench 인증 프로토콜 거부 현상

Connection using old authentication protocol refused (client option 'secure auth' enabled)

1 문제상황

MySQL Workbench에서 Setup New Connection 중 오류

Failed to Connect to MySQL at 135.79.246.80:3306 with user testuser Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure auth' enabled)

• 서버쪽 인증 방식이 옛날 거라서 클라이언트(Workbench)가 자체 거부한 것…

2 해결방법

• Setup New Connection 창의 Advanced 탭
• [V] Use the old authentication protocol
• [Test Connection]

이제 정상적으로 접속된다.

3 같이 보기

• Workbench

4 참고

• http://stackoverflow.com/questions/16491843/connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option