ERROR 1049 42000 Unknown database

Question

I can t seem to login to my tutorial database development environment    Ayman  mysql -u blog -p blog development Enter password   ERROR 1049  42000   Unknown database  blog development    I can login to the database fine without the blog development portion   Ayman  mysql -u blog -p Enter password   Welcome to the MySQL monitor   Commands end with   or  g  Your MySQL connection id is 1858   Not sure what gives as I granted all access   mysql gt  GRANT ALL PRIVILEGES ON blog development       - gt  TO  blog   localhost      - gt  IDENTIFIED BY  newpassword   Query OK  0 rows affected  0 01 sec   mysql gt  SHOW GRANTS FOR  blog   localhost      - gt     ----------------------------------------------------------------------------------------- --------------------     Grants for blog localhost                                                                                            ----------------------------------------------------------------------------------------- --------------------    GRANT USAGE ON     TO  blog   localhost  IDENTIFIED BY PASSWORD      FE4F2D624C07AAEBB979DA5C980D0250C37D8F63      GRANT ALL PRIVILEGES ON  blog    TO  blog   localhost                                                             GRANT ALL PRIVILEGES ON  blog development    TO  blog   localhost                                               ----------------------------------------------------------------------------------------- --------------------  3 rows in set  0 00 sec    Anybody have a clue what to try  Thanks  Also  side note- is it weird I have multiple root users    mysql gt  select User from mysql user   ------    User    ------    root     root              root              blog     root    ------  7 rows in set  0 00 sec    Edit  for those asking- I created the database blog with the CREATE DATABASE command in MySql  Here are my active databases   mysql gt  SHOW DATABASES   --------------------    Database              --------------------      information schema     blog                   mysql                  performance schema     test                  --------------------   5 rows in set  0 00 sec

User · Answer

Its a common error which happens when we try to access a database which doesn't exist. So create the database using

CREATE DATABASE blog_development;

The error commonly occours when we have dropped the database using

DROP DATABASE blog_development;

and then try to access the database.

User · Answer

blog development doesn t exist  You can see this in sql by the 0 rows affected message  create it in mysql with  mysql gt  create database blog development   However as you are using rails you should get used to using    rake db create   to do the same task   It will use your database yml file settings  which should include something like   development    adapter  mysql2   database  blog development   pool  5   Also become familiar with     rake db migrate    Run the database migration   rake db seed       Run thew seeds file create statements   rake db drop       Drop the database

User · Answer

Very simple solution  Just rename your database and configure your new database name in your project   The problem is the when you import your database  you got any errors and then the database will be corrupted  The log files will have the corrupted database name  You can rename your database easily using phpmyadmin for mysql   phpmyadmin - gt  operations - gt  Rename database to

[mysql] ERROR 1049 (42000): Unknown database

Examples related to mysql