Tuesday, March 17, 2015

Solved: MySQL Issue Connection using old (pre-4.1.1) authentication protocol refused.

The following error occured when run `mysql` from the terminal to connect to a server.

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connect
ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

Solution:
Add `--skip-secure-auth` to the end of the statement

Example:
mysql -h HostName -u UserName -pPassword DbName --skip-secure-auth

No comments:

Post a Comment