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> GRANT ALL PRIVILEGES ON blog_development.* -> TO 'blog'@'localhost' -> IDENTIFIED BY 'newpassword'; Query OK, 0 rows affected (0.01 sec) mysql> SHOW GRANTS FOR 'blog'@'localhost' -> ; +----------------------------------------------------------------------------------------- --------------------+ | Grants for blog@localhost | +----------------------------------------------------------------------------------------- --------------------+ | GRANT USAGE ON *.* TO 'blog'@'localhost' IDENTIFIED BY PASSWORD '*FE4F2D624C07AAEBB979DA5C980D0250C3…

Accepted Answer

blog_development doesn't exist

You can see this in sql by the `0 rows affected` message

create it in mysql with

```
mysql> 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
```

ERROR 1049 (42000): Unknown database

Solution

Problem