Database [] not configured Laravel 5

Question

I create new db in phpmyadmin and new tables.

Then i do

    public function next(Request $request){
    $langs = DB::connection('mydb')->select('select * from lang');
    }

and get

Database [compgen] not configured.

in my .env

DB_HOST=localhost
DB_DATABASE=test
DB_USERNAME=root
DB_PASSWORD=123

in my config/database.php

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

'prefix' => 'test_' along with table named lang? This can cause conflict for eloquent builder I guess — Bartłomiej Sobieszek
– Bartłomiej Sobieszek, Commented Sep 29, 2016 at 20:56
Before you dig any deeper, make sure the file config/database.php is present... sounds stupid, but it happened to me when I cloned an external Laravel project where the author had not committed config/database.php for some reason! — Janaka Bandara
– Janaka Bandara, Commented Feb 2, 2019 at 1:41
I had a similar problem with Database [mysql] not configured. If I ran php artisan cache:clear or config:cache I would get the same error. I solved it by going into laravel/bootstrap/cache and deleting the config.php file that was there, and then running the above commands again. I believe it was a file permission error that was preventing the cached config.php file from actually being cleared. — Scotch Design
– Scotch Design, Commented Nov 22, 2019 at 5:11

Arthur Kushman · Accepted Answer · 2017-10-31 13:56:20Z

32

In my case I used 2 db connections and the second added was not cached, the command call: php artisan config:cache did the trick.

To see what's going on it was sufficient to output the $connections variable in DatabaseManager->configure method.

answered Oct 31, 2017 at 13:56

Arthur Kushman

3,65910 gold badges53 silver badges64 bronze badges

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

1 Comment

Luiza Rodrigues Over a year ago

In my case, i was with one connection, and then switch to another DB. I dont know much of Laravel, i already got the code from another person. I was trying to log on the system and it presents me the error: "Malformed UTF-8 characters!" So i was trying to modified the charset of database!! Thanks to your answer, now it works!

Samer Abu Gahgah · Accepted Answer · 2020-03-09 14:01:44Z

9

For me the connection worked in development but not in the production environment, so after a lot of searching, I had to rebuild the configuration cache and It has worked. I ran the following command in the laravel root directory:

php artisan config:cache

answered Mar 9, 2020 at 14:01

Samer Abu Gahgah

7511 gold badge9 silver badges18 bronze badges

Comments

Alexey Mezenin · Accepted Answer · 2016-09-29 16:49:00Z

8

You're using single connection, so you don't need to specify it:

$langs = DB::table('lang')->get();

You should use connection() method only when you're working with multiple DB connections.

answered Sep 29, 2016 at 16:49

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

1 Comment

barryvanveen Over a year ago

Or you could just call the correct DB connection (called "mysql") using $langs = DB::connection('mysql')->select('select * from lang');

jsonUK · Accepted Answer · 2018-09-18 15:31:02Z

Anyone stumbling upon this - if you are using Laravel 5.4 or newer, you can setup a new database connection in config/database.php

    'mysql_test' => [
        'driver'      => 'mysql',
        'host'        => env('DB_HOST', '127.0.0.1'),
        'port'        => env('DB_PORT', '3306'),
        'database'    => env('DB_DATABASE_TEST', 'forge'),
        'username'    => env('DB_USERNAME_TEST', 'forge'),
        'password'    => env('DB_PASSWORD_TEST', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset'     => 'utf8mb4',
        'collation'   => 'utf8mb4_unicode_ci',
        'prefix'      => '',
        'strict'      => false,
        'modes'       => [
            'ONLY_FULL_GROUP_BY',
            'STRICT_TRANS_TABLES',
            'NO_ZERO_IN_DATE',
            'NO_ZERO_DATE',
            'ERROR_FOR_DIVISION_BY_ZERO',
            'NO_AUTO_CREATE_USER',
            'NO_ENGINE_SUBSTITUTION',
        ],
        'engine' => null,
    ],

I created 3 new env variables DB_USERNAME_TEST, DB_PASSWORD_TEST, DB_DATABASE_TEST

Edit .env with something like

DB_DATABASE_TEST=test_db
DB_USERNAME_TEST=local
DB_PASSWORD_TEST=localpassword

Make sure config is refreshed: php artisan config:cache

You should be able to run a database migrate on your new test database, like so:

php artisan migrate:refresh --database=mysql_test

This configuration is giving error ... what could be be the possible reason

Andrew Fox · Accepted Answer · 2018-02-13 06:14:31Z

3

In my case it was a bad database username. I had it set in my config/database.php as well as the .env file and one of them was different than the other. Found this thread when searching, thought this might help someone.

answered Feb 13, 2018 at 6:14

Andrew Fox

9204 gold badges13 silver badges35 bronze badges

Comments

N. Djokic · Accepted Answer · 2020-05-13 21:07:17Z

2

I struggled with this error for a few hours and found out solution that works for me. If you can not delete cache with php artisan config:cache because it throws error after you run it:

[InvalidArgumentException]

Database [] not configured

And if you are sure that your connections parameters are good then try manually delete bootstrap cache config files which are placed in app/bootstrap/cache folder. Hope it helps someone.

answered May 13, 2020 at 21:07

N. Djokic

1,0561 gold badge8 silver badges21 bronze badges

Comments

Arun Panneerselvam · Accepted Answer · 2021-04-06 17:25:13Z

2

make sure the parameters

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=dbname
DB_USERNAME=dbuser
DB_PASSWORD="password"

and then issue,

php artisan optimize:clear

answered Apr 6, 2021 at 17:25

Arun Panneerselvam

2,3331 gold badge20 silver badges28 bronze badges

Comments

Zadiki Hassan Ochola · Accepted Answer · 2021-04-20 06:59:26Z

2

I had the same issue but when i added

'default' => env('DB_CONNECTION', 'mysql'),

to database.php.It seems to have solved the problem

answered Apr 20, 2021 at 6:59

Zadiki Hassan Ochola

7781 gold badge15 silver badges26 bronze badges

Comments

user15384820 · Accepted Answer · 2021-04-13 11:53:33Z

0

if this error shows when you use the validation so it is simple :) just check all the validation rules and messages are written > correctly

for me i faced this error and i solve it by replace only point by comma in the validation rules.

answered Apr 13, 2021 at 11:53

user15384820

1 Comment

shaedrich Over a year ago

Thank you for your answer, but can you explain how it is related to the problem in the question?

Collectives™ on Stack Overflow

Database [] not configured Laravel 5

9 Answers 9

1 Comment

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

1 Comment

Comments

1 Comment

1 Comment

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related