Why does the database migration fail?

Question

MySQL

Hello everybody! Please explain why the error shown below occurs when migrating a database to a project:

In the process of restoring the dump occurred error: SQLSTATE[HY000] [1045] Access denied for user 'shop'@'localhost' (using password: YES)

The name of the database and the user of the database is fedorov_shop, and in the error it displays the user name shop

'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=localhost;dbname=fedorov_shop',
'username' => 'fedorov_shop',
'password' => '***',
'charset' => 'utf8',
'enableSchemaCache' => true,
'schemaCacheDuration' => 3600,

Answer 1

Access denied for user 'shop '@'localhost'

configs? Search by string in a project?
PS: a couple of months ago, something similar slipped, like different configs for different environments were connected somewhere.

Answer 2

Good morning.
Which template are you using, advanced or base?
Are there any other configs?
During migration, you can explicitly specify which database to migrate to.
In the config file

'db' => [
   'class' => 'yii\db\Connection',
   'dsn' => 'mysql:host=localhost;dbname=fedorov_shop',
   'username' => 'fedorov_shop',
   'password' => '***',
   'charset' => 'utf8',
   'enableSchemaCache' => true,
   'schemaCacheDuration' => 3600,
]

On the command line.
You can also specify in the migration itself which database to work with.

public function init()
    {
        $this->db = 'db2';
        parent::init();
    }