"using old protocol refused" even when using long password hash?

[Angelina Belle]

I am attempting to make an ODBC connection to my MySQL database on a shared Linux server at ixwebhosting. I configure the ODBC connection, but fail every time I hit the "Test" button.

I even attempted forcing long-hash passwords through phpMyAdmin.
Neither "old" or "new" passwords worked.

I got the same message every time:

Quote

Connection Failed [HY000][MySQL][ODBC 5.2(w) Driver] Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

The host is using protocol version 10m 5.1.68-community-log, i686, pc-Linux-gnu
with secure_auth off and old_passwords on

Solution:

I downloaded and used the latest 3.51 MySQL ODBC driver.

Works great!

(a good deal of pointless information about stupid things I tried has been removed from this post. One individual from tech support told me that only windows web hosting customers would be able to connect to MySQL via ODBC, but this is apparently not true.)



Edited 8 time(s). Last edit at 03/10/2014 10:30AM by Angelina Belle.