Laravel 5 store session in database/redis

Question

I want to use database (currently, MySQL) to store session. But, when I tried to config, table sessions still has no record.

In file config/session.php when I change 'driver' => env('SESSION_DRIVER', 'file'),

1. to 'driver' => env('SESSION_DRIVER', 'database'),
2. or 'driver' => env('SESSION_DRIVER', 'redis'),

What should I change for 'connection' => null,?

I tried:

1. 'connection' => 'mysql', with mysql is configured in app/database.php
2. 'connection' => 'database.connections.mysql',
3. 'connection' => Config::get('database.connections.mysql'), got class not found error

Answer 1

All you need to do is specify the right driver in the environment file, and generate the schema as outlined in the documentation.

This line:

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

This is telling the config to get the SESSION_DRIVER variable from your environment file, and use database as a default. I can only assume you have forgotten to update your .env file.