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

laravel db connection issue

Add Answer

Talha Fayyaz answered on March 30, 2022 Popularity 9/10 Helpfulness 4/10

answer laravel db connection issue

related laravel get db connection info

related laravel database connection

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 laravel php

Link to this answer
Share Copy Link

Contributed on Nov 06 2022

Talha Fayyaz

0 Answers Avg Quality 2/10

Closely Related Answers

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

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 9/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: database-connection data

Link to this answer
Share Copy Link

Contributed on May 31 2024

Poor Pygmy

0 Answers Avg Quality 2/10

laravel db connection issue

Contents

More Related Answers

laravel db connection issue

Closely Related Answers

laravel get db connection info

laravel database connection

Grepper

Documentation

Social

Legal

Contact

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