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
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