Help about MovableType

[tomtom]

When I was installing MovableType , I got error message 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'.

I searched and found below at MT-homepage.

Client does not support authentication protocol requested by server; consider upgrading MySQL client

A change was made in MySQL 4.1 and higher to the password authentication process, and this change is not backward-compatible. Every MySQL client has to be updated in order to work with this new version of MySQL.

The DBD::mysql module is the "MySQL client" in this case, and it has not yet been updated for this change, so you will need to either 1) reset the password to pre-4.1 style for your database user, or 2) tell the server to use the older password hashing algorithm. Instructions for both of these options are included in the MySQL documentation for this error message.


Both methods are difficult to using MT.
How can I do?

[djn]

I've recently upgraded to 4.1 on my test machine and had the same problem, solved it with this SQL command-line instruction:
SET PASSWORD FOR 'username'@'localhost' = OLD_PASSWORD('newpassword');

Hope it helps...

[AndrewT]

Submit a trouble ticket and we can update the DBD::mysql module.

[tomtom]

Thank you, djn.
but I don't permit my customers to use Shell Access.
also I don't have confident to use command-line.

I submitted trouble ticket.
Andrew may solve this in few days.

[tomtom]

Andrew updated the DBD::mysql on cp33.
And it works completely.