debugsqlMinor
MYSQL ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)
Viewed 0 times
secure_autherrorprotocolenabledused2049authenticationrefpreoption
Problem
when I tried to restore all database dump which is in 5.0 version to 5.6 version, it got restored and after that when I tried to reconnect, am getting the following error
I have tried adding the following lines in My.ini and restarted the service,but the issue persist till.
skip-grant-tables
The following link says its a bug in MYSQL.
https://github.com/santisaez/powerstack/blob/master/packages/mysql/mysql-powerstack-secure_auth.patch
Do anyone have any fixes for this solution?
ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)..I have tried adding the following lines in My.ini and restarted the service,but the issue persist till.
skip-grant-tables
The following link says its a bug in MYSQL.
https://github.com/santisaez/powerstack/blob/master/packages/mysql/mysql-powerstack-secure_auth.patch
Do anyone have any fixes for this solution?
Solution
On the command line, use something like the following, if you have no choice...
Hope this helps someone, as this was my problem connecting from a Linux
mysql -uTheUseerNAme -pThePassword DbName -h HostName --skip-secure-authHope this helps someone, as this was my problem connecting from a Linux
Code Snippets
mysql -uTheUseerNAme -pThePassword DbName -h HostName --skip-secure-authContext
StackExchange Database Administrators Q#47842, answer score: 8
Revisions (0)
No revisions yet.