laravel database connection returns undefined index error

Question

I am developing a project using laravel 4 framework. In my database.php file I get the following error:

  Undefined index: driver

And my connection is as following:

    $connections = array(
            'mysql' => array(
                'read' => array(
                    'host'      => 'localhost',
                    'driver'    => 'mysql',
                    'database'  => 'app_system',
                    'username'  => 'root',
                    'password'  => 'root',
                    'charset'   => 'utf8',
                    'collation' => 'utf8_unicode_ci',
                    'prefix'    => '',
                ),
                'write' => array(
                    'host'      => 'localhost',
                    'driver'    => 'mysql',
                    'database'  => 'app_system',
                    'username'  => 'root',
                    'password'  => 'root',
                    'charset'   => 'utf8',
                    'collation' => 'utf8_unicode_ci',
                    'prefix'    => '',
                ),
            ),

            'mysql2' => array(
                'read' => array(
                    'host'  => 'localhost',
                    'driver'    => 'mysql',
                    'database'  => 'app_userdata',
                    'username'  => 'root',
                    'password'  => 'root',
                    'charset'   => 'utf8',
                    'collation' => 'utf8_unicode_ci',
                    'prefix'    => '',                      
                ),
                'write' => array(
                    'host'  => 'localhost',
                    'driver'    => 'mysql',
                    'database'  => 'app_userdata',
                    'username'  => 'root',
                    'password'  => 'root',
                    'charset'   => 'utf8',
                    'collation' => 'utf8_unicode_ci',
                    'prefix'    => '',                      
                ),
            )
        );

I am also using environments in order to set different mysql connections. What is wrong with the code?

Jojodmo · Accepted Answer · 2016-01-14 04:47:21Z

6

In my case it was because I deleted

'default' => 'mysql',

by mistake from app/config/database.php.

edited Jan 14, 2016 at 4:47

Jojodmo

23.6k13 gold badges69 silver badges112 bronze badges

answered Jul 2, 2015 at 4:01

ubuntus

1932 silver badges6 bronze badges

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

Comments

Martin Prikryl · Accepted Answer · 2014-01-20 07:54:29Z

3

Moving the 'driver' key up a level should fix the issue.

$connections = array(
    'mysql' => array(
        'read' => array(
            'host'      => 'localhost',
            'database'  => 'app_system',
            'username'  => 'root',
            'password'  => 'root',
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),
        'write' => array(
            'host'      => 'localhost',
            'database'  => 'app_system',
            'username'  => 'root',
            'password'  => 'root',
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),
        'driver' => 'mysql'
    ),

Most of the other params that are shared can me moved as well

$connections = array(
    'mysql' => array(
        'read' => array(
            'host'      => 'localhost',
        ),
        'write' => array(
            'host'      => 'localhost',
        ),
        'driver'    => 'mysql',
        'database'  => 'app_system',
        'username'  => 'root',
        'password'  => 'root',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
    ),

edited Jan 20, 2014 at 7:54

Martin Prikryl

205k64 gold badges559 silver badges1.1k bronze badges

answered Jan 20, 2014 at 7:34

EspadaV8

6685 silver badges13 bronze badges

2 Comments

Onur Over a year ago

I did it but it does not work. I also updated laravel to 4.1 and still get the error.

EspadaV8 Over a year ago

Are you still getting the same error? I copy/pasted that code from a working L4.1 site that I've been working on (just changing the values). You will need to make the changes to the mysql2 section as well (although I would initially try with just 1 connection section for debugging).

Noe Lopez · Accepted Answer · 2016-06-25 16:16:21Z

3

This happens to me because I deleted

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

From app/config/database.php. It's necesary have a default connection

answered Jun 25, 2016 at 16:16

Noe Lopez

3151 silver badge5 bronze badges

Comments

a3rxander · Accepted Answer · 2016-01-14 04:19:42Z

1

Go to root directory .env This values are taken first.

answered Jan 14, 2016 at 4:19

a3rxander

9062 gold badges10 silver badges19 bronze badges

Comments

The Unknown Dev · Accepted Answer · 2017-09-08 16:04:29Z

0

If you have multiple different connections (for example to multiple databases on the same host) and it doesn't make sense to set a default connection, you can specify a connection in the Model class.

<?php 
namespace App\Http\Models;

use Illuminate\Database\Eloquent\Model;

class Character extends Model {

    protected $connection = 'my_db_connection_name_here';
}

This would be on the of the connections defined in config/database.php.

answered Sep 8, 2017 at 16:04

The Unknown Dev

3,1384 gold badges30 silver badges46 bronze badges

Comments

veyselsahin · Accepted Answer · 2018-11-22 07:30:55Z

0

I solved my problem by adding some permissions. My .env file was exists but wasn't readable. I just added 755 permission.

answered Nov 22, 2018 at 7:30

veyselsahin

3884 silver badges14 bronze badges

Collectives™ on Stack Overflow

laravel database connection returns undefined index error

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related