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
– fmgonzalez, Commented Feb 24, 2016 at 14:14
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
– fmgonzalez, Commented Feb 24, 2016 at 14:55

Azeem Hassni · Accepted Answer · 2016-02-24 16:13:31Z

4

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');

edited Feb 24, 2016 at 16:13

answered Feb 24, 2016 at 15:21

Azeem Hassni

8861 gold badge13 silver badges28 bronze badges

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

5 Comments

Aaron Sherry Over a year ago

what is the command for creating a database in terminal? also i am simply trying to access the user db that is already created in laravel

Azeem Hassni Over a year ago

You've to create a database before running you migrations. see my updated answer to read how you can create a database via Terminal by using MySQL command line utility

Aaron Sherry Over a year ago

i mam simply trying to migrate the create users table and the create password table that are preinstalled with laravel

Azeem Hassni Over a year ago

to create users table first you need a database and this is what you've to create.

Azeem Hassni Over a year ago

checkout the 3rd option if you are not familiar with MySQL and PHPMyAdmin

Brandon Smith · Accepted Answer · 2016-02-24 14:22:04Z

0

In your config file, make DB_PASSWORD equal the empty string "" and leave the DB_PASSWORD out of the .env file.

Or, you can remove the null and leave the DB_PASSWORD as empty:

DB_PASSWORD=

This will signify an empty string for the password.

edited Feb 24, 2016 at 14:22

answered Feb 24, 2016 at 14:16

Brandon Smith

2401 silver badge12 bronze badges

5 Comments

Brandon Smith Over a year ago

Does the database exist?

Aaron Sherry Over a year ago

what do you mean does that database exist?

Brandon Smith Over a year ago

You need to create the database before you can successfully connect to it. Laravel doesn't create that for you.

Aaron Sherry Over a year ago

but does the user table and password reset table not count as pre installed tables?

Brandon Smith Over a year ago

Tables are not databases. You must create a database first, then use Laravel to create the users and password resets table.

Ahmed · Accepted Answer · 2020-04-08 09:04:54Z

0

I was facing the same error and I was able to solve it.

I'm using Laravel 7 with WampServer 3.2 and I have installed two databases MySQL and Maria DB

So I created the database with MySQL using PhpMyAdmin and I was getting the 1049 error when using php artisan migrate

Then I created the database with MariaDB (using PhpMyAdmin) and the Migration was successful so Laravel was trying to connect to MariaDB database but there was no database (with the correct connection values)

edited Apr 8, 2020 at 9:04

answered Apr 7, 2020 at 17:54

Ahmed

11 bronze badge

Collectives™ on Stack Overflow

laravel database connection error 1049

3 Answers 3

1. MySQL Command Line Utility

2. PHPMyAdmin

3. Laravel's Command Line Utility [Artisan]

5 Comments

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1. MySQL Command Line Utility

2. PHPMyAdmin

3. Laravel's Command Line Utility [Artisan]

5 Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related