Client does not support authentication protocol requested by server
$ rake db:migrate (in /home/y_ando/products/shot_chat) rake aborted! Client does not support authentication protocol requested by server; consider upgrading MySQL client (See full trace by running task with --trace)
mysqlが古くて、rake db:migrateしたときに上のようなメッセージが出たら、次のようにする。
$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 187 Server version: 5.0.32-Debian_7-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> update user set Password = OLD_PASSWORD('password') where Host = 'localhost' AND User = 'user'; Query OK, 1 row affected (0.12 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.02 sec)