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

connect database to laravel

Hamza Othmani answered on September 4, 2022 Popularity 10/10 Helpfulness 4/10

answer connect database to laravel

related laravel database connection

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

Link to this answer
Share Copy Link

Contributed on Sep 04 2022

Hamza Othmani

0 Answers Avg Quality 2/10

Closely Related Answers

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

connect database to laravel

Contents

More Related Answers

connect database to laravel

Closely Related Answers

laravel database connection

Grepper

Documentation

Social

Legal

Contact

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