Authentication error/Connection problem

Asked by ChiefDanGeorge on 2012-02-28

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:

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.



Question information

English Edit question
MySQL Connector/Python Edit question
No assignee Edit question
Last query:
Last reply:

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:

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.