rake db:drop, db:create don't work

Do you mean your 'mysql' host name is pointing to 'localhost' i.e. 127.0.0.1 ?

Yes.

Alright I tried to redo this

127.0.0.1 mysql
dscacheutil -flushcache

rake db:create
rake db:migrate
rake db:populate

all good so far.

Post.all => [Post....]

rake db:drop:all

This task only modifies local databases. blogstain_development is on a remote host.
This task only modifies local databases. blogstain_test is on a remote host.
This task only modifies local databases. blogstain_test is on a remote host.
Couldn't drop blogstain : #<Mysql::Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)>

However
rake db:drop works as intended.

So, if you wanna deal with the other environments, just set it before dropping;
RAILS_ENV="test" rake db:drop

Argh, can't edit post.
Thanks to NathanielJ from #railsbridge

This piece of code gets called when doing a rake db:drop:all
So.. basically it can't tell what addresses you got inside /etc/hosts :-)

def local_database?(config, &block)

if %w( 127.0.0.1 localhost ).include?(config['host']) || config['host'].blank?
  yield
else
  $stderr.puts "This task only modifies local databases. #{config['database']} is on a remote host."
end

end

This raises the question as to why the check => if %w( 127.0.0.1 localhost ).include?(config['host']) exists? Can somebody clear up as to why the remote db can't be dropped? One thing that comes to my mind is that most of the times the user of the remote db may not have permission to drop the entire db?

It is indeed to prevent people destroying data on separate hosts. if it points at localhost, why can't you just have it as localhost?

gucci watches