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

Workbench 인증 프로토콜 거부 현상

Connection using old (pre-4.1.1) 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)

2 해결방법

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

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

3 같이 보기

• Workbench