MySQL Connector/Python

Authentication error/Connection problem

Asked by ChiefDanGeorge

I've grabbed and built the 0.3.2 version of the connector on windows XP machine.
When trying to connect to a remote host running v4.1.22 I am getting the exception: NotSupportedError: Authentication with old (insecure) passwords is not supported: http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html

My connection attempt is as follows:
        db = mysql.connector.Connect(database=dbName, user=dbUser, password=dbPwd, host=dbHost, port=dbPort)
I've tried using the regular password as well as the password when trying: SELECT PASSWORD('mypass'); in MySQL.
I suspect it is because the database may be using old passwords even though the version is 4.1.22.
Is there a way to confirm this, I need to move on to another driver if I can't get this one working.

Thanks!

Dan

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Connector/Python Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Geert JM Vanderkelen (geertjmvdk) said : 		#1

You can check whether you are using old password by checking the the length in the mysql.user database.
See the MySQL manual for examples:
 http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html

Can you help with this problem?

Provide an answer of your own, or ask ChiefDanGeorge for more information if necessary.

To post a message you must log in.