Solved "Client does not support authentication protocol.."

I decide to new post because I posted with MySQL title which dont say
nothing about the real problem

So when i get the message

"Client does not support authentication protocol requested by server;

consider upgrading MySQL client"

or after run rake db:create

get error message “could create table…”


after spend time I and look carefully the messages

google the message “Client does not support…” and found the next link

http://www.buayacorp.com/archivos/client-does-not-support-authentication-protocol-requested-by-server/#commentform

where Braulio teach why is the problem and how to solve it

is something about authentication protocol issue with mysql 4.1. -> 5.0
and rails 2.3.4

and solve as this

get into mysql

$mysql -u root -p
enter your pwd
and then enter the line

SET PASSWORD FOR ‘root’@‘localhost’ = OLD_PASSWORD(‘pwd’);

and thats it!

quit the mysql session

run rake db:migrate
then script/server
get into localhost:3000
and is working now

slds