Why do I get SQLSTATE[HY000] [2002] Connection refused, while database migrations work?

Question

MySQL

Trying to use YII locally with docker. Set up the DB. Migrations work fine, but when I try to write or read something from the user table, for example, I get an error:

Database Exception – yii\db\Exception
SQLSTATE[HY000] [2002] Connection refused

Caused by: PDOException
SQLSTATE[HY000] [2002] Connection refused
in /var/www/project.test/vendor/yiisoft/yii2/db/Connection.php at line 687

Changed 127.0.0.1 to localhost.

Answer 1

Correct answer
I had to make TWO(!) configs . Separately for the console and for the rest of the application. difference in
dsn.
For the console
'dsn' => 'mysql:host=127.0.0.1;dbname=project',
For the rest of the application
'dsn' => 'mysql:host=mysql;dbname=project',

Answer 2

because the console command and the site have different configs and connections. Look for the problem in yii configs.