数据库密码是项目中默认的;
我用Navicat从本机可以连接到服务器的数据库。
[root@iZwz9d8w93w30eiokzks1fZ yii2_fecshop_docker]# docker-compose exec php bash
root@5b12795777ee:/var/www/html# cd /www/web/fecshop
root@5b12795777ee:/www/web/fecshop# ./yii migrate --interactive=0 --migrationPath=@fecshop/migrations/mysqldb
Yii Migration Tool (based on Yii v2.0.15.1)
Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [2002] Connection refused'
in /www/web/fecshop/vendor/yiisoft/yii2/db/Connection.php:624
Stack trace:
#0 /www/web/fecshop/vendor/yiisoft/yii2/db/Connection.php(996): yii\db\Connection->open()
#1 /www/web/fecshop/vendor/yiisoft/yii2/db/Connection.php(983): yii\db\Connection->getMasterPdo()
#2 /www/web/fecshop/vendor/yiisoft/yii2/db/Command.php(253): yii\db\Connection->getSlavePdo()
#3 /www/web/fecshop/vendor/yiisoft/yii2/db/Command.php(1143): yii\db\Command->prepare(true)
#4 /www/web/fecshop/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal('fetchAll', NULL)
#5 /www/web/fecshop/vendor/yiisoft/yii2/db/mysql/Schema.php(312): yii\db\Command->queryAll()
#6 /www/web/fecshop/vendor/yiisoft/yii2/db/mysql/Schema.php(125): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema))
#7 /www/web/fecshop/vendor/yiisoft/yii2/db/Schema.php(744): yii\db\mysql\Schema->loadTableSchema('migration')
#8 /www/web/fecshop/vendor/yiisoft/yii2/db/Schema.php(194): yii\db\Schema->getTableMetadata('{{%migration}}', 'schema', true)
#9 /www/web/fecshop/vendor/yiisoft/yii2/console/controllers/MigrateController.php(210): yii\db\Schema->getTableSchema('{{%migration}}', true)
#10 /www/web/fecshop/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(875): yii\console\controllers\MigrateController->getMigrationHistory(NULL)
#11 /www/web/fecshop/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(166): yii\console\controllers\BaseMigrateController->getNewMigrations()
#12 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0)
#13 /www/web/fecshop/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#14 /www/web/fecshop/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#15 /www/web/fecshop/vendor/yiisoft/yii2/console/Controller.php(148): yii\base\Controller->runAction('', Array)
#16 /www/web/fecshop/vendor/yiisoft/yii2/base/Module.php(528): yii\console\Controller->runAction('', Array)
#17 /www/web/fecshop/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('migrate', Array)
#18 /www/web/fecshop/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('migrate', Array)
#19 /www/web/fecshop/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest(Object(yii\console\Request))
#20 /www/web/fecshop/yii(82): yii\base\Application->run()
#21 {main}