CODEWITHSUNDEEP
pythonmysqlmacosmysql-python
AKFourSeven
AKFourSeven

Reputation: 1325

mysql-python mac OSX 10.10 disable secure auth

Working on a python app on Mac (Yosemite OSX 10.10) I ran into this issue:

OperationalError: (2049, "Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)")

With a bit of research it seemed that my client (that is mysql-python) is using secure auth and the user had a password encrypted in an old style, that is prior to pre-4.1.1.

As I do not have ways to handle things on the DB side I was wondering if there was a workaround or a way to deactivate secure_auth on mysql-python?

Upvotes: 1

Views: 766

Answers (2)

AKFourSeven
AKFourSeven

Reputation: 1325

I found a cure!

Or rather a workaround. From this post I decided to select slightly older version of MySQL and MySQLdb and this solved the issue.

Here is how I did it:

I had previously installed mysql_python for my python and had the brew version of mysql installed.

I deteleted all of that.

I look for a way to install MySQLdb by looking for it last stable version with the source.

I compiled them (followed the isntructions here), installed them and then I looked for a stable version of MySQL client (MySQL website is the best place for that) and install the 5.5 version which was perfectly fitting my requirements.

I made mysql to launch itself automatically and then restarted my computer (but you can just restart apache) and check that all path were correct and the right includes are in the right places (you can check that against the link above).

And now it all works fine!

Hope it helps.

Upvotes: 0

user4103576
user4103576

Reputation:

I am adapting the answer from here:

Eventually you have to tell the client who has an old-style password to change it to a new-style password. Old passwords are not secure.

Now, you are getting the error since the client has secure_auth set, but they have an old password. In order to login with the old password, the client must disable secure_auth on the client side. How exactly you do this varies by which client you're using.

Some other workarounds can be found in the MySQL documentation: Client does not support authentication protocol

Upvotes: 2

Related Questions