MySQL - Ruby on Rails mysql gem not working on snow leopard
This looks like a permissions problem.  Make sure you have a password set in your mysql and are able to login from the command line

mysql -u root -p


This should prompt you for your root password.  If you can login there, that means you should be set.  All you need to do then is put the password in your database.yml file and retry the rake command.