I was using MySQLdb to connect to a database on a remote server.
I recently switched hosting providers and with the new provider I am unable to connect to the database. I am receiving the following error.
Error 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
I have talked to the support people at the hosting company and they are telling me that my SQL client is using an old hashing scheme that is no longer supported. However, the documentation for MySQLdb seems to indicate that the new hashing scheme is supported by default.
Any idea how to fix this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I was using MySQLdb to connect to a database on a remote server.
I recently switched hosting providers and with the new provider I am unable to connect to the database. I am receiving the following error.
Error 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
I have talked to the support people at the hosting company and they are telling me that my SQL client is using an old hashing scheme that is no longer supported. However, the documentation for MySQLdb seems to indicate that the new hashing scheme is supported by default.
Any idea how to fix this?