How to connect console Yii2 advanced to database?

Question

Yii

Hello.
There is a database connection and it works in frontend and backend. But in console it refuses to run.
Where to configure the connection to the database in the console folder?

Answer 1

In main-local.php:

'db'     => [
    'class' => 'yii\db\Connection',
    'dsn'      => 'mysql:host=localhost;dbname=my_db',
    'username' => 'db_user',
    'password' => 'db_password',
//                'enableSchemaCache'   => true,
//                'schemaCacheDuration' => 3600,
//                'tablePrefix'         => '',
//                'charset'             => 'utf8mb4',
//                'enableQueryCache'    => true,
//                'queryCacheDuration'  => 600,
],

In a good way, the connection (if it is common for backend && frontend && console) should be moved to main-local.php in the folder common. And configure all configuration files in a folder environmentsand run php init.