ruby on rails - rake db:create - Mysql2::Error: Unknown database -

i trying create database using rake db:create task.

when running command bundle exec rake db:create create database , load schema, following error:

rake aborted! mysql2::error: unknown database 'xxx_development' 

my database.yml:

development:   adapter: mysql2   host: localhost   reconnect: true   username: user   password: password   pool: 50   database: xxx_development 

i checked mysql server running , able connect using password/username have in database.yml

i understand can go ahead , create database in mysql , run bundle exec rake db:create isn't rake task db:create creates database in case doesn't exists?

the rails version 3.2.22. , mysql2 version 2.9.13.

any pointers highly appreciated.

if using ohmyzsh bundler plugin makes rake run default bundle exec, can use

unbundled_rake db:create