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

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