Rails - Mysql database already exists but it doesn't exist

Question

I'm trying run a rake db:create and it says that the database already exists (I never created this database before, this a new project). When I run rake db:migrate it says "Unknown database". I checked the mysql database (show databases;) and that database really does not exist.

Anyone knows what is that? I searched for solutions but without success.

When I run rake db:create

rake db:create
Celluloid 0.17.3 is running in BACKPORTED mode. [ http://git.io/vJf3J ]
adimax_development already exists
adimax_test already exists

When I run rake db:migrate

rake db:migrate
Celluloid 0.17.3 is running in BACKPORTED mode. [ http://git.io/vJf3J ]
rake aborted!
Mysql2::Error: Unknown database 'adimax_development'

database.yml

development:
 adapter: mysql2
 encoding: utf8
 database: adimax_development
 pool: 5
 username: root
 password:

Error: Error image:

what does your `database.yml` file define as the host and port? That file will tell Rails how to connect to the MySql db server — Darkisa, Mar 23 '18 at 02:21
@sameera207 I updated the question with my database.yml. Thanks — Felipe Marcon, Mar 26 '18 at 12:45
@Darkisa I updated the question with my database.yml. Thanks — Felipe Marcon, Mar 26 '18 at 12:45
Are you able to go into the mysql instance with `rails dbconsole`? — Leo Correa, Mar 30 '18 at 14:53
@LeoCorrea when a run command **rails dbconsole** the following error occurs: **rails dbconsole Celluloid 0.17.3 is running in BACKPORTED mode. [ http://git.io/vJf3J ] ERROR 1049 (42000): Unknown database 'adimax_development'** — Felipe Marcon, Mar 30 '18 at 16:35

score 5 · Answer 1 · edited Mar 23 '18 at 10:27

5

Try executing this command:

rake db:drop db:create db:migrate

Reference: https://stackoverflow.com/a/4116124/9336629

edited Mar 23 '18 at 10:27

Pang

9,564
146
81
122

answered Mar 23 '18 at 06:48

Prashant Patel

179
1
2
13

When I try a "rake db: drop" the Rails says that the database is unknown, but when I try created a new one, he says the database already exists. – Felipe Marcon Mar 26 '18 at 12:48
1

Did you try db:reset then db:migrate ? – Prashant Patel Mar 27 '18 at 04:36
Yes, but he says tha the database is unknow. – Felipe Marcon Mar 27 '18 at 12:12
You should also be able to do that with `rake db:{drop,create,migrate}` – Allison Jul 18 '19 at 01:14

score -2 · Accepted Answer · answered Apr 22 '18 at 18:19

I got solve this creating the database directly in mysql.

I entered in mysql with mysql -u root and than I run "CREATE DATABASE adimax_development;". After this I comeback to my application and run rake db:migrate and that worked.

Thanks to all those who have been willing to help.

Rails - Mysql database already exists but it doesn't exist

2 Answers2