MySQL Forums
Forum List  »  Connector/ODBC

Re: "using old protocol refused" even when using long password hash?
Posted by: Hemant Dangi
Date: March 26, 2014 09:15AM

Hello Angelina,

Thanks for showing interest in Mysql Connector/ODBC.

secure_auth is enabled which causes the server to block connections by clients that attempt to use accounts that have passwords stored in the old (pre-4.1) format.
Either, you can disable secure_auth in my.cnf
secure_auth = 0
or, upgrade your password to use newer password format using below method:
> set old_passwords=0; set password for 'user'@'%' = password('oldpassword');

You seems to be already aware of these, but this error has nothing to do with MyODBC driver so you need to recheck if you didn't missed anything here. Check below link for more details:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

If this still doesn't solve your issue, you can always file a bug in bugs.mysql.com.

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Re: "using old protocol refused" even when using long password hash?
March 26, 2014 09:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.