# Solved "Client does not support authentication protocol.."

**URL:** <https://www.ruby-forum.com/t/solved-client-does-not-support-authentication-protocol/176011>\
**Category:** Rails\
**Created:** [September 23, 2009, 5:31pm UTC](https://www.ruby-forum.com/t/solved-client-does-not-support-authentication-protocol/176011 "2009-09-23T17:31:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![agnathan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/919ad9/32.png) [@agnathan](https://www.ruby-forum.com/u/agnathan)\
**Post date:** [September 23, 2009, 5:31pm UTC](https://www.ruby-forum.com/t/solved-client-does-not-support-authentication-protocol/176011/1 "2009-09-23T17:31:45Z")

</div>

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

> **[Client does not support authentication protocol requested by server – Buayacorp](https://www.buayacorp.com/archivos/client-does-not-support-authentication-protocol-requested-by-server/)**
>
> Siempre que hago una nueva instalación de MySQL, y entro por phpMyAdmin para administrar mi base de datos me encuentro con el siguiente error: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL...

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