rake db:create - Mysql2::Error: Unknown database

Question

I am trying to create a database using rake db:create task.

When I am running the command bundle exec rake db:create to create the database and load the schema, I get the 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 that mysql server is running and I am able to connect to it using the password/username I have in the database.yml

I also understand that I can go ahead and create the database in mysql and then run the bundle exec rake db:create but isn't the rake task db:create also creates a database in case it doesn't exists?

The rails version is 3.2.22. and mysql2 version is 2.9.13.

Any pointers will be highly appreciated.

Vasfed · Accepted Answer · 2016-10-12 14:56:28Z

1

If you are using ohmyzsh with bundler plugin which makes rake run by default with bundle exec, you can use

unbundled_rake db:create

answered Oct 12, 2016 at 14:56

Vasfed

18.6k10 gold badges56 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Coding Enthusiast · Accepted Answer · 2019-10-04 15:50:21Z

1

Ran into a similar issue on Rails 5 and the following steps helped me fix it:

Spring stop

./bin/rails db:create

answered Oct 4, 2019 at 15:50

Coding Enthusiast

3,9331 gold badge31 silver badges50 bronze badges

Comments

DGuimar · Accepted Answer · 2016-02-02 23:30:05Z

0

I have two ideas.

Check the User permissions
When I run rake tasks, I don't use bundle exec (i.e just rake db:create)

Hope this is helpful

answered Feb 2, 2016 at 23:30

DGuimar

355 bronze badges

1 Comment

harshs08 Over a year ago

I have all the permissions for the mysql user but same error.

Ravendra Kumar · Accepted Answer · 2016-02-03 07:06:50Z

0

Try rake db:create RAILS_ENV=development hope this will work

answered Feb 3, 2016 at 7:06

Ravendra Kumar

1,08210 silver badges29 bronze badges

2 Comments

René Vogt Over a year ago

@Undo thanks for the link. I see your point and have to apologise, I clearly misunderstood the concept. Will keep that in mind. Thanks again for pointing that out to me.

Undo Over a year ago

No problem @RenéVogt :)

lacostenycoder · Accepted Answer · 2022-11-29 19:40:20Z

0

For some reason rails db:create failed but my workaround was

to create dbs directly in mysql

sudo mysql
create database myapp_development;
create database myapp_test;

After that run as normal

rake db:migrate db:seed

answered Nov 29, 2022 at 19:40

lacostenycoder

11.3k4 gold badges37 silver badges50 bronze badges

Collectives™ on Stack Overflow

rake db:create - Mysql2::Error: Unknown database

5 Answers 5

Comments

Comments

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related