Breaking News: Grepper is joining You.com. Read the official announcement!

laravel database connection

Add Answer

Poor Pygmy answered on December 10, 2020 Popularity 6/10 Helpfulness 3/10

answer laravel database connection

related laravel database connection check

related laravel get db connection info

related check which database connect laravel

related laravel db connection issue

related connect database to laravel

related DB::connection('local')->create() laravel

laravel database connection

Comment

// config/database.php

'connections' => [
    'mysql' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'forge'),
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'strict' => true,
        'engine' => null,
    ],
    'mysql2' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST_SECONDARY', '127.0.0.1'),
        'port' => env('DB_PORT_SECONDARY', '3306'),
        'database' => env('DB_DATABASE_SECONDARY', 'forge'),
        'username' => env('DB_USERNAME_SECONDARY', 'forge'),
        'password' => env('DB_PASSWORD_SECONDARY', ''),
        'unix_socket' => env('DB_SOCKET_SECONDARY', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'strict' => true,
        'engine' => null,
    ],
],

// config/session.php

'driver' => env('SESSION_DRIVER', 'file'),
(or) 'driver' => env('SESSION_DRIVER', 'database')

'connection' => env('SESSION_CONNECTION', null),

// .env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_main_database
DB_USERNAME=your_main_db_user
DB_PASSWORD=your_main_db_password

DB_CONNECTION_SECONDARY=mysql2
DB_HOST_SECONDARY=127.0.0.1
DB_PORT_SECONDARY=3306
DB_DATABASE_SECONDARY=your_session_database
DB_USERNAME_SECONDARY=your_session_db_user
DB_PASSWORD_SECONDARY=your_session_db_password

SESSION_DRIVER=database
SESSION_CONNECTION=mysql2


//// migrate session table

php artisan session:table
php artisan migrate --database=mysql2

Popularity 6/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: database-connection laravel php

Link to this answer
Share Copy Link

Contributed on May 31 2024

Poor Pygmy

0 Answers Avg Quality 2/10

Closely Related Answers

laravel database connection check

Comment

use Illuminate\Support\Facades\DB;

// Test database connection
try {
    DB::connection()->getPdo();
} catch (\Exception $e) {
    die("Could not connect to the database.  Please check your configuration. error:" . $e );
}

Popularity 10/10 Helpfulness 8/10 Language php

Source: stackoverflow.com

Tags: database-connection data

Link to this answer
Share Copy Link

Contributed on May 10 2022

Irfan

0 Answers Avg Quality 2/10

laravel get db connection info

Comment

-1

if(DB::connection()->getDatabaseName())
   {
     echo "conncted sucessfully to database ".DB::connection()->getDatabaseName();
   }

Popularity 10/10 Helpfulness 6/10 Language php

Source: laracasts.com

Tags: connection c

Link to this answer
Share Copy Link

Contributed on Mar 30 2022

ssbrar

0 Answers Avg Quality 2/10

check which database connect laravel

Comment

DB::connection();

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: connect

Link to this answer
Share Copy Link

Contributed on Dec 10 2020

Lokesh003Coding

0 Answers Avg Quality 2/10

laravel db connection issue

Comment

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3308
DB_DATABASE=rentable
DB_USERNAME=root
DB_PASSWORD=

Popularity 9/10 Helpfulness 4/10 Language php

Source: stackoverflow.com

Tags: connection c

Link to this answer
Share Copy Link

Contributed on Nov 06 2022

Talha Fayyaz

0 Answers Avg Quality 2/10

connect database to laravel

Comment

1) go to http://localhost/phpmyadmin .
2) create a new table called job for example 
3) go to .env file in your laravel project then change these lignes:
DB_CONNECTION=mysql  
DB_HOST=127.0.0.1. 
DB_PORT=3306    
DB_DATABASE=name_of_database // => name should be exact as the table name you created .. in our example its job 
DB_USERNAME=root         
DB_PASSWORD=choose_your_password

Popularity 10/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: connect

Link to this answer
Share Copy Link

Contributed on Sep 04 2022

Hamza Othmani

0 Answers Avg Quality 2/10

DB::connection('local')->create() laravel

Comment

$users = DB::connection('foo')->select(...);

Popularity 9/10 Helpfulness 3/10 Language php

Source: laravel.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Aug 24 2021

Depressed Dotterel

0 Answers Avg Quality 2/10

laravel database connection

Contents

More Related Answers

laravel database connection

Closely Related Answers

laravel database connection check

laravel get db connection info

check which database connect laravel

laravel db connection issue

connect database to laravel

DB::connection('local')->create() laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.