laravel database connection error 1049

Question

I am using Laravel 5 and I am having problems with my database conneciton:

Here is my database.php file:

'mysql' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', 'localhost'),
        'database'  => env('DB_DATABASE', 'my_scene'),
        'username'  => env('DB_USERNAME', 'root'),
        'password'  => env('DB_PASSWORD', 'root'),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
        'engine'    => null,
    ],

and here is my .env file:

DB_HOST=localhost

DB_DATABASE=my_scene

DB_USERNAME=root

DB_PASSWORD=null

however when i then run "php artisan migrate" i get the error

[PDOException] SQLSTATE[HY000] [1049] Unknown database 'my_scene'

I have tried php artisan cache:clear and config:cache and also reloaded my xampp controller but it has not worked.

any ideas?

I think it's trying with null as a string. Try DB_PASSWORD= and env('DB_PASSWORD', ''), instead — fmgonzalez
Try to unset DB_PASSWORD (remove) from .env file and set env('DB_PASSWORD', null). I've never try with a null password. I thought it was empty, nor null. — fmgonzalez

Azeem Hassni Azeem Hassni · Accepted Answer · 2016-02-24T15:21:49

Its not a connection error.

[PDOException] SQLSTATE[HY000] [1049] Unknown database 'my_scene'

indicates you've successfully connected to MySQL server. but there is no database matching the name my_scene

You can create a database by using any of the following methods.

1. MySQL Command Line Utility

You just have to create a database by executing this MySQL statement in your terminal

CREATE DATABASE my_scene;

read Creating Database via terminal

2. PHPMyAdmin

If you've a MySQL GUI i.e PHPMyAdmin you can easily create a database.

Refer to this article to read more about creating databases via PHPMyAdmin

3. Laravel's Command Line Utility [Artisan]

Maybe the simplest option using Laravel's artisan utility

Open Your terminal
Run php artisan tinker
Use the following snippet to create your database

DB::connection()->statement('CREATE DATABASE my_scene');

laravel database connection error 1049

3 Answers

1. MySQL Command Line Utility

2. PHPMyAdmin

3. Laravel's Command Line Utility [Artisan]